A question about using SQLPLUS

thomas2004ch · 07-15-2010, 03:48 AM

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?

stuart_cherrington · 07-15-2010, 04:00 AM

Can you paste the output of your tnsnames.ora file?

Stuart.

thomas2004ch · 07-15-2010, 04:38 AM

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.