-
编辑 删除
Alter Sequence
The sequences that need to reset the start number to 0 at the first day of new year. create sequence: CREATE SEQUENCE SEQ_APP_NUMBER INCREMENT BY 1 START WITH 1 MINVALUE 0 MAXVALUE 99999 NOCYCLE NOCACHE ORDER; set_sequence.sql DECLARE Handle Integer; SqlText varchar2(2000); NewNextVal Integer; NewCurrVal Integer; CURSOR cursor_seq_names IS SELECT sequence_name,(last_number * (-1) + increment_by + min_value) last_number,increment_by FROM user_s
-
编辑 删除
Download Solaris 9 x86
http://mirrors.cn99.com/solaris/x86/ [@more@]
-
编辑 删除
ORA-12541: TNS:no listener
App developer report that Ora-12541 appear. On clinet side, sqlplus can connect to all the instances, can all database link not works. Suspect that the listener.ora had been modified. Action: use localhost instead the ip address, the issue solved. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) This is the workaround only, will follow up for root cause. [@more@]
-
编辑 删除
def$_aqcall on Advanced Replication Environment
System tablespace is increased to almost 100% of storage, after check the dba_segments view, find that the size of table def$_aqcall is 80MB+.1. Terminate the current push operations and prevent them from re-running.2. Stop remote sites from replicating to the local site.3. truncate table system.def$_aqcall;note: 190885.1@metalink[@more@]
-
编辑 删除
OPatch
1. where to get the OPatch patch number: 2617419 note: 224346.1 189489.1@metalink2. How to install OPatch 1) Download the zipfile from metalink 2) Unzip the zipfile to a temp location, eg. '$HOME/tmp/opatch1.50' 3) After unzippping, a directiory called 'OPatch' and a file called 'README.txt' is created. 4) Copy the directory 'OPatch' and its contents to the concerned Oracle Home3. OPatch command opatch lsinventory opatch rollback -ed bug_number opatch query -is_roll
-
编辑 删除
Merry Christmas !!
Merry Christmas !! This is the first post for my blog ... ;)[@more@]
