Download Oracle 8i Setup For Windows Xp

You looked for your tnsnames.ora file at /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora.But, the db_1 is the $ORACLE_SID!Traditionally, the tnsnames.ora is in $ORACLE_HOME/network/admin with a soft link to the ORACLE_SID location.In windows, look for the tns_admin registry entry.

i have setup oracle9i,but am enable to setp with internet.i have tried at cmd prompt but there is no response.how to connect again & after closing the sql editor the instance-> configuration-> shutdown radio button is clicked. am not getting the details of instance information.please help me out. thank u for valuable information.

i have setup the oracle 9i database. i am connected with the same database on my oracle home. but when i am trying to connect using the tns_admin, i am not able to connect the database. I am getting the following error:

Thank u for the reply. i have used TNS_ADMIN.I have a directory under the oracle home.but there is no tns_admin in that directory.I opened my oracle home. i found the tns_admin.. but its unable to connect oracle.

My version of windows XP is SP2 and I am using an X86 version of 10.2.0.5. The database is running on my local machine at port 1521 and I am using tcp/ip. I have tried following all of the suggestions in the rest of the forums, but to no avail. Any ideas?

You need to set the tns_admin parameter in your environment variables. If you want a GUI then use the tnsnames.ora file in your Oracle_Home/network/admin folder. Do not modify the listener.ora file at all. You should be connecting using the tns_admin$ORACLE_HOME/network/admin/listener.ora driver instead of the listener.ora driver.

The main problem is that you are connecting using the wrong driver. The tnsnames.ora and the listener.ora are in the network/admin folder. You should be connecting to the database using the tns_admin$ORACLE_HOME/network/admin/listener.ora driver instead of the listener.ora driver. There is no listener.ora file in your listener_1 folder.

HiI have a Oracle10g installation set up on a Windows 2003 server. I can connect to this database using SQL Plus by specifying the host name, however I can't find a way to connect to this database when trying from an Oracle client (10.2.0.2). I've spent ages trawling through forums and Googling this and can't find anything to help. I'm getting the following error message when running the sql command:ORA-12154: TNS:could not resolve the connect identifier specifiedAny help would be much appreciatedThanksS.D 827ec27edc