Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Dual Oracle DB problem sort of resolved.

Michael Brooks_4
Occasional Advisor

Dual Oracle DB problem sort of resolved.

Well it looks like, because I have multiple databases on my system, the programs have a problem pointing the correct home. So, after I turn on my PC I have to turn off all the databases, then depending on what I want to do start that particular database then use that application. All but one application work in this manner, and that is the SQL-Navigator; is there a way to have all databases running so I donâ t have to work like this, and does anyone know how I would get the SQL-Navigator working again; it gives an error ORA-12154L TBS: could not resolve service name?

Oh and thanks so much for your help in pointing out a answer,
M
8 REPLIES
Massimo Bianchi
Honored Contributor

Re: Dual Oracle DB problem sort of resolved.

Usually this means that the application is not able to find the proper tnsnames.ora


Try either:

add environtment variable TNS_ADMIN=

or

copy in both the ORACLE_HOME/network/admin the same tnsnames.ora

Remember that tnsnames dor 817 and 902 are different, they may use service_name or sid, depending upon the executables and the destination database...

Massimo

Michael Brooks_4
Occasional Advisor

Re: Dual Oracle DB problem sort of resolved.

Thanks, for that but are you talking about tns_admin in the Windows Registry?

If so, I cant seem to find that or if not and you are talking about the tns_name, don't have then new database sid in the other tns file, and I dont have the other in the new tns_name. I thought they were separate. Can you clearify please?

Thanks,
Mike
Michael Schulte zur Sur
Honored Contributor

Re: Dual Oracle DB problem sort of resolved.

Hi,

he is talking about the place, where you define environment variables. Go to system configuration/system/enhanced and there you can see and edit the variables.

greetings,

Michael
Massimo Bianchi
Honored Contributor

Re: Dual Oracle DB problem sort of resolved.

I'm talking about the environtment variable TNS_ADMIN, that should point to the location of the tnsnames.ora file


usually, if not otherwise specified, its value is $ORACLE_HOME/network/admin

Usually is best if all is aligned...

to how many different database do you connect to (usually)?

Massimo
Michael Brooks_4
Occasional Advisor

Re: Dual Oracle DB problem sort of resolved.

This must be on the UNIX BOX, but I am on a pc. Is that correct?

Thanks,
Mike
Massimo Bianchi
Honored Contributor

Re: Dual Oracle DB problem sort of resolved.

TNS_ADMIN is both for unix and windows.

obviouslt the path canghes..

Massimo
Tim Sanko
Trusted Contributor

Re: Dual Oracle DB problem sort of resolved.

First of all unless you are running 2003 server there isn't support of more than one release of oracle on 2000 server/NT etc. That being said, apparently you can toggle them and without too much problem have access to either release.

Since you have a PC, run Linux. If you really want to use 2 releases on a PC server it is by far the cheapest manner. Redhat 7-9 works fine. Use ODBC to access the data from a PC. It is easier by far to do Oracle on any UNIX or variant, IMHO.

Tim
Yogeeraj_1
Honored Contributor

Re: Dual Oracle DB problem sort of resolved.

hi,

you can define your TNS_ADMIN by doing the following on your Windows based server (W2K)

System Properties
->Advanced
->Environment Variables
->System Variables

then New

hope this helps too!

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)