Home » RDBMS Server » Networking and Gateways » tnsnames and listeners
tnsnames and listeners [message #66238] Thu, 14 February 2002 13:25 Go to next message
Ern
Messages: 4
Registered: February 2002
Junior Member
Hello friends
Yes i Know, this question or varius variations of it have been up on the board several times, but I just don't get it to work. Now I'm desperat.
When I'm trying to connect to Oracle thru dba studio or toad I just get two different messages. No listener or could not resolve servicename.
Or everything stops and you have to shutdown the program.
For first I know the listener is running. I got the enterprise edition on my computer namned li6t9. The database I namned Ernie.

# LISTENER.ORA Network Configuration File: C:oracleora81networkadminlistener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = li6t9)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = li6t9)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ernie.li6t9)
(ORACLE_HOME = C:oracleora81)
(SID_NAME = ernie)
)
)

# TNSNAMES.ORA Network Configuration File:

C:oracleora81networkadmintnsnames.ora
# Generated by Oracle configuration tools.

ERNIE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = li6t9)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ernie)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = li6t9)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ernie.li6t9)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

# SQLNET.ORA Network Configuration File: C:oracleora81networkadminsqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

These are my files that should be important. In sql*plus i connect without problem just typing Internal/oracle I dont even have specify database.
I am new to oracle, been working with mssqlserver7 previous, so probably I make a really fundamental misstake but I don't know what.
I really need help with this, all answers is welcome.
Thanks /Desperate
Re: tnsnames and listeners [message #66242 is a reply to message #66238] Fri, 15 February 2002 10:57 Go to previous messageGo to next message
smat
Messages: 4
Registered: February 2002
Junior Member
Is your oracle database on your local machine or on a remote server?
Re: tnsnames and listeners [message #66272 is a reply to message #66238] Wed, 27 February 2002 19:30 Go to previous messageGo to next message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Hi ,

Now all your steps are right , Try on SQL prompt with this user system/manager@ERNIE

if it connect with your database then there is no problem getting connected through DBA studio choose standalone option and then select ERNIE and enter the login paramters .

With reqards
Satish Shrikhande
Re: tnsnames and listeners [message #66287 is a reply to message #66238] Wed, 06 March 2002 06:11 Go to previous messageGo to next message
Mike Byrne
Messages: 1
Registered: March 2002
Junior Member
How do i ping onames?
Re: tnsnames and listeners [message #66891 is a reply to message #66238] Mon, 03 March 2003 03:56 Go to previous message
Ahmed Maklad
Messages: 1
Registered: March 2003
Junior Member
I had the same problem. was fixed when I did th following.

copy tnsnames.ora into "C:oracleora81network" path.

works like a charm.

ASM
Previous Topic: NLS problem
Next Topic: Listener failed to start
Goto Forum:
  


Current Time: Thu Mar 28 07:26:46 CDT 2024