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