Cannot connect to my home computer running Oracle 1

[MrPhreaker]

Afternoon all


I am in the process of trying to replicate my database here at work with the database I have running at home.

Obviously, before I can do anything else, I need to be able to see if I can connect to my home DB. This I cannot do and it is coming back with various TNS listener errors. The one at the moment being TNS:no listener.

I am able to tnsping the database though by fully typing out the details but not through the alias.

Since this is the first time I am doing this, I have no knowledge of this process nor can I find a guide for it.

Can someone walk me through this as it is driving me crazy at the idea of another backup and restore tonight.


Many thanks


Greg

 

[sem]

If you can tnsping with exactly the same connect string as listed in your tnsnames.ora file, most probably ANOTHER file is in use. Check whether TNS_ADMIN variable is defined. If not, note that each home has its own instance of TNSNAMES.ORA/SQLNET.ORA pair.

Regards, Dima

http://seminihin.narod.ru

 

[MrPhreaker]

Hi

I have managed to solve this by putting .world at the end of the alias name (dont ask me why but that works).

The problem I have now is that I get a timed out error when I attempt to connect to the database.

The TNSPING works fine for both the ip address and the alias.

I will keep you updated, the latest is that the reason for this is due to the fact that I need to set USE_SHARED_SOCKETS = TRUE as a system variable.

If this works I shall update the thread, otherwise all suggestions are welcome.



Greg

 

[khobar]

Hi

just a small clarification have you installed personnal oracle in your home pc ? In that case you cannot connect to the database through a network. Make sure you have installed Standard/Enterprise Edition


khobar

 

[markrem]

Two things, just FYI:
1. USE_SHARED_SOCKETS is used when forcing connections to use Bequeath on Windows 2000/NT servers. Bequeath can be used with or without the Oracle Listener; the Listener can spawn a bequeath connection on your behalf.
2. The reason you needed to add .WORLD to your tns alias is due to the way you have setup local naming (one of the primary naming methods within Oracle Net.) For example, suppose configuration file sqlnet.ora has entry "names.default_domain=world", and suppose you request a connection to SCOTT/TIGER@ORCL. Oracle Net will read sqlnet.ora to determine the naming method, then pull the default domain (because you specified a database alias without a domain suffix, Oracle looks for a default domain) and appends it to your connection request. So, now it's looking for ORCL.WORLD. At this point it goes to files tnsnames.ora (again because sqlnet.ora told Oracle that you are using local naming which means to use tnsnames.ora) and did a lookup on ORCL.WORLD. If the file has an entry for ORCL but not ORCL.WORLD, then no hits occur and you get service not found.

I hope that helps clarify why .WORLD was necessary.

-Mark

9i OCP