OraFAQ Forum: Server Administration » Oracle 8i client can't connect Oracle 9i database

Home » RDBMS Server » Server Administration » Oracle 8i client can't connect Oracle 9i database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 8i client can't connect Oracle 9i database [message #55249]

Mon, 13 January 2003 13:05

Susie Maxwell
Messages: 5
Registered: January 2003

Junior Member

I have Oracle 8i client, Database on Oracle 9i in another machine. After I create one NEW database, I can access this database by using SQLPlus on Oracle9i server machine. But I cann't make connection on Oracle8i client. Error message is: ORA-12154 TNS:could not resolve service name. I did "tnsping oracle_sid" on client machine, it still gives me Error: TNS:03505: Failed to resolve name. Oracle client and server both are on Windows 2000.
I don't know why, please help me! Thanks in advance!

Report message to a moderator

Re: Oracle 8i client can't connect Oracle 9i database [message #55250 is a reply to message #55249]

Mon, 13 January 2003 13:15

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you create a connect_string ??
by editing tnsnames.ora file?

Report message to a moderator

Re: Oracle 8i client can't connect Oracle 9i database [message #55252 is a reply to message #55249]

Mon, 13 January 2003 13:35

Susie Maxwell
Messages: 5
Registered: January 2003

Junior Member

Yes, I add one entry in tnsnames.ora file.

Report message to a moderator

Re: Oracle 8i client can't connect Oracle 9i database [message #55257 is a reply to message #55249]

Tue, 14 January 2003 06:23

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i have already asked you to comment all of these and try again.

NAMES.DEFAULT_DOMAIN = mdacc.tmc.edu

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = utmgim1dbnt.mdacc.tmc.edu)(PORT = 1575))
)

SQLNET.EXPIRE_TIME = 0

NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES)

SQLNET.AUTHENTICATION_SERVICES= (NTS)

Report message to a moderator

Connectivity from ASP to oracle [message #55269 is a reply to message #55249]

Tue, 14 January 2003 23:51

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hello,
follow the below approach..

str="Provider=oraoledb.oracle.1;password=tiger;persist security info=true;user id=scott; data source=databasename"
con.open str

also check the OO4O documentation for further enhancements.

sai

Report message to a moderator

Re: Connectivity from ASP to oracle [message #55277 is a reply to message #55249]

Wed, 15 January 2003 09:45

Susie Maxwell
Messages: 5
Registered: January 2003

Junior Member

I got this error:

ADODB.Connection error '800a0e7a'

ADO could not find the specified provider.

Report message to a moderator

Re: Connectivity from ASP to oracle [message #55280 is a reply to message #55249]

Wed, 15 January 2003 11:38

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi,
What is the Version of oracle u have at your end ?
also ensure that Oracle Objects for OLE is installed along with the database in the server.

sai

Report message to a moderator

Re: Connectivity from ASP to oracle [message #55287 is a reply to message #55249]

Wed, 15 January 2003 13:10

Susie Maxwell
Messages: 5
Registered: January 2003

Junior Member

I use Oracle8i client and Oracle9i database.

I found my Net8 assistant and Net8 configuration Assistant doesn't work. Do you think is that a problem to connect web browser?

By the way, I try to install Oracle9i client in the same machine as 8i client. But the installation stuck at PL/SQL install, take forever. It seems like something wrong with the installation. Somebody have idea about it?

Report message to a moderator

Re: Connectivity from ASP to oracle [message #55292 is a reply to message #55287]

Thu, 16 January 2003 01:51

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hi,
Why do u need 9i and 8i clients in the same machine ?
Anyways while installing did u select different paths for both the Clients.. I think that is a important thing to follow.
also because u have 2 clients now, u got configure tnsnames twice..do that for both the clients.

and then work out the ASP stuff, Problem shouldnt be there.

sai

Report message to a moderator

Re: Oracle 8i client can't connect Oracle 9i database [message #55373 is a reply to message #55249]

Tue, 21 January 2003 09:19

Madhavi
Messages: 23
Registered: November 1999

Junior Member

Hello,
I am having a similar problem. My case is a little different in that I am working with Oracle versions 7.3 and 8.0.5.

My web project is located on a W2K server, and I am connecting to two different Oracle Database servers. One databse server is on Oracle v8.0.5 and the second database server is on Oracle 7.3.

When connecting to the Oracle 8.0.5 database server, there are no problems.

But, I am getting the following errors when connecting to the Oracle 7.3 database server via ASP.

My PC (the client) is installed with Oracle 7.3 v 2.00.03.01. I am using Microsoft ODBC Driver to make the connection to either Server (Oracle 8.0.5 and Oracle 7.3 servers).

Within ASP, I am using a DSNless ADODB connection string.

The errors are:

-2147467259[[Microsoft]][[ODBC driver for Oracle]][[Oracle]]ORA-12154: TNS:could not resolve service name
-2147467259[[Microsoft]][[ODBC Driver Manager]] Driver's SQLSetConnectAttr failed

Report message to a moderator

Previous Topic:	Change System Tables...
Next Topic:	Re: Oracle 8i client can't connect Oracle 9i database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:58:25 CDT 2024