Wednesday, April 18, 2012

ORA-01031 insufficient privileges sysdba login

Error
$ sqlplus /nolog
SQL>conn sys/xxx as sysdba;
error: "ORA-01031: insufficient privileges" 

Solution

$ORACLE_SID=oracle
$export ORACLE_SID
$ORACLE_HOME=/db/oracle/9.2.0
$export ORACLE_HOME
$cd /db/oracle/9.2.0/dbs
$mv orapworacle9i orapworacle9i_bk
$cd /db/oracle/9.2.0/bin
$orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=xxx entries=40
$ sqlplus /nolog
SQL>conn sys/xxx as sysdba;
Connected to an idle instance.
Check the metalink Document

SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=50507.1

Monday, April 9, 2012

EM install failed AIX 6.1 Database 11gR1

bash-3.00$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Apr 10, 2012 12:34:14 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: STAR
Unhandled exception
Type=Segmentation error vmState=0x00000000
J9Generic_Signal_Number=00000004 Signal_Number=0000000b Error_Value=00000000 Signal_Code=00000033
Handler1=09001000A03E0C78 Handler2=09001000A03D8538
R0=0000000000000000 R1=0FFFFFFFFFFFDF70 R2=0000000000000001 R3=0000000000000017
R4=0700000000353830 R5=00000000000000B8 R6=0000000000000000 R7=0000000000000018
R8=0000000000000000 R9=0000000000000001 R10=00000001101EC908 R11=09000000009B2C38
R12=00000001101CF0E4 R13=0000000110015FA0 R14=0000000111562800 R15=000000011016BF00
R16=0000000110A02270 R17=00000001122F39E8 R18=09001000A03E43B0 R19=0700000000000FA0
R20=000000011148FD08 R21=0000000111562968 R22=0000000000000032 R23=000000000000002A
R24=00000000995188BE R25=07000000003533C8 R26=FFFFFFFFFFFFFFFF R27=0000000000000017
R28=070000000035FF48 R29=0000000000000001 R30=0000000000000016 R31=0000000000000000
IAR=09000000009B2C38 LR=00000001101ECABC MSR=A00000000000D032 CTR=09000000009B2C38
CR=8458508420000003 FPSCR=8202000000000000 XER=2000000382020000
FPR0 0000000800000008 (f: 8.000000, d: 1.697597e-313)
FPR1 41e0000000000000 (f: 0.000000, d: 2.147484e+09)
FPR2 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR3 3fee666660000000 (f: 1610612736.000000, d: 9.500000e-01)
FPR4 4530000000000000 (f: 0.000000, d: 1.934281e+25)
FPR5 4530000000000000 (f: 0.000000, d: 1.934281e+25)
FPR6 3ff0000000000000 (f: 0.000000, d: 1.000000e+00)
FPR7 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR8 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR9 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR10 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR11 4026000000000000 (f: 0.000000, d: 1.100000e+01)
FPR12 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR13 4020800000000000 (f: 0.000000, d: 8.250000e+00)
FPR14 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR15 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR16 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR17 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR18 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR19 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR20 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR21 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR22 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR23 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR24 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR25 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR26 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR27 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR28 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR29 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR30 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR31 0000000000000000 (f: 0.000000, d: 0.000000e+00)
Module=/pd/Star/db/tech_st/11.1.0/jdk/jre/bin/libj9jit23.so
Module_base_address=0900000000988000
Target=2_30_20070131_11312_BHdSMr (AIX 6.1)
CPU=ppc64 (32 logical CPUs) (0x7b8000000 RAM)
JVMDUMP006I Processing Dump Event "gpf", detail "" - Please Wait.
JVMDUMP007I JVM Requesting System Dump using '/pd/Star/db/tech_st/11.1.0/bin/core.20120410.003419.9437226.dmp'
JVMDUMP010I System Dump written to /pd/Star/db/tech_st/11.1.0/bin/core.20120410.003419.9437226.dmp
JVMDUMP007I JVM Requesting Snap Dump using '/pd/Star/db/tech_st/11.1.0/bin/Snap0001.20120410.003419.9437226.trc'
JVMDUMP010I Snap Dump written to /pd/Star/db/tech_st/11.1.0/bin/Snap0001.20120410.003419.9437226.trc
JVMDUMP007I JVM Requesting Java Dump using '/pd/Star/db/tech_st/11.1.0/bin/javacore.20120410.003419.9437226.txt'
JVMDUMP010I Java Dump written to /pd/Star/db/tech_st/11.1.0/bin/javacore.20120410.003419.9437226.txt
JVMDUMP013I Processed Dump Event "gpf", detail "".

----

bash-3.00$ java -version
java version "1.6.0"
Java(TM) SE Runtime Environment (build pap3260-20071123_01)
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 AIX ppc-32 jvmap3260-20071121_15015 (JIT enabled)
J9VM - 20071121_015015_bHdSMR
JIT  - r9_20071121_1330
GC   - 20071031_AA)
JCL  - 20071118_01

---

The solution for this error is run below command before starting the task
export JAVA_COMPILER=NONE