sqlplus ORA-01031: insufficient privileges

You want to connect intance to start.(oracle 11g)

but there is an error.

like

[oracle@oratest01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 23 02:00:05 2009

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges

1-Check groups in linux.(if dba group doesn't exist firstly create it)

more /etc/group
.
....

oinstall:x:500:
dba:x:501:oracle


2-Check your oracle user groups

more /etc/passwd
.
....
oracle:x:500:500::/home/oracle:/bin/bash



[root@oratest01 ~]# id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)

Change Oracle Database Name and DBID with NID utility

Change Oracle Database Name and DBID with NID utility

--close database with immediate 

SHUTDOWN IMMEDIATE

STARTUP MOUNT

--run "nid" command. end process of nid command database will be shutdown.

nid target=sys/oracle@RADB dbname=TSH2

--change db_name to new name in pfile

db_name =TSH2

--create a password file for new ORACLE_SID 

orapwd file=D:\oracle\product\11.1.0\db_1\database\pwdTSH2.ora password=oracle entries=10

--if os windows delete old service.

oradim -delete -SID RADB

--if os windows add service for new ORACLE_SID

oradim -new -SID TSH2

-- listener reload    

lsnrctl reload

--open database with resetlogs

STARTUP MOUNT

--if you want, you can rename database and redo file's name.

set linesize 200

select 'alter database rename file '''||name  ||''' to '''||replace(name, 'ORATST','ORCL')  ||''';' from v$datafile;

select 'alter database rename file '''||name  ||''' to '''||replace(name, 'ORATST','ORCL')  ||''';' from v$tempfile;

select 'alter database rename file '''||member||''' to '''||replace(member, 'ORATST','ORCL')||''';' from v$logfile;

ALTER DATABASE OPEN RESETLOGS;