Solved

Connect Identifier in iSQL Plus

Posted on 2009-07-01
22
1,208 Views
Last Modified: 2013-12-19
I am trying to connect to our db via iSQL Plus but keep getting an error on the connection string; I have the tnsnames file.

We do have 2 db instances on this server.

any help is appreciated.
0
Comment
Question by:Glen_D
  • 14
  • 8
22 Comments
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24758672
The error message will help us.
0
 

Author Comment

by:Glen_D
ID: 24758717
Thx...here it is:

       

ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24758779
Do you have tnsnames.ora configured? Please show your tnsnames.ora and your listener.ora

Usually this error is a result of lack of an entry in tnsnames for that alias
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Glen_D
ID: 24758810
Here's the TNS...I'm retrieving the listener...thx

# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = CustomerDev.FREEDOM.LOCAL)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

ERIC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = CustomerDev.FREEDOM.LOCAL)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ERIC)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24758837
And you are using ORCL or ERIC to connect, right?

Verify that you can: tnsping ORCL
from the command prompt
0
 

Author Comment

by:Glen_D
ID: 24758857
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\myname>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 01-JUL-2
009 17:35:17

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:
F:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Customer
Dev.FREEDOM.LOCAL)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N
AME = orcl)))
OK (20 msec)
0
 

Author Comment

by:Glen_D
ID: 24758861
Here's the listener data:

# listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\oracle\product\10.2.0\db_2)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = CustomerDev.FREEDOM.LOCAL)(PORT = 1521))
    )
  )

0
 

Author Comment

by:Glen_D
ID: 24758871

C:\Documents and Settings\myname>tnsping eric

TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 01-JUL-2
009 17:37:27

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:
F:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Customer
Dev.FREEDOM.LOCAL)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N
AME = ERIC)))
OK (10 msec)

C:\Documents and Settings\gdamiani>
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24758880
Is the same tnsnames.ora file on the server that is running iSQLPLUS?
0
 

Author Comment

by:Glen_D
ID: 24758903
Is the same tnsnames.ora file on the server that is running iSQLPLUS?

Yes

Thx
0
 

Author Comment

by:Glen_D
ID: 24758913
This is waht I was trying tu use as my connect identifier:

CustomerDev.FREEDOM.LOCAL:1521/ERIC
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24758932
For isqlplus just try using  ERIC
0
 

Author Comment

by:Glen_D
ID: 24758946
Received the same error:

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

Author Comment

by:Glen_D
ID: 24759187
any other ideas?  really need to solve this
0
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24759246
On the server machine try:

tnsping ERIC
sqlplus user/pass@ERIC

Do those work from the server itself.
0
 

Author Comment

by:Glen_D
ID: 24759553
This is what I received:

Enter user-name: sqlplus user/pwxxxx@ERIC
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
0
 

Author Comment

by:Glen_D
ID: 24759566
OK...weird....

I just used another account and was able to connect via the command prompt; actually my account.

0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24759589
Use a real username

user was for the example, not literal

0
 

Author Comment

by:Glen_D
ID: 24759598
yes, I know but was trying to keep some privacy here

The account I tried is our development account that everyone should use...not my personal user account.

Thx
0
 

Author Closing Comment

by:Glen_D
ID: 31598989
Thx for hanging in there....Glen
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24759617
Sure, I did not mean to literally post the user, but I assumed you had actually typed "user", it happens often. :)

SO the end result, are you in with iSQLPLUS or did you resort to the command line?
0
 

Author Comment

by:Glen_D
ID: 24759620
In with iSQLPLUS...now I just need to code the scripts to place in ERIC under the schema I need.

Thx
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question