Skip to Content
author's profile photo
Former Member

ORA-12560:TNS protocol adapter Error while upgrading oracle 8i to Oracle 9i

Hi,

I am updrading My oracle 8i setup to Oracle 9i in the Windows operaton System.During the upgradation in the Database upgrade Assistant,The installer asked for the system authetication for upgrading the existing database.After proving the Username and password i am getting an error as ORA-12560:TNS protocol adapter Error .Please help me about what do I need to modify.

Thanks in Advance,

Anjela

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 03:18 PM

    Hi,

    After upgrade oracle software, please start TNS Listener, then upgrade database.

    Regards

    Ben

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 04:01 PM

    Hello Anjela,

    how are the ORACLE_HOME, ORACLE_SID and PATH set?

    Which status does the database 8i have?

    select status from v$instance;

    Best regards

    Baran

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 04:06 PM

    which 8i Database version do you have?

    select * from v$version;

    select version from v$instance; (software version)

    select comp_id,version,status from dba_registry; (database version)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Here are the output

      SQL> select * from v$version;

      BANNER

      -


      Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

      PL/SQL Release 8.1.7.0.0 - Production

      CORE 8.1.7.0.0 Production

      TNS for 32-bit Windows: Version 8.1.7.0.0 - Production

      NLSRTL Version 3.4.1.0.0 - Production

      SQL> select version from v$instance;

      select version from v$instance

      *

      ERROR at line 1:

      ORA-00942: table or view does not exist

      SQL> select comp_id,version,status from dba_registry;

      select comp_id,version,status from dba_registry

      *

      ERROR at line 1:

      ORA-00942: table or view does not exist

      Thanks,

      Anjela