Connect Identifier in iSQL Plus

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.
Glen_DAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mrjoltcolaCommented:
The error message will help us.
0
Glen_DAuthor Commented:
Thx...here it is:

       

ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
0
mrjoltcolaCommented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Glen_DAuthor 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)
    )
  )

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

Verify that you can: tnsping ORCL
from the command prompt
0
Glen_DAuthor 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)
0
Glen_DAuthor 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))
    )
  )

0
Glen_DAuthor 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>
0
mrjoltcolaCommented:
Is the same tnsnames.ora file on the server that is running iSQLPLUS?
0
Glen_DAuthor Commented:
Is the same tnsnames.ora file on the server that is running iSQLPLUS?

Yes

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

CustomerDev.FREEDOM.LOCAL:1521/ERIC
0
mrjoltcolaCommented:
For isqlplus just try using  ERIC
0
Glen_DAuthor Commented:
Received the same error:

ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
0
Glen_DAuthor Commented:
any other ideas?  really need to solve this
0
mrjoltcolaCommented:
On the server machine try:

tnsping ERIC
sqlplus user/pass@ERIC

Do those work from the server itself.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Glen_DAuthor 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>] | /
0
Glen_DAuthor Commented:
OK...weird....

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

0
mrjoltcolaCommented:
Use a real username

user was for the example, not literal

0
Glen_DAuthor 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
0
Glen_DAuthor Commented:
Thx for hanging in there....Glen
0
mrjoltcolaCommented:
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
Glen_DAuthor Commented:
In with iSQLPLUS...now I just need to code the scripts to place in ERIC under the schema I need.

Thx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.