Re: HELP! Unable to connect with server

The problem here most likely is Developer 6 still uses sqlnet 2. This means the tnsnames.ora
need to reside in %ORACLE_HOME%\network\admin, or the TNS_ADMIN registry key has been set up to a different 'global' directory on your PC or a network drive.
Then a few other things to note:
Having multiple TCP definitions in the listener.ora does no good, only the first will be used, the one with the fixed IP address (and of course you should use the system name ideally)
The global_dbname in listener.ora for the SID ORCL probably is wrong, I always set it to the SID.
According to your sqlnet.ora you don't use Oracle Names, so whatever there is in names.ora, ignore it.

Hth,

--
Sybrand Bakker, Oracle DBA
Sugar <sshyong_at_pd.jaring.my> wrote in message news:3887526A.3B9517EF_at_pd.jaring.my...
> HELP! REALLY in need of HELP!
>
> To all the kind souls out there.
>
> I am having problem getting into the SQL Plus on my server from my
> client.
>
> My developer 6.0 was installed in my client running in Windows NT
> While Oracle 8.0.5 Enterprise edition was installed in my server running
> under Windows NT as well.
> Both client and server are connected in the sense that they can 'ping'
> each other.
>
> There are few questions that I need to ask. and desperately hoping
> someone to give me a clearer picture.
> 1. What is the 'Host String' requested when we try to log in to
> SQL*PLUS?
> 2. Do I identify the server by the IP address or the name?
> 3. What about the 'HOST'?
> 4. I modified the TNSNAME.ORA file on the client side and made few
> modifications as such:
> Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 192.166.166.200)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> 192.166.166.200 is the IP address for my server while the
> 192.166.166.201 is the IP address for my client.
>
> The below is take from SQLNET.ORA
> TRACE_LEVEL_CLIENT = OFF
> #sqlnet.authentication_services = (NONE)
> names.directory_path = (TNSNAMES, HOSTNAME)
> names.default_domain = world
> name.default_zone = world
> automatic_ipc = off
>
> 5. Tried connecting a few times but had error:
> a. ORA 1224 - TNS No Listener
> b. ORA -12203: TNS: unable to connect to destination.
>
> So I check the LISTENER.ORA file and it's as such:
>
> # D:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration
> File:d:\orant\net80\admin\listener.ora
> # Generated by Oracle Net8 Assistant
>
> PASSWORDS_LISTENER= (oracle)
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
> (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> (ADDRESS = (PROTOCOL = NMP)(SERVER = PROJECT)(PIPE = ORAPIPE))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.166.166.200)(PORT = 1521)) <=
> added by me
> (ADDRESS = (PROTOCOL = TCP)(HOST = projectserver)(PORT =
> 1521)) <= added by me
> # (ADDRESS = (PROTOCOL = TCP)(HOST = project)(PORT = 1521)) <=
> commented by me # (ADDRESS = (PROTOCOL = TCP)(HOST = project)(PORT =
> 1526)) <= commented by me
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> (ADDRESS = (PROTOCOL = SPX)(SERVICE = project_lsnr))
> (ADDRESS = (PROTOCOL = IPC)(KEY = ORC0))
> (ADDRESS = (PROTOCOL = IPC)(KEY = ORC1))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = project)
> (SID_NAME = ORCL)
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (SID_NAME = ORC0)
> )
> (SID_DESC =
> (SID_NAME = ORC1)
> )
> )
>
> projectserver is the name of my server.
>
> But have some naming conflicts when I check the NAMES.ORA file
>
> # D:\ORANT\NET80\ADMIN\NAMES.ORA Configuration
> File:d:\orant\net80\admin\names.ora
> # Generated by Oracle Net8 Assistant
>
> NAMES.SERVER_NAME = NS1.fyp.com
>
> NAMES.ADDRESSES =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.166.166.200)(PORT = 1521))
>
> The HOST address was modified by me through Notepad.
>
> Can anyone tell me what's the problem?
> Had been trying for the past 3 days. but to no avail.
> Need help desperately. I have about 1 month to finish my coding.
>
> Please answer me. Don't hope to change to VB for my development.
>
> Thanks a lot.
> By the way I am a student from UPM.
>
> May God bless you.
> Sugar aka Gloria
>
>
Received on Thu Jan 20 2000 - 13:27:54 CST