sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 23 09:19:21 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
ORA-01994: GRANT failed: password file missing or disabled
Cause: The operation failed either because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to NONE or else because the password file was missing.
Action: Create the password file using the orapwd tool and set the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE.
http://ora-01994.ora-code.com/
Checking
local operation:
SQL> show parameter pass
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>
SQL> select * from v$pwfile_users;
no rows selected
Remote operation:
SQL> conn sys/yourpassword@pdhptlt10g_ydcrh08
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
SQL> conn sys/yourpassword@pdhptlt10g_ydcrh08 as sysdba
ERROR:
ORA-01031: insufficient privileges
Local
SQL> alter system set remote_login_passwordfile=exclusive scope=spfile;
alter system set remote_login_passwordfile=exclusive scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
orapwd file=pwdngenpbt.ora password=yourpassword entries=2
show parameter pass
缺省目录
UNIX: ${ORACLE_HOME}/dbs/
NT: ${ORACLE_HOME}\database
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0.4.0.as/dbs/initpdhptlt10g.ora'
Disconnected
pwd
/opt/oracle/product/10.2.0.4.0.as/dbs
ln -s /db/pdhptlt10g/dbdump/pfile/initpdhptlt10g.ora initpdhptlt10g.ora
Or create initpdhptlt10g.ora file contain below line.
ifile=/db/pdhptlt10g/dbdump/pfile/initpdhptlt10g.ora
sh startupdb.sh pdhptlt10g
The Oracle base for ORACLE_HOME=/opt/oracle/product/10.2.0.4.0.as is /opt/oracle/product
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 23 10:02:30 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 1677721600 bytes
Fixed Size 2084424 bytes
Variable Size 603980216 bytes
Database Buffers 1056964608 bytes
Redo Buffers 14692352 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
The Oracle base for ORACLE_HOME=/opt/oracle/product/10.2.0.4.0.as is /opt/oracle/product
2010-12-23:10:02:Starting Listener:pdhptlt10g
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 23-DEC-2010 10:02:36
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2.0.4.0.as/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /etc/listener.ora
Log messages written to /db/pdhptlt10g/dbdump/ndump/pdhptlt10g.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=pdhptlt10g)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ydcrh04.ydcdom01.com)(PORT=15037)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=pdhptlt10g))
STATUS of the LISTENER
------------------------
Alias pdhptlt10g
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 23-DEC-2010 10:02:36
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /etc/listener.ora
Listener Log File /db/pdhptlt10g/dbdump/ndump/pdhptlt10g.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=pdhptlt10g)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ydcrh04.ydcdom01.com)(PORT=15037)))
Services Summary...
Service "pdhptlt10g" has 1 instance(s).
Instance "pdhptlt10g", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
http://www.eygle.com/faq/passwordfile.htm
