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
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

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
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.

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
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
Goto Forum:

Current Time: Wed Jul 26 02:11:00 CDT 2017

Total time taken to generate the page: 0.25479 seconds