ora-12162 TNS: net service name is incorrectly specified
930380Apr 13 2012 — edited Apr 13 2012hi ,
i have installed oracle 11g on an AIX node and configured asm as well. when i su - oracle and give sid as +ASM am able to get in to sqlplus as ASM and oracle home is ASM.
but when i give oracle_home to db i get the error. the thing is that these files were not created wen i installed oracle. i created them manually :(
thanks in advance
--------- listener.ora-------------
# listener.ora.rac01 Network Configuration File: /u01/oracle/product/11.1.0.7/db
/network/admin/listener.ora.rac01
# Generated by Oracle configuration tools.
LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = rvn14)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.160.103.46)(PORT = 1521)(IP = FIRST))
(SID_LIST_LISTENER=
(SID_LIST=
(SID_NAME=sys)
)
)
)
)
ADR_BASE_LISTENER_RAC01=/u02
---------- sqlnet.ora------------
names.default_domain = world
names.directory_path = (TNSNAMES)
trace_level_client = off
tcp.nodelay = yes
bequeath_detach = yes
sqlnet.expire_time = 10
sqlnet.inbound_connect_timeout = 0
adr_base=/u02
--------tnsnames.ora----------
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)
(Host=10.160.103.46)(Port=1521)))
(CONNECT_DATA=(SID=sys)