?
Solved

Connect Identifier in iSQL Plus

Posted on 2009-07-01
22
Medium Priority
?
1,213 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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 2000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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…
Suggested Courses

765 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