APPLIES TO:
Oracle Net Services - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]Information in this document applies to any platform.
GOAL
Can't startup a database through remote connection
Tnsping works fine.
[oracle@dmb1dbadm01 ~]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 16-JAN-2014 11:11:47
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL_SERV) (INSTANCE_NAME = ORCL)))
[oracle@myhost ~]$ sqlplus sys/password@ORCL as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 16 11:11:33 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter LISTENER_NETWORKS
ORA-00137: invalid LISTENER_NETWORKS specification with NAME=NET1
ORA-00138: all addresses specified for attribute LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name 'LOCAL_1'
ORA-00132: syntax error or unresolved network name 'REMOTE_1'
ORA-00132: syntax error or unresolved network name 'LOCAL_2'
ORA-00132: syntax error or unresolved network name 'REMOTE_2'
ORA-00132: syntax error or unresolved network name 'LOCAL_3'
ORA-00132: syntax error or unresolved network name 'REMOTE_3'
ORA-00132: syntax error or unresolved network name 'LOCAL_4'
ORA-00132: syntax error or unresolved network name 'REMOTE_4'
SQL> exit
--> All TNS alias are resolved
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 16-JAN-2014 11:11:47
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL_SERV) (INSTANCE_NAME = ORCL)))
[oracle@myhost ~]$ sqlplus sys/password@ORCL as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 16 11:11:33 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter LISTENER_NETWORKS
ORA-00137: invalid LISTENER_NETWORKS specification with NAME=NET1
ORA-00138: all addresses specified for attribute LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name 'LOCAL_1'
ORA-00132: syntax error or unresolved network name 'REMOTE_1'
ORA-00132: syntax error or unresolved network name 'LOCAL_2'
ORA-00132: syntax error or unresolved network name 'REMOTE_2'
ORA-00132: syntax error or unresolved network name 'LOCAL_3'
ORA-00132: syntax error or unresolved network name 'REMOTE_3'
ORA-00132: syntax error or unresolved network name 'LOCAL_4'
ORA-00132: syntax error or unresolved network name 'REMOTE_4'
SQL> exit
--> All TNS alias are resolved
SQL> show parameter listener_networks;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string ((NAME=NET1)(LOCAL_LISTENER=
LOCAL_1)(REMOTE_LISTENER=REMOTE_
1)), ((NAME=NET2)(LOCAL_LISTEN
ER=LOCAL_2)(REMOTE_LISTENER=RE
MOTE_2)), ((N)(NAME=NET3)(LOCAL
_LISTENER=LOCAL_3)(REMOTE_LIS
TENER=REMOTE_3)), ((NAME=NET4
)(LOCAL_LISTENER=LOCAL_4)(R
EMOTE_LISTENER=REMOTE_4))
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string ((NAME=NET1)(LOCAL_LISTENER=
LOCAL_1)(REMOTE_LISTENER=REMOTE_
1)), ((NAME=NET2)(LOCAL_LISTEN
ER=LOCAL_2)(REMOTE_LISTENER=RE
MOTE_2)), ((N)(NAME=NET3)(LOCAL
_LISTENER=LOCAL_3)(REMOTE_LIS
TENER=REMOTE_3)), ((NAME=NET4
)(LOCAL_LISTENER=LOCAL_4)(R
EMOTE_LISTENER=REMOTE_4))
[oracle@myhost ~]$ srvctl start database -d ORCL --> works fine
SOLUTION
The TNSNAMES.ORA file containing the TNS connect strings referenced in LISTENER_NETWORKS must be placed in both GRID_HOME/network/admin and RDBMS_HOME/network/admin.
No comments:
Post a Comment