-
TNS-Error
I try to connect an instance in the proper server and I give the following error.
Enter user-name: oracle@folha
Enter password:
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
If I connect of any another place it does not give error and it functions perfectly.
Why ?
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
If you are using tnsnames file, is it configured with correct service name? What is the default domain in sqlnet.ora file. And what do you mean by "connect to other place". List your tnsnames.ora and sqlnet.ora entry.
-- Dilip
-
That is like the simplest Oracle error in the world to fix. Real good book on explaining Net8/Oracle Net is O'Reilly's Oracle Net8 Configuration and Troubleshooting.
-
I possess other instances in the same server and obtain I connect them. But this new instance does not connect.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
Originally posted by marcio.68
I possess other instances in the same server and obtain I connect them. But this new instance does not connect.
Funny things like that happen when you don't have your connections configured correctly.
Jeff Hunter
-
I found the problem. The service_name was different of the SID and listner pointed with respect to the SID, therefore inside of the same server I did not obtain to consult the base.
debtor to all
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|