Tech Support & Travel

Successfully onlined Undo Tablespace 1. Wed Jul 15 09:07:50 2009 SMON: enabling tx recovery Wed Jul 15 09:07:50 2009 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OP…

Save procedure code in a file called cbt_trig1.sql then wrap using the following command e:\raj\YKR_SQL>wrap iname=cbt_trig1.sql PL/SQL Wrapper: Release 10.1.0.2.0- Production on Fri Aug 07 16:58:27 2009 Copyright (c) 1993, 2004…

lab2>select name,value from v$parameter where name like '%distri%';   NAME                                                    VALUE distributed_lock_timeout             60 lab2>alter system set distributed_l…

select trunc(trans_date),count(1) from htd_bill_master group by trunc(trans_date) order by trunc(trans_date); select trunc(trans_date),count(1) from htd_bill_master * ERROR at line 1: ORA-12801: error signaled in pa…

While using OUI it fails with following message, OUI-10020:The target area /oracle/10gR2/oraInventory is being used by another session. A write lock cannot be obtained. Action   Cause of The Problem There is some process or so…

$ sqlplus "/as sysdba"   SQL*Plus: Release 9.2.0.8.0 - Production on Fri Aug 14 17:05:02 2009   Copyright (c) 1982, 2002, Oracle Corporation.   All rights reserved.   ERROR: ORA-09925: Unable to creat…

Alert log contains ORA-01501: CREATE DATABASE failed ORA-01991: invalid password file '/orahome/oracle/product/9.2.0/dbs/orapw' $ cd $ORACLE_HOME/dbs $ orapwd file=orapw password=sys

one of the file system may be 100% full check df -h

[oracle@billdesk bdump]$ tail -f alert_apcell1.log ORA-07445: exception encountered: core dump [kghalf()+364] [SIGSEGV] [Address not mapped to object] [0x17BC] [] [] Thu Oct 22 10:50:49 2009 Errors in file /apps/app/oracle/admin/…

1)         checked alert log and found   Mon Oct 26 14:33:42 2009 ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST= rhel4.localdomain   # )(PORT=1521))' 1)         to change hostname   /etc/…