Oracle Connection

[rsrinivasan]

Hi all,
I need to connect local database from oracle. When i give username and password and service name, it throws error "TNS name could not be resolved".

What should i change in tnsnames file?

Thanks in advance
Srinivas r.

[debasisdas]

The following is a sample of typical entry in tnsnames.ora file.
the first one is the name of database next host name or ipaddress and port number etc
u need to change your file accordingly
donot delete the old entries.
add new eentries

DEBASIS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = is-18)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DEBASIS)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
 
MES =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = MES)
    )
  )
BDCORA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl1)
    )
  )
 
MESTEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.14.155)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MESTEST)
    )
  )
 

[rsrinivasan]

The following is a sample of typical entry in tnsnames.ora file.
the first one is the name of database next host name or ipaddress and port number etc
u need to change your file accordingly
donot delete the old entries.
add new eentries

DEBASIS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = is-18)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DEBASIS)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
 
MES =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = MES)
    )
  )
BDCORA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl1)
    )
  )
 
MESTEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.14.155)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MESTEST)
    )
  )
 

Hi,
I changed my TNS file as

sri =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sri)
    )
  )

Still I have the same error. What to do?
Thanks,
Srinivas r.

[debasisdas]

please reply to these

1.yours is a standalone pc or network pc.

2.do u have multiple databases in the same system.

3.You are trying to connect from client machine or server machine.

[rsrinivasan]

please reply to these

1.yours is a standalone pc or network pc.

2.do u have multiple databases in the same system.

3.You are trying to connect from client machine or server machine.

1. My pc is network pc.
2. Till now i did not create any database in my local PC. I want to create a database in my local system. Because my server has some problem.
3.I want to connect my local machine to oracle.

Thanks,
Srinivas r.

[debasisdas]

1. My pc is network pc.

if your pc is in network how u are using 127.0.0.1 as your ip address

either use the system IP address or system name

[mukta sarangpure]

hi
This is mukta answering to ur '?'...
First check ur database services ,
PLZ CKECK ur listener files...
& also listener service.

Hi all,
I need to connect local database from oracle. When i give username and password and service name, it throws error "TNS name could not be resolved".

What should i change in tnsnames file?

Thanks in advance
Srinivas r.