Home » RDBMS Server » Server Administration » sqlplus as dba
sqlplus as dba [message #51986] Mon, 24 June 2002 20:54 Go to next message
crystal
Messages: 5
Registered: August 2001
Junior Member
Dear experts,

I try to connect as DBA in sqlplus using the following syntax.
connect username/password as sysdba

It doesn't work, it say that:
ERROR: ORA-03121: no interface driver connected - function not performed

My sqlplus is running in window 2000 and oracle 8i running in aix.

Report message to a moderator

Re: sqlplus as dba [message #51987 is a reply to message #51986] Mon, 24 June 2002 22:32 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
ORA-03121 no interface driver connected - function not performed
Cause: This message occurs usually because the Net8 driver is not loaded into memory or there is a mismatch of the version of the driver. A user program linked with an obsolete library may also cause this message. Only programs provided by Oracle Corporation should use this interface.
Action: If the message occurred during use of a program provided by Oracle Corporation, contact customer support. If a user program caused the message, relink the program with current versions of the Oracle libraries.

MHE

Report message to a moderator

Re: sqlplus as dba [message #52016 is a reply to message #51986] Wed, 26 June 2002 12:06 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Make sure you already setup your account and db server to allow that. Read Those complete instructions how to connect as SYSDBA to remote machine.

Hope that helps,

clio_usa
OCP - DBA

Visit our web site [url=http://www.dbaclick.com]Click Here

Report message to a moderator

Previous Topic: ora00439 (Archivelogmode)
Next Topic: Adding old datafiles to new installation of oracle 8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:27:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.