| ORA-12514 dblink as non oracle user [message #424310] |
Thu, 01 October 2009 09:05  |
nsingh49
Messages: 9
Registered: August 2007
|
Junior Member |
|
|
Hi there,
I have a non-oracle OS user on my server which has access to all the oracle binaries. I can sqlplus being logged in this user, called biuser. Everything works fine except the dblink.
I can sqlplus and create dblink, but that link give me :
SQL> select * from dual@dwprod;
select * from dual@dwprod
*
ERROR at line 1:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
BUT, when I login as oracle, it works fine..
I know there is a permission issue...
|
|
|
|
| Re: ORA-12514 dblink as non oracle user [message #424472 is a reply to message #424310] |
Fri, 02 October 2009 09:30  |
mohd_dba
Messages: 19
Registered: October 2009
|
Junior Member |
|
|
After creation of Database link we wont assign any permission.It might be the problem of TNSNames.ora.Please check the tns entry.And execute the select statement once again.
If tnsnames is ok.Then there might be with the problem of Links which we will create.If the probelm is related to link.Either we need to disable or drop the link and recreate the database link once again.
Please correct.
Thanks,
Afroze.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
