You probably have it during the startup phase of your database.
Make sure you check or set on the following points :
$ export ORACLE_HOME
$ export PATH
$ export ORACLE_SID
And the entries in the pfile (In my case left a blank line :)
Sunday, March 20, 2011
Failed to verify status
Do you have the below error when you setup ORACLE_HOME :
Failed to verify status of /u01/app/oracle/product/11.1.0/inventory/ContentsXML/oraclehomeproperties.xml.
Example-
$ . oraenv
ORACLE_SID = [WMSDEV] ? TEST11
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0 is Failed to verify status of /u01/app/oracle/product/11.1.0/inventory/ContentsXML/oraclehomeproperties.xml. Error returned is 13
Unable to change directory to /u01/app/oracle/product/11.1.0/inventory/ContentsXML/ location. The error returned is 13
===================================================================================
Provide 777 Privs to the file oraclehomeproperties.xml at /u01/app/oracle/product/11.1.0/inventory/ContentsXML
If that still doesnt work provide 777 recursive privs (chmod -R 777 inventory)to the inventory folder.
Should'nt bug you the next time ..!
Failed to verify status of /u01/app/oracle/product/11.1.0/inventory/ContentsXML/oraclehomeproperties.xml.
Example-
$ . oraenv
ORACLE_SID = [WMSDEV] ? TEST11
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0 is Failed to verify status of /u01/app/oracle/product/11.1.0/inventory/ContentsXML/oraclehomeproperties.xml. Error returned is 13
Unable to change directory to /u01/app/oracle/product/11.1.0/inventory/ContentsXML/ location. The error returned is 13
===================================================================================
Provide 777 Privs to the file oraclehomeproperties.xml at /u01/app/oracle/product/11.1.0/inventory/ContentsXML
If that still doesnt work provide 777 recursive privs (chmod -R 777 inventory)to the inventory folder.
Should'nt bug you the next time ..!
Saturday, March 12, 2011
ORA-24324: service handle not initialized
So heres a Bug:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 10 09:19:17 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected.
====================================================
Above is what i had even after i killed the pmon process.
Ideally it should have conected as an Idle Instance.
Anything you try to do further would have the following errors:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 10 09:19:17 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected.
SQL> shutdown abort;
ORA-03113: end-of-file on communication channel
SQL> startup mount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
=========================================================================
However Oracle suggests to raise a tar for this.
I tried a simpler way -
Kill -9 all ps -ef | grep ora procs.
OR A server bounce would help too.
NOW try to reconnect.....
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Mar 11 09:30:54 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
Worked well enough...!
$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 10 09:19:17 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected.
====================================================
Above is what i had even after i killed the pmon process.
Ideally it should have conected as an Idle Instance.
Anything you try to do further would have the following errors:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 10 09:19:17 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected.
SQL> shutdown abort;
ORA-03113: end-of-file on communication channel
SQL> startup mount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
=========================================================================
However Oracle suggests to raise a tar for this.
I tried a simpler way -
Kill -9 all ps -ef | grep ora procs.
OR A server bounce would help too.
NOW try to reconnect.....
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Mar 11 09:30:54 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
Worked well enough...!
Saturday, March 5, 2011
./rda.sh -T hcve
A remote diagnostic agent (RDA) always helps for a precheck to any oracle installation.
Below is a sample output:
$ ./rda.sh -T hcve
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (Solaris)
2. Oracle Database 10g R2 (10.2.0) Preinstall (Solaris)
3. Oracle Database 11g R1 (11.1.0) Preinstall (Solaris)
4. Oracle Database 11g R2 (11.2.0) Preinstall (Solaris)
5. Oracle Application Server 10g (9.0.4) Preinstall (Solaris)
6. Oracle Application Server 10g R2 (10.1.2) Preinstall (Solaris-sparc)
7. Oracle Application Server 10g R2 (10.1.2) Preinstall (Solaris-x86)
8. Oracle Fusion Middleware 11g R1 (11.1.1) Preinstall (Solaris)
9. Oracle Portal Preinstall (Generic)
10. Oracle Identity Management 10g (10.1.4) Preinstall (Solaris)
11. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Solaris)
12. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Solaris)
Available Post-Installation Rule Sets:
13. Oracle Portal Postinstall (generic)
14. Data Guard Postinstall (Generic)
Enter the HCVE rule set number
Hit 'Return' to accept the default (1)
> 3
Enter value for < Planned ORACLE_HOME location >
Hit 'Return' to accept the default (/u01/app/oracle/product)
>
Enter value for < JDK Home >
> /usr/jdk/jdk1.5.0_22
Test "Oracle Database 11g R1 (11.1.0) Preinstall (Solaris)" executed at 26-Feb-2011 19:31:41
Test Results
~~~~~~~~~~~~
ID NAME RESULT VALUE
====== ==================== ======= ==========================================
A00010 OS Certified? PASSED Certified with 11gR1 RDBMS
A00020 User in /etc/passwd? PASSED userOK
A00040 Group in /etc/group? PASSED GroupOK
A00050 Enter ORACLE_HOME RECORD /u01/app/oracle/product
A00060 ORACLE_HOME Valid? PASSED OHexists
A00070 O_H Permissions OK? PASSED CorrectPerms
A00080 oraInventory Permiss PASSED oraInventoryNotFound
A00090 Got ld,nm,ar,make? PASSED ld_nm_ar_make_Found
A00100 Umask Set to 022? PASSED UmaskOK
A00110 ulimits OK? PASSED ulimitOK
A00140 LDLIBRARYPATH Unset? FAILED IsSet
A00150 LDLIBRARYPATH64 Unse PASSED UnSet
A00190 Enter JDK Home RECORD /usr/jdk/jdk1.5.0_22
A00200 JDK Version PASSED Adequate
A00210 Other O_Hs in PATH? PASSED NoneFound
A00220 Other OUI Up? PASSED NoOtherOUI
A00230 /tmp Adequate? PASSED TempSpaceOK
A00240 Disk Space OK? PASSED DiskSpaceOK
A00250 Swap (in MB) RECORD 97588.0078125
A00260 RAM (in MB) PASSED 131072
A00270 SwapToRAM OK? FAILED SwapLessThanRAM
A00290 IP Address RECORD 143.222.222.102
A00300 Domain Name RECORD cummins.com
A00310 DNS Lookup PASSED Host correctly registered in DNS
A00320 /etc/hosts Format FAILED Missing host.domain
A00330 Kernel Parameters OK FAILED NOEXEC_USER_STACKUndef
A00370 Kernel Level OK? PASSED adequate
A00410 Got OS Patches? PASSED adequate
A00430 Got OS Packages? PASSED All required OS packages are installed
A00580 Cluster Information PASSED TestCompleted
Result file: /u01/app/oracle/product/rda/output/RDA_HCVE_A200DB11R1_sol_res.html
=================================================================================
Always make sure to have all checks passed,with some execptions.
NOEXEC_USER_STACKUndef Failed => is ok to go with as the parapetr is depcreted since Solaris 9.
SwapLessThanRAM Failed => As long as you have sufficient Swap space and Ram (as per oracle installation doc) its fine.
LDLIBRARYPATH => Its fine to have LDLIBRARYPATH unset to any value.
/etc/hosts Format => Not too sure why this failed. I however neglected this precheck , but made sure the /etc/hosts file had the correct entries in the right format.
example:
127.0.0.1 localhost
123.456.789.101 hostname.domainname hostname
Below is a sample output:
$ ./rda.sh -T hcve
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (Solaris)
2. Oracle Database 10g R2 (10.2.0) Preinstall (Solaris)
3. Oracle Database 11g R1 (11.1.0) Preinstall (Solaris)
4. Oracle Database 11g R2 (11.2.0) Preinstall (Solaris)
5. Oracle Application Server 10g (9.0.4) Preinstall (Solaris)
6. Oracle Application Server 10g R2 (10.1.2) Preinstall (Solaris-sparc)
7. Oracle Application Server 10g R2 (10.1.2) Preinstall (Solaris-x86)
8. Oracle Fusion Middleware 11g R1 (11.1.1) Preinstall (Solaris)
9. Oracle Portal Preinstall (Generic)
10. Oracle Identity Management 10g (10.1.4) Preinstall (Solaris)
11. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Solaris)
12. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Solaris)
Available Post-Installation Rule Sets:
13. Oracle Portal Postinstall (generic)
14. Data Guard Postinstall (Generic)
Enter the HCVE rule set number
Hit 'Return' to accept the default (1)
> 3
Enter value for < Planned ORACLE_HOME location >
Hit 'Return' to accept the default (/u01/app/oracle/product)
>
Enter value for < JDK Home >
> /usr/jdk/jdk1.5.0_22
Test "Oracle Database 11g R1 (11.1.0) Preinstall (Solaris)" executed at 26-Feb-2011 19:31:41
Test Results
~~~~~~~~~~~~
ID NAME RESULT VALUE
====== ==================== ======= ==========================================
A00010 OS Certified? PASSED Certified with 11gR1 RDBMS
A00020 User in /etc/passwd? PASSED userOK
A00040 Group in /etc/group? PASSED GroupOK
A00050 Enter ORACLE_HOME RECORD /u01/app/oracle/product
A00060 ORACLE_HOME Valid? PASSED OHexists
A00070 O_H Permissions OK? PASSED CorrectPerms
A00080 oraInventory Permiss PASSED oraInventoryNotFound
A00090 Got ld,nm,ar,make? PASSED ld_nm_ar_make_Found
A00100 Umask Set to 022? PASSED UmaskOK
A00110 ulimits OK? PASSED ulimitOK
A00140 LDLIBRARYPATH Unset? FAILED IsSet
A00150 LDLIBRARYPATH64 Unse PASSED UnSet
A00190 Enter JDK Home RECORD /usr/jdk/jdk1.5.0_22
A00200 JDK Version PASSED Adequate
A00210 Other O_Hs in PATH? PASSED NoneFound
A00220 Other OUI Up? PASSED NoOtherOUI
A00230 /tmp Adequate? PASSED TempSpaceOK
A00240 Disk Space OK? PASSED DiskSpaceOK
A00250 Swap (in MB) RECORD 97588.0078125
A00260 RAM (in MB) PASSED 131072
A00270 SwapToRAM OK? FAILED SwapLessThanRAM
A00290 IP Address RECORD 143.222.222.102
A00300 Domain Name RECORD cummins.com
A00310 DNS Lookup PASSED Host correctly registered in DNS
A00320 /etc/hosts Format FAILED Missing host.domain
A00330 Kernel Parameters OK FAILED NOEXEC_USER_STACKUndef
A00370 Kernel Level OK? PASSED adequate
A00410 Got OS Patches? PASSED adequate
A00430 Got OS Packages? PASSED All required OS packages are installed
A00580 Cluster Information PASSED TestCompleted
Result file: /u01/app/oracle/product/rda/output/RDA_HCVE_A200DB11R1_sol_res.html
=================================================================================
Always make sure to have all checks passed,with some execptions.
NOEXEC_USER_STACKUndef Failed => is ok to go with as the parapetr is depcreted since Solaris 9.
SwapLessThanRAM Failed => As long as you have sufficient Swap space and Ram (as per oracle installation doc) its fine.
LDLIBRARYPATH => Its fine to have LDLIBRARYPATH unset to any value.
/etc/hosts Format => Not too sure why this failed. I however neglected this precheck , but made sure the /etc/hosts file had the correct entries in the right format.
example:
127.0.0.1 localhost
123.456.789.101 hostname.domainname hostname
Wednesday, March 2, 2011
Share what you know , and learn what you don't..
Heylo
Yet another Dba in a complex production environment.
Here's a blog for young aspiring Dba's like me :)
All i do is scribble my encounters with Oracle.
Hope to make the best of it.
Enjoy
Subscribe to:
Posts (Atom)