Home » SQL & PL/SQL » Client Tools » Help for Configuring my Oracle Net Manager (Oracle 9i)
Help for Configuring my Oracle Net Manager [message #352054] Sun, 05 October 2008 11:43 Go to next message
hemanthjava
Messages: 2
Registered: January 2007
Location: Bangalore
Junior Member

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

Re: Help for Configuring my Oracle Net Manager [message #352113 is a reply to message #352054] Mon, 06 October 2008 03:59 Go to previous message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Hi,

In your tnsnames.ora
GLOBAL_NAME = orcl
entry how it has come? Instead it sould have been
SERVICE_NAME = orcl

But
(connect_data =
SID = orcl)
or
(connect_data =
service_name = orcl) is suffice.

Thanx and regards,

MSMallya

[Updated on: Mon, 06 October 2008 04:01]

Report message to a moderator

Previous Topic: TOAD Review
Next Topic: Can't see objects after connecting through developer
Goto Forum:
  


Current Time: Fri Dec 02 14:14:46 CST 2016

Total time taken to generate the page: 0.18829 seconds