4 Replies Latest reply: Dec 31, 2013 11:07 AM by Hussein Sawwan-Oracle RSS

    ERROR AFTER EBS 11i database upgrade from 9.2.0.8 to database 11g2

    pritesh ranjan

      Hi experts,

      plz help me, i have successfully upgrade database from 9.2.0 to 11.2.0(11g r2) in EBS 11i. but after upgrade i m not able to connect sqlplus.

      when i m going to connect sqlplus  from 11g home it gives me error.

       

      [oratest@pritesh bin]$ pwd

      /u01/Stage11i/testdb/11g/bin

      [oratest@pritesh bin]$ ./sqlplus

       

      SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 23 11:42:45 2013

       

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

       

      Enter user-name: "sys as sysdba"

      Enter password:

      ERROR:

      ORA-12162: TNS:net service name is incorrectly specified

       

       

      Enter user-name:

       

      TNS entry details of 11g after upgrade:

       

      ###############################################################################################################################

      [oratest@pritesh admin]$ ls

      listener13122311AM1556.bak  samples     tnsnames13122311AM1556.bak

      listener.ora                shrept.lst  tnsnames.ora

      [oratest@pritesh admin]$

      #####################################################################################################

      listener.ora details

       

      # listener.ora Network Configuration File: /u01/Stage11i/testdb/11g/network/admin/listener.ora

      # Generated by Oracle configuration tools.

       

      TEST =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = pritesh.txis.com)(PORT = 1526))

          )

        )

       

      ADR_BASE_TEST = /u01/Stage11i

       

       

      #######################################################################################

      tnsname.ora

       

      # tnsnames.ora Network Configuration File: /u01/Stage11i/testdb/11g/network/admin/tnsnames.ora

      # Generated by Oracle configuration tools.

       

      LISTENER_TEST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = pritesh.txis.com)(PORT = 1526))

       

       

      TEST =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = pritesh.txis.com)(PORT = 1526))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = TEST)

          )

        )

       

       

      ##################################################################################################

       

      plz suggest some thing to connect sqlplus after upgrade database to 11g

      EBS - 11.5.10.2

      old database- 9.2.8.0

      new database- 11.2.0.2 (11g r2)

      os- oracle linux 4

       

      thanks & regards

      pritesh ranjan