ORA-01012: not logged on - Linked Server to Oracle

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

ORA-01012: not logged on - Linked Server to Oracle

Author

Topic

razorhazor
Starting Member

1 Post

Posted - 2008-11-11 : 06:20:41

Hi,

I've setup a linked server to an oracle 10g database and am getting the following error when querying it through OpenQuery...

ORA-01012: not logged on

Oracle installation is fine, SQLPlus works fine, also the MDAC Oracle OLEDB Driver works fine, just the Oracle one (which is quicker).

I've setup the correct security login on the linked server also.

Cheers
Matt

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-11-11 : 06:48:16

did u set valid remote username and passward

/
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'ORACLE IP or Network Name'
@useself = false,
@locallogin = 'sa', -- local SQL Server 2005 login
@rmtuser = 'login', -- ORACLE Login
@rmtpassword = 'pass' -- ORACLE Password
GO/

Also read...
http://www.sqlmag.com/Article/ArticleID/49687/sql_server_49687.html

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources