Home » Infrastructure » Linux » Linux Oracle 10g-Error---ORA- 12514
Linux Oracle 10g-Error---ORA- 12514 [message #199208] Sat, 21 October 2006 04:49 Go to next message
privilraj
Messages: 1
Registered: October 2006
Location: INDIA
Junior Member
Hai Sir
I can connect the database throgh
>system/system (system user password is system)
I can get sql prompt and work select command also
and
My connection string is dsoft

I check this string use this command
show parameter service_name
igot the value --- service_names string dsoft ---

But I use to connect system/system@dsof

I got this error

ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

I was check my tnsnames.ora file also

Plese give me a solution to log on with string

Regards

Privilraj
privilra@yahoo.co.uk
Re: Linux Oracle 10g-Error---ORA- 12514 [message #199210 is a reply to message #199208] Sat, 21 October 2006 05:01 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
But I use to connect system/system@dsof

I got this error

ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

May be it is just typo.
You are using dbsof instead dbsoft.
Morever, you need to check your tnsnames.ora
to connect like this
>>connect system/system@dsof
you need a listener configured via listener.ora that will listen to this database connection.
you also need a proper entry in tnsnames.ora that will identify the tnsservicename that connects to the said database.
Your tnsservicename can be anything.
Search the forum.
There a hundreds of examples.
Previous Topic: Exp on Window / Imp on Linux - Problem (IMP-00038)
Next Topic: Installation steps
Goto Forum:
  


Current Time: Fri Mar 29 09:12:21 CDT 2024