how to run two different version of oracle on same windows server
Hi All,
I installed Oracle 9i instance on the server in the diffrent oracle home, where already a Oracle 10g instance was running.
Now I am facing a issue, all third party softeware are unable to connect the oracle 10g db. Getting the message of tns-12154.
Can you plese help me out , that what is the best way to run oracle9i and oracle 10g on he same windows server?
what is the way to make a database as a default db for the server?
well you need to sort the clients ou as they are unable to resolve the tns name - sort out your tnsnames.ora files
Hi,
Thanks for yr reply.
sqlplus is wroking, but not able to coonect by using anyother software.
Is there anything about the tnsnames.ora?
There should be one tnsnames.ora or can have two tnsnames.ora,
coz i guess there is something wrong with it
Hi,
Thanks for yr reply.
sqlplus is wroking, but not able to coonect by using anyother software.
Is there anything about the tnsnames.ora?
There should be one tnsnames.ora or can have two tnsnames.ora,
coz i guess there is something wrong with it
regards,
praveen
You have somewhat answered yourself.. See you can connect through sqlplus, meaning its the problem with your 'other software'. Check your tnsnames.ora in the client machine, you must have jumbled up with either sid, service name or port. Make sure you're connecting to the correct instance in the correct port with correct sid or service name. You can refer to listener.ora in server, to see which port will listen for which instance.
Hi Thanks for yr reply.
I am able to coonect from the server, sqlplus is working fine.
But unable to connect to oracle10g from the remote.
I did not try tns.exe
Is there anything , default database for the server?
I gueass , previously oracle 10g was the default database ,and now it's coming oracle 9i
Hi Thanks for yr reply.
I am able to coonect from the server, sqlplus is working fine.
But unable to connect to oracle10g from the remote.
I did not try tns.exe
Is there anything , default database for the server?
I gueass , previously oracle 10g was the default database ,and now it's coming oracle 9i
regards,
Praveen
How many Oracle clients do you have in your "remote" station?
My guess is you have one Ora9i and one Ora10g ORACLE_HOMES there, is that correct?
If that's correct please remember you can switch ORACLE_HOME on the remote station -Home selector under Oracle Installation.
Now, lets try connectivity.
1 - Can you ping the server from your remote station?
2 - Can you tnsping the database from your remote station?
...please do set proper ORACLE_HOME and ORACLE_SID before trying this.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Originally Posted by davey23uk
. See you can connect through sqlplus, meaning its the problem with your 'other software'. Check your tnsnames.ora in the client machine, you must have jumbled up with either sid, service name or port. Make sure you're connecting to the correct instance in the correct port with correct sid or service name. You can refer to listener.ora in server, to see which port will listen for which instance.
Bookmarks