Home » RDBMS Server » Server Administration » Oracle 9i Developer Problem
Oracle 9i Developer Problem [message #332032] Mon, 07 July 2008 05:22 Go to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member
Dear Members
I have Database 10g release1 installed on my computer. I want to keep database 10g for back end and developer 9i for front end development so i installed developer 9i on my computer. But after successfully installation of developer 9i, 10g database is not available know , i try to connect to database 10g throug normal user like scott/tiger but it did not connect to 10g database. Please tell what is the problem, And how i can connect 10g database with developer9i.

Thanks & regards

Report message to a moderator

Re: Oracle 9i Developer Problem [message #332035 is a reply to message #332032] Mon, 07 July 2008 05:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe you didn't configure to be able to connect but with what you posted how can someone knows?

Regards
Michel

Report message to a moderator

Re: Oracle 9i Developer Problem [message #332183 is a reply to message #332032] Mon, 07 July 2008 14:57 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You should be able to connect to Oracle 10g database if you go to Oracle10g_Home\bin directory and run SQL*Plus. It would, probably, use TNSNAMES.ORA file which is located in Oracle10g_Home\Network\Admin directory.

If you, on the other hand, go to Oracle9i_Home\bin directory, you'll probably fail to connect to the database as Oracle9i_Home\Network\Admin\tnsnames.ora doesn't know of the Oracle 10g database.

The simplest way would be to unify these TNSNAMES.ORA files (i.e. take the one from the Oracle 10g directory and copy it into the Oracle 9i one). Or, if you don't want to maintain multiple copies of the same file, check use of the TNS_ADMIN environment variable which will point Oracle to a directory which contains a single copy of the TNSNAMES.ORA file.

Report message to a moderator

Re: Oracle 9i Developer Problem [message #332316 is a reply to message #332183] Tue, 08 July 2008 03:32 Go to previous messageGo to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member
Dear Littlefoot
I have got your point.
But i have connected to oracled10g database by making service with help of developeer9i wizard.
Quote:


Or, if you don't want to maintain multiple copies of the same file, check use of the TNS_ADMIN environment variable which will point Oracle to a directory which contains a single copy of the TNSNAMES.ORA file.


As you previous mention can you proviede me detail about "TNS_ADMIN environment variable" and also about service that is made to connect to database and developer.

Know my problem has solved.

Thanks & Regards

[Updated on: Tue, 08 July 2008 03:35]

Report message to a moderator

Re: Oracle 9i Developer Problem [message #332342 is a reply to message #332316] Tue, 08 July 2008 04:25 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Details? Sure!

Report message to a moderator

Previous Topic: drop oracle8 database
Next Topic: COMPATIBLE Initialization Parameter
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 21:39:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.