| Help for Configuring my Oracle Net Manager [message #352054] |
Sun, 05 October 2008 11:43  |
|
|
Hello All,
I need help with Configuring my Oracle Net Manager.
I have done the following Steps;
1. I have opened Oracle Net Manager.
2. Clicked on Service Naming
3. Clicked the Add(+) button on the left to add new Service Name
4. Typed "orcl" for the Net Service Name
5. Chose TCP/IP n the next screen for the protocol to be used to access the database
6. Typed localhost in the "Hostname" textbox with 1521 as the port.
7. Entered Service name as "orcl" again and went to the next screen and clicked Test
I got the following Error
Initializing first test to use userid: scott, password: tiger
Attempting to connect using userid: scott
The test did not succeed.
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
There may be an error in the fields entered,
or the server may not be ready for a connection.
This is my TNSNames.ora Contents
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = localhost)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = orcl)
(GLOBAL_NAME = orcl)
)
)
Regards,
Hemanth
[Updated on: Sun, 05 October 2008 11:46] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
