Hi experts,
I have the following environment:
+ 2 Linux Redhat 5.7 0n X86/64 named dwh and stb and Oracle 11.2.0.2,
+ Database on dwh is primary and on stb is standby
the listener on dwh:
ADR_BASE_LISTENER=/u00/app/oracle
LISTENER =
(ADDRESS_LIST =
# for external procedure calls, create a separate listener
# See basenv_user_guide.pdf for details (chapter of listener.ksh)
(ADDRESS =
(PROTOCOL = TCP)
(Host = dwh )
(Port = 1521)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
# Next line is necessary for dataguard >= 10g
(GLOBAL_DBNAME = strm_site1_DGMGRL)
(SID_NAME = STRM )
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1 )
)
)
the service_names parameter on dwh:
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string STRM
[oracle@dwh admin]$ lsnrctl status
[oracle@dwh admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 14-SEP-2011 17:32:43
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=dwh)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 14-SEP-2011 12:11:15
Uptime 0 days 5 hr. 21 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dwh)(PORT=1521)))
Services Summary...
Service "STRMXDB" has 1 instance(s).
Instance "STRM", status READY, has 1 handler(s) for this service...
Service "strm" has 1 instance(s).
Instance "STRM", status READY, has 1 handler(s) for this service...
Service "strm_site1" has 1 instance(s).
Instance "STRM", status READY, has 1 handler(s) for this service...
Service "strm_site1_DGB" has 1 instance(s).
Instance "STRM", status READY, has 1 handler(s) for this service...
Service "strm_site1_DGMGRL" has 1 instance(s).
Instance "STRM", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
the listener on stb:
[oracle@stb admin]$ cat listener.ora
ADR_BASE_LISTENER=/u00/app/oracle
LISTENER =
(ADDRESS_LIST =
# for external procedure calls, create a separate listener
# See basenv_user_guide.pdf for details (chapter of listener.ksh)
(ADDRESS = (PROTOCOL = TCP) (Host = stb ) (Port = 1521)
)
)
SID_LIST_LISTENER =
(SID_DESC =
# Next line is necessary for dataguard >= 10g
(GLOBAL_DBNAME = strm_site2_DGMGRL)
(SID_NAME = STRM )
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1 )
)
)
the service_names parameter on stb:
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string STRM
[oracle@stb admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 14-SEP-2011 17:37:23
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=stb)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 14-SEP-2011 12:12:39
Uptime 0 days 5 hr. 24 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stb)(PORT=1521)))
Services Summary...
Service "strm" has 1 instance(s).
Instance "STRM", status READY, has 1 handler(s) for this service...
Service "strm_site2" has 1 instance(s).
Instance "STRM", status READY, has 1 handler(s) for this service...
Service "strm_site2_DGB" has 1 instance(s).
Instance "STRM", status READY, has 1 handler(s) for this service...
Service "strm_site2_DGMGRL" has 1 instance(s).
Instance "STRM", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
My tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.2/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
STRM=
(DESCRIPTION=
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=dwh)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=stb)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=strm)
(FAILOVER_MODE=(TYPE=select)(METHOD=basic))
)
)
STRM_SITE1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dwh)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = STRM_SITE1)
)
)
STRM_SITE2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stb)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = STRM_SITE2)
)
)
My Problem:
C:\Documents and Settings\thai>sqlplus scott/scott@STRM
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 14 17:49:51 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Login with
sqlplus sys/****@STRM as sysdba
raises no problem!
What I have done wrong? Please, help!
regards
hqt200475
Edited by: hqt200475 on Sep 14, 2011 9:04 AM