Solved

Connect Identifier in iSQL Plus

Posted on 2009-07-01
22
1,206 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
 

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

 
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.

Join & Write a Comment

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now