|
|
| Re: sqlplus sys/password on Oracle 9i [message #57950 is a reply to message #57936] |
Tue, 22 July 2003 02:08   |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi David,
in Oracle 9i you could only connect as sys if using sys as sysdba or sys as sysoper. but this won't work from commandline. I am trying to find a way but mostly it works inside sqlplus with connect sys as sysdba and password.
Also connect internal is no longer valid in oracle 9i.
regards
Uwe
|
|
|
|
| Re: sqlplus sys/password on Oracle 9i [message #57959 is a reply to message #57936] |
Tue, 22 July 2003 09:33 |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
sqlplus 'sys/manger as sysdba' should work.
do a 'which sqlplus' and make sure that have the right binary.
--
% env | grep ORA
ORACLE_BASE=/u01/app/oracle
ORACLE_TNSPORT=1521
ORACLE_SID=dwdev
ORACLE_RELEASE=9.2.0.3.0
ORACLE_HOME=/u01/app/oracle/product/9.2.0
ORACLE_SERVICE=dwdev
% sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Jul 22 11:11:23 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
%
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
