Showing posts from May, 2015
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/…
