Connecting to 10.1.4.21:22...

Connection established.

To escape to local shell, press 'Ctrl+Alt+]'.

Last login: Mon Oct 14 13:58:58 2013 from 10.1.4.39

[root@db1 ~]# su - oracle

urpdb1:/home/oracle@db1>echo $ORACLE_SID

urpdb1

urpdb1:/home/oracle@db1>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 14 15:16:57 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

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

urpdb1 OPEN

SQL> !

[oracle@db1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-OCT-2013 15:17:29

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date 03-SEP-2013 14:35:17

Uptime 41 days 0 hr. 42 min. 11 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/grid/product/11.2.0/grid_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/db1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.4.21)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.4.22)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "urpdb" has 1 instance(s).

Instance "urpdb1", status READY, has 1 handler(s) for this service...

Service "urpdbXDB" has 1 instance(s).

Instance "urpdb1", status READY, has 1 handler(s) for this service...

Service "ywkdb" has 1 instance(s).

Instance "ywkdb1", status READY, has 1 handler(s) for this service...

Service "ywkdbXDB" has 1 instance(s).

Instance "ywkdb1", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@db1 ~]$ export ORACLE_SID=ywkdb1

[oracle@db1 ~]$ echo $ORACLE_SID

ywkdb1

[oracle@db1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 14 15:18:18 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

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

ywkdb1 OPEN

SQL>