1 Reply Latest reply: Apr 13, 2012 1:39 AM by Helios-GunesEROL RSS

    ora-12162 TNS: net service name is incorrectly specified

    930380
      hi ,
      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)