| tnsnames and listeners [message #66238] |
Thu, 14 February 2002 13:25  |
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 #66272 is a reply to message #66238] |
Wed, 27 February 2002 19:30  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
