Home » RDBMS Server » Networking and Gateways » ORA-12514 dblink as non oracle user (Oracle 10g, Solaris 9)
ORA-12514 dblink as non oracle user [message #424310] Thu, 01 October 2009 09:05 Go to next message
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 Go to previous messageGo to next message
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.
Re: ORA-12514 dblink as non oracle user [message #424475 is a reply to message #424472] Fri, 02 October 2009 09:56 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Post your TNSNAMES.ORA Entry
Previous Topic: ODBC connection to SQL Server 2008
Next Topic: Not able to login to oracle 9.2.0.6
Goto Forum:
  


Current Time: Thu Dec 08 03:49:30 CST 2016

Total time taken to generate the page: 0.07229 seconds