error connecting to database

ps... I ran the installation using the compatability wizard for windows 98/ME

What command line arguments are you trying to give tnsping?

It is: tnsping <dbAlias>

where dbAlias is the alias defined in %ORACLE_HOME%/network/admin/tnsnames.ora

ok... I tried to edit this question but I could not.... I was able to tnsping and got the response OK <1310 msec>.... but I keep getting the error   'OBE-15387: Login failed ---- ORA-12203:  TNS:unable to connect to destination' while trying to log onto query builder....

tnsping only goes to the listener not all the way through to the instance.  Since tnsping responded, the next place to look is between the listener and the instance.

Can you connect using sqlplus?

Try: lsnrctl stat to make sure the listener is up and listening for connections to the instance.

Also, check %ORACLE_HOME%/network/log/listener.log (going from memory on the path.  "lsnrctl stat" will give you the log location) for any connection errors.

I am able to connect to sqlplus through a command prompt, but I am unable to connect through any application on the desktop.

ok... that magically started working, I can launch the application since I changed the oracle home to the one for 817... but I still cannot launch any developer tools.  I installed developer and client as separate homes, but it is looking at the client as the default home... do you know how I can adjust something to allow for developer to look at the oradev home?

I'll admit I'm not up on all the ins and outs of multiple homes in a windows environment (my UNIX days were much simpler times).  You should be able to set an ORACLE_HOME environment variable specifically for that user.  This will override the one specified in the registry.

Hello,
both Oracle 8i tools and Developer 6i tools should work if you have the same tnsnames.ora files in both Oracle homes.
Please check both files (%ORACLE_HOME8i%network/admin/tnsnames.ora and
%ORACLE_HOME6i%/network/admin/tnsnames.ora) and make sure your database connection is defined properly.

they match... but developer still does not work.  I am getting the error 'ORA-12203: TNS:unable to connect to destination'
any other suggestions?

Chuck_aa:

first try to switch homes, if it does not work then reinstall packages, older first

When I switch homes, I am unable to attach to the database through 8i client... nor am I unable to attach to a developer tool.  When you say reinstall packages, do you mean reinstall all of developer?

@chuck:


I have Oracle8.1.7 and Oracle Developer suite9iDS in my windows XP platform.
I have never met any problem with FORM or report builder connecting to my oracle database.

Can you try this first just for the heck of it?

Note : you have to find out yourself which HOME your FORM is in registry. If you have only installed oracle database and FORM6i..and also in that order (first database then FORM). then your FORM is most likely in HOME1

add a registry entry called

TNS_ADMIN  , data type: REG_SZ , value: <the full path to tnsnames.ora under ORacle database home>



HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1


then exit and try it again...

Chuck_aa:

when you switch homes you need to create alternate tnsnames.ora (or configure with utilities)

hi

well what u can do copy the tnsnames.ora file which has got all the connect strings and put in the developers, parth where your forms path are located.

bcoz ur developer will try to search thru the path set. that will solve ur problem.

regards
annamalai

hi try this...

http://starlet.deltatel.ru/ora$doc/7/DOC/net/doc/NWTR23/ch6a.htm

http://www.cse.unsw.edu.au/~oracle/Oracle8_doc/DOC/server.804/a58312/sdo_mes8.htm

R.K

This DB don`t work on WinXP.
For WinXP it`s oracle 9.2.

Best regards
Dmitry

@GDE:

I have tested it , it worked in windows XP, not only 8.1.7, but also 8.1.5 and 8.1.6

it will work but it is not oracle certified

I added the TNS_ADMIN with the full path to tnsnames.ora file in the forms/reports home in the registry.  It still is giving me the error 'unable to connect to destination'.  When I did the installation, I installed forms and reports first, then the client.  Do I need to uninstall everything then reinstall starting with the client first?  Will that even make a difference?  Also, If I uninstall and redo it all, should I use the compatability for W2K instead of W98/ME?  

Ok, then Chuck

try to uninstall everything if this is just a test machine.

then install in this order;

install Oracle db first, then developer suite. (In my eyes, it does make difference).

you don't need to run compat check...

"Do I need to uninstall everything then reinstall starting with the client first?  Will that even make a difference?"

I don't think so, but some times the software get corrupted (accidentally deleting a file or so) and you need to reinstall everything. Starting with the client will make no difference, it will only depends from your homes installation. The client can be installed with your server or forms homes or both; only check wich home is activated.

"Also, If I uninstall and redo it all, should I use the compatability for W2K instead of W98/ME?"

You do not need to use compatibility at all, probably that is the cause of error, 9i is not certified for xp but it really works.

I am using 8i.  I thought I needed to use the compatability for 8i.

You do not need it. Try reinstalling all without compatibility.