I have a problem and I don't think it is specific to your product - I have probably set up my environment improperly. However you get many questions on this topic so you may be able to help me.
I have a new Windows 7 laptop and I'm running a 64 bit 11gR2 database on it.
The database and the tns listener appear to be up and running. I can access them from tools like SQL Developer which do not use SQL Net. I can also access it via sqlplus in the bin directory of the 64 bit Oracle home.
However I can not access this database from the sqlplus in the bin directory of the 32 bit Oracle home. Of course I can't access it from PLSQL Developer either. tnsping fails as well.
The message I get is
TNS-12541: TNS:no listener
Hopefully this is just incorrectly configured tnsnames.ora and/or sqlnet.ora.
-------------
Can you give advice on what things need to go into the \network\admin folder (tnsnames.ora, sqlnet.ora) to make this sort of configuration work?
Basically I want to be able to use PLSQL Developer on my laptop to access my 64 bit 11gR2 instance on the same laptop.
-------------
Ps. Have you ever considered modifying the product so that it doesn't depend on SQLNET? Many other products use the alternative access method and it is easier to configure.
I have a new Windows 7 laptop and I'm running a 64 bit 11gR2 database on it.
The database and the tns listener appear to be up and running. I can access them from tools like SQL Developer which do not use SQL Net. I can also access it via sqlplus in the bin directory of the 64 bit Oracle home.
However I can not access this database from the sqlplus in the bin directory of the 32 bit Oracle home. Of course I can't access it from PLSQL Developer either. tnsping fails as well.
The message I get is
TNS-12541: TNS:no listener
Hopefully this is just incorrectly configured tnsnames.ora and/or sqlnet.ora.
-------------
Can you give advice on what things need to go into the \network\admin folder (tnsnames.ora, sqlnet.ora) to make this sort of configuration work?
Basically I want to be able to use PLSQL Developer on my laptop to access my 64 bit 11gR2 instance on the same laptop.
-------------
Ps. Have you ever considered modifying the product so that it doesn't depend on SQLNET? Many other products use the alternative access method and it is easier to configure.
