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

[Former Member]

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

[Former Member · Accepted solution]

Hi,

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

Regards

Ben

[Former Member · Accepted solution]

Hi,

I have already started the OracleOraHome8iTNSListener and OracleOraHome9iTNSListener as well as OracleService<databasename> from services.But still i am getting the same error.

Thanks,

Anjela

[Former Member · Accepted solution]

Could you log on to the database? Do you get the same error if you try to connect 8i database? How are PATH and ORACLE_HOME set?

what do you get if you execute

<b>lsnrctl status <listener_name></b>

<b>tnsping <DBSID></b>

see also this document.

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96530/upgrade.htm#1009019

[Former Member]

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)

[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

[Former Member]

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