Q
Problem solve Get help with specific problems with your technologies, process and projects.

Concerned about installing 8.0.5 client on 9i server

We created an Oracle9i database and deployed our reporting application on it. Our vendor insisted on installing 8.0.5 client on the server as its application still use 8.0.5 client. Since then, connecting SYS or SYSTEM is a problem.

From the DOS prompt
SQLPLUS/NOLOG
(You will see another DOS prompt window opened with the following)

SQL*Plus: Release 8.0.5.0.0 - Production on Thu Mar 11 14:10:57 2004

? Copyright 1998 Oracle Corporation. All rights reserved.

SQL*Plus: Release 8.0.5.0.0 - Production on Thu Mar 11 14:10:57 2004

? Copyright 1998 Oracle Corporation. All rights reserved.

SQL> connect sys/*******@vault as sysdba
ERROR: ORA-01031: insufficient privileges

I even set the ORACLE_HOME and ORACLE_SID
Microsoft Windows 2000 [Version 5.00.2195]
? Copyright 1985-2000 Microsoft Corp.

C:>set ORACLE_SID=vault
C:set ORACLE_HOME=c:oracle9i

CONNECT SYS/*****@vault AS SYSDBA and still unable to connect with the 9i TNSNAMES.ORA. But you can connect with 8.0.5 as the application owner.

I am skeptical about installing 8.0.5 client on 9i server, but the vendor insisted.
The Oracle 8.0 client and earlier is not supported on Oracle9i. You will have to use at least Oracle8i. But since you have Oracle9i installed on the server, why not use the 9i client? It is already installed when you install the database software?

I have seen an example or two where pre-8i clients can connect to a 9i database, but it is not worth the trouble. Use a client version that is supported and works without problems.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close