Problem: After installing Oracle 9.2.0.4, netca and dbca fail with error:
jre was not found in:
/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads/jre
Solution: Change directory to:
/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads
Then create symbolic link to jre:
ln -s java jre
netca can now be launched.
Problem:
While installing Oracle 9.2.0.4 on Oracle Enterprise Linux 4 Update 4, the following error appears:
Error in invoking target install of makefile /u01/app/oracle/plsql/lib/ins_plsql.mk
Solution:
Applied patch 4198954 (COMPATIBILITY PACKAGES FOR ORACLE ON RHEL 4)
Applying patch 4198954 resolved the installation error.
Problem: While installing Oracle 9.2.0.4 for Linux, the following error appears in RunInstaller:
Error: You do not 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.
Solution: Export ORACLE_BASE:
export ORACLE_BASE=/u01/app/oracle
Exporting ORACLE_BASE resolved the issue.
Subject: Linux 9.2.0.4 Installation – Error: You do not have sufficient privileges to write to the specified path in Database Configuration Assistant Component (Doc ID: 267171.1)
Problem: While installing Oracle 9.2.0.4 on Oracle Enterprise Linux 4 Update 4, the following error appears:
Error occurred during initialization of VM
Unable to load native library: /tmp/OraInstall2009-08-31_01-27-21PM/jre/lib/i386/libjava.so:
symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
Solution: Apply patch 3006854.
Metalink Reference:
Subject: RUNINSTALLER FAILS ON RED HAT 3 TRYING TO INSTALL ORACLE9I
Doc ID: 264178.1
Problem: When attempting to log on to SQL*Plus as ”/ as sysdba’, the following error appears:
ERROR: ORA-12162: TNS:net service name is incorrectly specified
Solution: Set ORACLE_SID=ORCL
export ORACLE_SID=ORCL
Problem: While performing full export of production database, the following error is encountered:
. . exporting table WF_NOTIFICATION_OUT EXP-00056: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [kopi2_readlen083], [], [], [], [], [], [], []
Solution:
Cause:
Bug 3041387 ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KOPI2_READLEN083]
ORA-600 [kopi2_readlen083] can occur while enqueueing an object with an immediate embedded NULL.
This issue is fixed in Oracle Server 9.2.0.5 (Server patch set release) and in Oracle Server 10g.
Patch 3041387 is also available on Metalink.
Fix:
Please apply Oracle Server patch 3041387.
Metalink Reference:
Doc ID: 279647.1: Workflow Notifications Show Ora-00600 With Argument [Kopi2_readlen083] With Oracle Server 9.2
Problem:
When logging on to HRMS Production instance as SYSADMIN, the following message is displayed:
You have insufficient privileges for the current operation
Solution:
Log on to the HRMS Production server. Check the alert log for any ORA errors by issuing the following commands:
[applmgr@ebusiness /]$ [applmgr@ebusiness bdump]$ cd /u0/oracle/proddb/9.2.0/admin/PROD_ebusiness/bdump/ [applmgr@ebusiness bdump]$ tail alert_PROD.log Current log# 2 seq# 33933 mem# 1: /u0/oracle/proddata/log02b.dbf Tue Dec 2 09:46:30 2008 Completed checkpoint up to RBA [0x848d.2.10], SCN: 0x056d.102174e9 Tue Dec 2 10:00:40 2008 Beginning log switch checkpoint up to RBA [0x848e.2.10], SCN: 0x056d.1021d85e Thread 1 advanced to log sequence 33934 Current log# 1 seq# 33934 mem# 0: /u0/oracle/proddata/log01a.dbf Current log# 1 seq# 33934 mem# 1: /u0/oracle/proddata/log01b.dbf Tue Dec 2 10:15:50 2008 ORA-1654: unable to extend index ICX.ICX_SESSIONS_N1 by 35 in tablespace ICXX [applmgr@ebusiness bdump]$ [applmgr@ebusiness 9.2.0]$ sqlplus apps/******** SQL*Plus: Release 9.2.0.3.0 - Production on Tue Dec 2 10:25:25 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production SQL> desc dba_data_files Name Null? Type ----------------------------------------- -------- ---------------------------- FILE_NAME VARCHAR2(513) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTES NUMBER BLOCKS NUMBER STATUS VARCHAR2(9) RELATIVE_FNO NUMBER AUTOEXTENSIBLE VARCHAR2(3) MAXBYTES NUMBER MAXBLOCKS NUMBER INCREMENT_BY NUMBER USER_BYTES NUMBER USER_BLOCKS NUMBER SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX'; TABLESPACE_NAME FILE_NAME BYTES/1024/1024 --------------- ------------------------------ --------------- ICXX /u0/oracle/proddata/icxx01.dbf 20 SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M; alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M * ERROR at line 1: ORA-01031: insufficient privileges SQL> connect system/******** Connected. SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M; Tablespace altered. SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX'; TABLESPACE_NAME FILE_NAME BYTES/1024/1024 --------------- ------------------------------ --------------- ICXX /u0/oracle/proddata/icxx01.dbf 20 ICXX /u0/oracle/proddata/icxx02.dbf 20
Log on to SYSADMIN and confirm that the issue no longer exists.
Problem: When applying patch, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file affurgol.sql on worker 1. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked log file /u0/oracle/testappl/admin/TEST/log/adwork001.log:
declare * ERROR at line 1: ORA-01653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 2362205 in tablespace APPLSYSD ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 2380 ORA-06512: at line 55
Solution: Resize the next extent to 40K.
SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE'; TABLE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE BLOCKS ------------------------------ -------------- ----------- ----------- ----------- ------------ ---------- WF_LOCAL_ROLES_STAGE 40960 1.9351E+10 1 2147483645 0 1 SQL> alter table applsys.WF_LOCAL_ROLES_STAGE storage (next 40K); Table altered. SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE'; TABLE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE BLOCKS ------------------------------ -------------- ----------- ----------- ----------- ------------ ---------- WF_LOCAL_ROLES_STAGE 40960 40960 1 2147483645 0 1 SQL> alter table applsys.WF_LOCAL_ROLES_STAGE allocate extent; Table altered. SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE'; TABLE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE BLOCKS ------------------------------ -------------- ----------- ----------- ----------- ------------ ---------- WF_LOCAL_ROLES_STAGE 40960 65536 1 505 50 5
Here is some sample code using the UTL_FILE package:
DECLARE
string1 VARCHAR2(32767);
file1 UTL_FILE.FILE_TYPE;
BEGIN
-- file1 := UTL_FILE.FOPEN('TEMP_DIR','log_file_test','A'); -- open in append mode
file1 := UTL_FILE.FOPEN('/usr/tmp','log_file_test','A'); -- open in append mode
string1 := TO_CHAR(SYSDATE) || ' UTL_FILE test';
UTL_FILE.PUT_LINE(file1, string1); -- write a string to the file
UTL_FILE.FFLUSH(file1);
UTL_FILE.FCLOSE_ALL; -- close all open files
END;
/
[amazon asin=0596514468&template=iframe image&chan=default] [amazon asin=0137142838&template=iframe image&chan=default] [amazon asin=0071614214&template=iframe image&chan=default]
This documentation shows how to upgrade Oracle Applications RDBMS version 8.1.7 to 9.2.0.
Step 1: Go to Metalink and order or download the three CDs for 9.2.0.1, for the correct platform
Step 2: Shutdown the application tier services and the database and listener services.
Step 3: The current RDBMS top is proddb/8.1.7. Create a new RDBMS top directory:
mkdir /raid01/oratest/oracle/proddb/9.2.0
Step 4: Set the following environment variables:
ORACLE_HOME=/raid01/oratest/oracle/proddb/9.2.0
ORACLE_SID=TEST
Step 5: Ensure that any TNSLSNR variables are unset.
Step 6: If the installation was previously cancelled half-way, deinstall the installed products and/or delete the files in 9.2.0:
cd /raid01/oratest/oracle/proddb/9.2.0
rm –rf *
Step 7: When installing, use the following values:
Destination Name: TEST_920
Destination Path: /raid01/oratest/oracle/proddb/9.2.0
Begin installation.
Recent Comments