CODEWITHSUNDEEP
oracle-databaseoracle-ebs
Afgan
Afgan

Reputation: 1070

Oracle Developers guide 10g is not connecting to sever

I have installed oracle developers guide 10g in my windows 10, it installed successfully.

While connecting to Oracle EBS host data base it give an error

Entered detail on connection screen -

User - myuser

Pass - mypass

Connect String - myuser@SID

Error -

ORA-12154: TNS:could not resolve the connect identifier specified

Cause

The service name specified is not defined correctly in the TNSNAMES.ORA file. I check my TNSNAMES.ORA file at my database host machine

I found entry TNSNAMES.ORA - 

SID =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SID)
    )
  )

where and what changes i need do in settings file to connect it properly.

Note - host machine OS Linux

Note -

tnsnames.ora and sqlnet.ora files are present at two places

1- C:\DevSuiteHome_1\NETWORK\ADMIN - Path created after installing oracle developer guide 10g

2- E:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN - previous oracle installation path

is there any catch in this file locations ?

Upvotes: 0

Views: 121

Answers (2)

Sal
Sal

Reputation: 1317

EBS admin/contact should provide the proper TNS entry and you should add it to your tnsnames.ora. If you are trying development for EBS I doubt you need a connection to "mymachine" which would be a non-standard name for a EBS instance.

Upvotes: 0

Irwan Hendra
Irwan Hendra

Reputation: 148

I'm a bit confused with the question, but I will try to answer as far as I can understand:

You have 2 tnsnames.ora, one in the db server and another in client, you need to look at the tnsnames.ora in the client machine (where sql developer is installed), check if the SERVICE_NAME is pointing to the right SSID of the Oracle Server, then check if HOST is pointing to the right machine name / IP (I personally like to use IP better).

then on the command prompt, try tnsping (assuming you have one):

Using the tnsnames.ora you posted, it will be something like:

C:\>tnsping.exe SID

Let me know how it goes

UPDATE:

Here's an example of how to do it:

Oracle Server IP: 192.168.1.220 with SID: ORCL

My Computer IP: 192.168.1.200

Content of tnsnames.ora in My Computer:

Blockquote

BLAHSERVER= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) )

Then you should be able to do the following:

C:\> tnsping.exe BLAHSERVER
C:\> sqlplus username/password@BLAHSERVER

Upvotes: 0

Related Questions