Home » Server Options » Replication » why I use sqlplus internal, but the system ask me the passwd?
why I use sqlplus internal, but the system ask me the passwd? [message #75257] Tue, 27 August 2002 01:37 Go to next message
jack
Messages: 123
Registered: September 2000
Senior Member
I have a oracle problem, would you please help me?

if DB started
why I use sqlplus internal, but the system ask me the passwd?
after I key in the sys_passwd , I can login in oracle.

if DB not started
why I use sqlplus internal, but the system ask me the username & passwd
I key in the sys/sys_passwd but it does accept;

but I can use svrmgrl
connect sys/sys_passwd as sysdba.

why?

Thank you very much!

the process are as followings:

$ sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jul 24 14:33:04 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name: sys
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

Enter user-name: internal
ERROR:
ORA-01031: insufficient privileges

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
$
$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

SVRMGR> connect sys/sys as sysdba
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 255912424 bytes
Fixed Size 104936 bytes
Variable Size 129806336 bytes
Database Buffers 125829120 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SVRMGR> quit
Server Manager complete.

$ sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jul 24 14:34:33 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

SQL> show sga

Total System Global Area 255912424 bytes
Fixed Size 104936 bytes
Variable Size 129806336 bytes
Database Buffers 125829120 bytes
Redo Buffers 172032 bytes
SQL>
SQL> quit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Producti
on
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production
Re: why I use sqlplus internal, but the system ask me the passwd? [message #75526 is a reply to message #75257] Thu, 29 July 2004 06:51 Go to previous message
Jimme
Messages: 1
Registered: July 2004
Junior Member
Try visiting the following link:

http://www.experts-exchange.com/Databases/Oracle/Q_21021913.html

Previous Topic: What is the best way to replicate the data?
Next Topic: Oracle Snapshot/ Job
Goto Forum:
  


Current Time: Thu Mar 28 14:10:07 CDT 2024