You encounter ORA-01031: insufficient privileges error:
[root@ProdDB01 ~]# dbstart
SQL*Plus: Release 8.1.6.0.0 – Production on Thu Mar 20 11:54:55 2014
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> ERROR:
ORA-01031: insufficient privileges
SQL>
[3]+ Stopped dbstart
[root@ProdDB01 ~]#
Fix:
Login as Oracle user or SysDBA. Usually, many of the administrators mayn’t have sysdba password. The workaround is to do sudo as Oracle user and start the database.
[root@ProdDB01 ~]# su – oracle
-bash-3.1$ lsnrctl start
LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 20-MAR-2014 12:12:07
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
-bash-3.1$ dbstart
SQL*Plus: Release 8.1.6.0.0 – Production on Thu Mar 20 12:12:15 2014
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 122736624 bytes
Fixed Size 69616 bytes
Variable Size 91774976 bytes
Database Buffers 30720000 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: ‘/opt/db1/oradata/inst3/system01inst3.dbf’
SQL> Disconnected
Database "inst3" warm started.
-bash-3.1$
-bash-3.1$ ps -ef | grep pmon
oracle 24690 1 0 12:12 ? 00:00:00 ora_pmon_inst3
oracle 24849 24620 0 12:17 pts/1 00:00:00 grep pmon
-bash-3.1$
