Basic Node Information

The below two queries will help us to identify about the environment.

SQL> set pagesize 50 

SQL> col node_name format a15 

SQL> col server_id format a8 

SQL> col server_address format a15 

SQL> col platform_code format a4 

SQL> col webhost format a12 

SQL> col domain format a20 

SQL> col virtual_ip format a12 

SQL> set linesize 132 

select 

SQL> 2 node_id, 

3 platform_code, 

4 support_db D, 

support_cp C, 

5 6 support_admin A, 

7 support_forms F, 

8 support_web W, 

9 node_name, 

10 server_id, 

11 server_address, 

12 domain, 

13 webhost, 

14 virtual_ip 

15 from 

fnd_nodes 

16 17 order by node_id; 

NODE_ID PLAT D C A F W NODE_NAME SERVER_I SERVER_ADDRESS DOMAIN WEBHOST VIRTUAL_IP 

---------- ---- - - - - - --------------- -------- --------------- -------------------- ------------ ------------ 

8142 212 Y Y Y Y Y TRAINING ACC0C9B7 192.168.101.31 iasri.res.in TRAINING.ias training 

5E4E0096 ri.res.in 

E043C0A8 

651F9697 

19452395 

78983212 

25176481 

97992738 

8143 212 N N N N N AUTHENTICATION SECURE * 

SQL> set linesize 132 

SQL> set pagesize 132 

SQL> col NAME format A20 

SQL> col HOST format A20 

SQL> col RELEASE format A12 

SQL> col VERSION format A12 

SQL> select i.instance_name NAME, i.host_name HOST, 

2 f.release_name RELEASE, i.version VERSION 

3 from v$instance i,fnd_product_groups f 

4 where upper(substr(i.instance_name,1,4)) = 

5 upper(substr(f.applications_system_name,1,4)); 

NAME HOST RELEASE VERSION 

-------------------- -------------------- ------------ ------------ 

TRN TRAINING 12.1.3 11.2.0.3.