LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-15-2010, 03:48 AM   #1
thomas2004ch
Member
 
Registered: Aug 2009
Posts: 537

Rep: Reputation: 32
A question about using SQLPLUS


I installed the oracle client. The database name is corcivt with username 'test' and password 'test'.

Now I try using sqlplus to connect to this database as fllow:
Code:
sqlplus /nolog
and then
Code:
connect test/test@corcivt
But I got error as follow:
Code:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
It seems I have to do some configuration. But where?
 
Old 07-15-2010, 04:00 AM   #2
stuart_cherrington
Member
 
Registered: Aug 2008
Location: Get back in your Cube Unix Boy!
Distribution: rh5, oel5, debian etch, solaris
Posts: 228

Rep: Reputation: 36
Can you paste the output of your tnsnames.ora file?

Stuart.
 
Old 07-15-2010, 04:38 AM   #3
thomas2004ch
Member
 
Registered: Aug 2009
Posts: 537

Original Poster
Rep: Reputation: 32
Sorry, I have to make some correction. The client is remotely. So the access to the database is remote accessing.

I solve the problem now.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle SQLPlus Help StupidNewbie Programming 2 08-18-2008 02:48 PM
sqlplus problem kshkid Programming 8 05-09-2007 07:20 PM
How to run sqlplus? sikandar Linux - Software 5 09-01-2003 12:42 AM
SQLPLUS Help with 5 Questions kb2010 Programming 3 09-03-2002 08:14 AM
Sqlplus mikeshn Programming 1 07-16-2002 10:13 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:56 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration