ITPub博客

Solaris (x86 Platform) Hardware Compatibility Lists:http://www.sun.com/bigadmin/hcl/#S8http://www.chinaunix.net/bbsjh/3/12610.htmlhttp://it.dg.gd.cn/article.php/79http://www.20cn.net/ns/wz/sys/data/20020822031150.htm Network Configuration: 1. /boot/solaris/devicedb/master: check the network card 2. /etc/driver_aliases 3. /etc/hosts 4. /etc/resolv.conf            domain singnet.com     search ip     names

version: 10.1.0.2.0emcanetcahttp://localhost:5500/emhttp://lcoalhost:5562/isqlplus Oracle Enterprise Manager: http://host.domain:5500/em/ Oracle IsqlPlus Manager: http://host.domain:5560/isqlplus Oracle IsqlPlus Manager DBA : http://host.domain:5560/isqlplus/dba Oracle UltraSearch : http://host.domain:5620/ultrasearch Oracle UltraSearch Admin : http://host.domain:5620/ultrasearch/admin Oracle HTMLDB : http://host.domain:7777/pls/htmldb/htmldb Oracle Apache : http://host.do

$ORACLE_HOME/rdbms/admin/dbmslogmnrd.sql$ORACLE_HOME/rdbms/admin/dbmslogmnr.sql$ORACLE_HOME/rdbms/admin/prvtlogmnr.plbOracle 8.1.6$ORACLE_HOME/rdbms/admin/dbmslmd.sql $ORACLE_HOME/rdbms/admin/dbmslm.sql $ORACLE_HOME/rdbms/admin/prvtlm.plbsys: exec dbms_logmnr_d.build(dictionary_filename => 'dictionary.ora', dictionary_location => '/data/oracle/logmnr'); exec dbms_logmnr.add_logfile(logfilename => '/data/oracle/archive/archiving_1_000026.dbf', options => dbms_logmnr.new); exec

SQL> CREATE DIRECTORY log_dir AS '/appl/gl/log'; SQL> GRANT READ ON DIRECTORY log_dir TO DBA; [@more@]

oemctl start  oms               dbsnmpagentctl start agentconsider the  personal  firewall. [@more@]

$ORACLE_HOME/sqlplus/admin/glogin.sqldefine _editor=vi -- can set as notepad, emacs ...set serverouput on size 1000000 -- set the default buffer size as long as possiblecall dbms_java.set_output(1000000); -- redirects the Java ssytem.out to sqlplus session dbms.output bufferset trimspool onset sqlblankline onset long 5000 -- number of bytes displayed when selecting the LONG or CLOB columnsset linesize 300 pagesize 9999column plan_plus_exp format a80 -- width of the explain plan outputcolumn gl

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

http://mirrors.cn99.com/solaris/x86/ [@more@]

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@]

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@]

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 !! This is the first post for my blog ... ;)[@more@]