Hi Friends,
The other day while doing an Oracle Database 11.2.0.3 installation on OEL 6.2 , I encountered the below error :
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGILL (0x4) at pc=0x00000032a5214be0, pid=27556, tid=140458177951488
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_30-b03 mixed mode)
# Problematic frame:
# C [ld-linux-x86-64.so.2+0x14be0]
#
# An error report file with more information is saved as hs_err_pid27556.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
On looking up with MOS found that this is
https://bugzilla.redhat.com/show_bug.cgi?id=752122
Soln: export LD_BIND_NOW=1 , prior starting with the installation.
QuickInfo about LD_BIND_NOW
Direct the dynamic linker to resolve all references immediately.
In that way, you can learn before execution of main() begins
that the functions invoked by your process actually are defined.
Got a Java hotspot error while launching DBCA ! Solved.
Quick demo of OMF and UMF.
###################################
# LOGIN as Oracle #
###################################
[oracle@OEL61A admin]$ ps -ef | grep pmon
grid
3176 1 0 Dec12 ? 00:00:18 asm_pmon_+ASM
oracle
8176 677 0 15:19 pts/6 00:00:00 grep pmon
oracle
22351 1 0 Dec12 ? 00:00:17 ora_pmon_demo
[oracle@OEL61A admin]$ . oraenv
ORACLE_SID = [demo] ? demo
[oracle@OEL61A admin]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec
13 15:19:14 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
SQL> select name from v$database;
NAME
---------
DEMO
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ -----------
-------
db_create_file_dest string +DATA
SQL> select name from v$datafile;
NAME
--------------------------------------------
+DATA/demo/datafile/system.273.801569117
+DATA/demo/datafile/sysaux.274.801569125
+DATA/demo/datafile/undotbs1.275.801569131
+DATA/demo/datafile/users.277.801569135
+DATA/demo/datafile/apps_tbs.278.801569853
+DATA/demo/datafile/indx_tbs.279.801569915
SQL> --Please note the changes to FRA are effective only in the memory
SQL> alter system set db_create_file_dest='+FRA' scope=MEMORY;
System altered.
SQL> show parameter db_create_file_dest
NAME
TYPE VALUE
------------------------------------ -----------
------------------------------
db_create_file_dest string +FRA
SQL> --No file name is specified for the below :
SQL> create tablespace omf_tes;
Tablespace created.
SQL> select name from v$datafile;
NAME
-------------------------------------------
+DATA/demo/datafile/system.273.801569117
+DATA/demo/datafile/sysaux.274.801569125
+DATA/demo/datafile/undotbs1.275.801569131
+DATA/demo/datafile/users.277.801569135
+DATA/demo/datafile/apps_tbs.278.801569853
+DATA/demo/datafile/indx_tbs.279.801569915
+FRA/demo/datafile/omf_test.283.801933663 <---This
is the new file created
###################################
# LOGIN as GRID on another Session#
###################################
login as: grid
Access denied
grid@10.184.86.86's password:
[grid ~]$ ps -ef | grep pmon
grid
3176 1 0 Dec12 ? 00:00:18 asm_pmon_+ASM
grid
8456 8429 0 15:22 pts/7 00:00:00 grep pmon
oracle
22351 1 0 Dec12 ? 00:00:17 ora_pmon_demo
[grid ~]$ . oraenv
ORACLE_SID = [+ASM] ? +ASM
[grid ~]$ asmcmd
ASMCMD> cd +FRA
ASMCMD> cd demo
ASMCMD> ls
ARCHIVELOG/
CONTROLFILE/
DATAFILE/
ONLINELOG/
ASMCMD> cd DATAFILE
ASMCMD> ls
OMF_TEST.283.801933663 <--- We could able to see the file
created in our storage
###################################
# Back to Oracle Session #
###################################
SQL> drop tablespace omf_test;
Tablespace dropped.
###################################
# Back GRID Session #
###################################
ASMCMD> pwd
+FRA/demo/DATAFILE
ASMCMD> ls <--- The File is auto
matically deleted
ASMCMD-8002: entry 'DATAFILE' does not exist in
directory '+FRA/demo/'
ASMCMD>
###################################
# Back to Oracle Session #
###################################
SQL> --This time we are specifying a file on LOCAL Storage.
SQL> create tablespace omf_test datafile
'/u01/app/oracle/admin/demo/datafile/omf_test.dbf' size 100k;
Tablespace created.
SQL> select name from v$datafile ;
NAME
-------------------------------------------------
+DATA/demo/datafile/system.273.801569117
+DATA/demo/datafile/sysaux.274.801569125
+DATA/demo/datafile/undotbs1.275.801569131
+DATA/demo/datafile/users.277.801569135
+DATA/demo/datafile/apps_tbs.278.801569853
+DATA/demo/datafile/indx_tbs.279.801569915
/u01/app/oracle/admin/demo/datafile/omf_test.dbf
SQL> drop tablespace omf_test;
Tablespace dropped.
#File on OS
even after deleting on the Unix File System
[oracle ~ datafile]$ ls -lt
total 112
-rw-r----- 1 oracle asmadmin 114688 Dec 13 15:36
omf_test.dbf
Finding the DBA,OPER and ASM Group of existing database.
cat $ORACLE_HOME/rdbms/lib/config.c
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
/* IMPORTANT: this file needs to be in sync with
rdbms/src/server/osds/config.c, specifically regarding the
number of elements in the ss_dba_grp array.
*/
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
/* IMPORTANT: this file needs to be in sync with
rdbms/src/server/osds/config.c, specifically regarding the
number of elements in the ss_dba_grp array.
*/
#define SS_OPER_GRP "dba"
#define SS_ASM_GRP ""
char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP, SS_ASM_GRP};
What is Maximum Data file Size Limitation In an Oracle Database?
Oracle Database Reference 10g Release 2 (10.2)
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits002.htm#i287915
Subscribe to:
Posts (Atom)