We help IT Professionals succeed at work.

Connect Identifier in iSQL Plus

Glen_D
Glen_D asked
on
Medium Priority
1,230 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.
Comment
Watch Question

Top Expert 2009

Commented:
The error message will help us.

Author

Commented:
Thx...here it is:

       

ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Top Expert 2009

Commented:
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

Author

Commented:
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)
    )
  )

Top Expert 2009

Commented:
And you are using ORCL or ERIC to connect, right?

Verify that you can: tnsping ORCL
from the command prompt

Author

Commented:
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)

Author

Commented:
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))
    )
  )

Author

Commented:

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>
Top Expert 2009

Commented:
Is the same tnsnames.ora file on the server that is running iSQLPLUS?

Author

Commented:
Is the same tnsnames.ora file on the server that is running iSQLPLUS?

Yes

Thx

Author

Commented:
This is waht I was trying tu use as my connect identifier:

CustomerDev.FREEDOM.LOCAL:1521/ERIC
Top Expert 2009

Commented:
For isqlplus just try using  ERIC

Author

Commented:
Received the same error:

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

Author

Commented:
any other ideas?  really need to solve this
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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>] | /

Author

Commented:
OK...weird....

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

Top Expert 2009

Commented:
Use a real username

user was for the example, not literal

Author

Commented:
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

Author

Commented:
Thx for hanging in there....Glen
Top Expert 2009

Commented:
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?

Author

Commented:
In with iSQLPLUS...now I just need to code the scripts to place in ERIC under the schema I need.

Thx
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.