| Linux Oracle 10g-Error---ORA- 12514 [message #199208] |
Sat, 21 October 2006 04:49  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
