| why I use sqlplus internal, but the system ask me the passwd? [message #75257] |
Tue, 27 August 2002 01:37  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
