Search This Blog

Showing posts with label Oracle 9ir2. Show all posts
Showing posts with label Oracle 9ir2. Show all posts

Thursday, January 26, 2012

ORA-19206: Invalid value for query or REF CURSOR parameter ORACLE 9i while export

Connected to: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user STERLIVE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user STERLIVE
About to export STERLIVE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 1156
ORA-06512: at "SYS.DBMS_METADATA", line 1141
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

We are receiving the above error message while exporting database in oracle 9i.

Solution: run the catmeta.sql at sys user ($ORACLE_HOME/rdbms/admin/catmeta.sql)

Friday, September 30, 2011

you don't have sufficient privileges to write to the specified path in component Database Configuration Assistant 9.2.0.1.0 installation cannot continue for this component

While installing oracle 9204 on linux then getting following message after selection of installation type at privileged system group screen.
you don't have sufficient privileges to write to the specified path in component Database Configuration Assistant 9.2.0.1.0 installation cannot continue for this component

Reason: ORACLE_BASE is not defined prior to execute runinstaller
Solution: set ORACLE_BASE and give the proper permission to oracle user on oracle base directory, after that re-execute runinstaller

Error occurred during initialization of VM-unable to install oracle 9.2.0.4 on linux

Today when i trying to install oracle 9.2.0.4 on linux machine then after running runInstaller i got the following message


Error occurred during initialization of VM
Unable to load native library: /tmp/OraInstall2011-09-30_xxxxxxxjre/lib/i386/libjava.so:
    symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference 


Reason: This is due to BUG
Solution: download and install following patch (linux) from metalink and apply.

To resolve the __libc_wait symbol issue, download the p3006854_9204 patch p3006854_9204_LINUX.zip from http://metalink.oracle.com. See bug 3006854 for more information.


How to install ?

[root@oradev db]# dir
9204  app  ORA9I  p3006854_9204_LINUX.zip 
[root@oradev db]# unzip p3006854_9204_LINUX.zip
Archive:  p3006854_9204_LINUX.zip
   creating: 3006854/
  inflating: 3006854/rhel3_pre_install.sh
  inflating: 3006854/README.txt
[root@oradev db]# cd 3006854/
[root@oradev 3006854]# sh rhel3_pre_install.sh
Applying patch...
Ensuring permissions are correctly set...
Done.
Patch successfully applied
[root@oradev 3006854]#

Saturday, September 17, 2011

Enable auditing for SYSDBA (sys) user in 9ir2

SYS audit feature introduce in oracle 9ir2 

How to enable SYS audit?
1. set the following three parameters
1.1 
audit_file_dest == (location of audit files (OS) based)
audit_sys_operations === true ( enable sys audit)
audit_trail = OS 

SQL> select * from v$version where rownum=1;

BANNER
----------------------------------------------------------------
Oracle9i Release 9.2.0.4.0 - Production

SQL> show parameter audit-
>

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      ?/rdbms/audit
audit_sys_operations                 boolean     FALSE
audit_trail                          string      NONE
transaction_auditing                 boolean     TRUE
SQL> host echo $ORACLE_HOME
/disk1/app/oracle/product/9.2.0


SQL>  alter system set audit_file_dest='/disk1/app/oracle/product/9.2.0/audit' s                                                                             cope=spfile;

System altered.


SQL> alter system set audit_sys_operations=true scope=spfile;

System altered.

SQL> alter system set audit_trail='OS' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> startup
ORACLE instance started.

Total System Global Area  202445884 bytes
Fixed Size                   451644 bytes
Variable Size             184549376 bytes
Database Buffers           16777216 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

SQL> host ls -lrt $ORACLE_HOME/audit
total 8
-rw-r-----  1 oracle dba 1103 Sep 17 19:44 ora_25676.aud
-rw-r-----  1 oracle dba  734 Sep 17 19:44 ora_25677.aud

SQL>  host cat $ORACLE_HOME/audit/ora_25676.aud
Audit file /disk1/app/oracle/product/9.2.0/audit/ora_25676.aud
Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /disk1/app/oracle/product/9.2.0
System name:    Linux
Node name:      SPI-ISIS
Release:        2.6.9-78.ELsmp
Version:        #1 SMP Wed Jul 9 15:39:47 EDT 2008
Machine:        i686
Instance name: STERLIVE
Redo thread mounted by this instance: 0
Oracle process number: 14
Unix process pid: 25676, image: oracle@SPI-ISIS (TNS V1-V3)

Sat Sep 17 19:44:16 2011
ACTION : 'CONNECT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL:
STATUS: 0

Sat Sep 17 19:44:16 2011
ACTION : 'SELECT DECODE(null,'','Total System Global Area','') NAME_COL_PLUS_SHO                                                                             W_SGA,    SUM(VALUE), DECODE (null,'', 'bytes','')  FROM V$SGA    UNION ALL    S                                                                             ELECT NAME NAME_COL_PLUS_SHOW_SGA , VALUE,    DECODE (null,'', 'bytes','') FROM                                                                              V$SGA'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL:
STATUS: 0

Sat Sep 17 19:44:20 2011
ACTION : 'ALTER DATABASE   MOUNT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL:
STATUS: 0