-
编辑 删除
Stream objects
Streams配置和管理相关packagedbms_steams_admdbms_capture_admdbms_propagation_admdbms_apply_admdbms_rule_admStreams主要相关数据字典dba_streams_administratordba_capturedba_capture_parametersdba_prop...
-
编辑 删除
2 listeners are serving for 1 instance .
1, netca .2, vi /home/oracle/OraBase/OraHome1/network/admin/tnsnames.oraLISTENERS_MAMBO = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hzdevdb1.mambo....
-
编辑 删除
ORA-27102: out of memory
Causeshmall is the total amount of shared memory, in pages, that the system can use at one time. SolutionSet shmall equal to the sum of all the SGAs on the system, divided by the...
-
编辑 删除
Stream alter parameter
AQ_TM_PROCESSESProperty DescriptionParameter type IntegerDefault value 0Modifiable ALTER SYSTEMRange of values 0 to 10Basic NoAQ_TM_PROCESSES enables time monitoring of queue messages. The tim...
-
编辑 删除
ORA-27054
Solution1) The problem can be solved by using the recommended mounting options which are: (hard,bg,proto=tcp,suid,rsize=32768,wsize=32768,noac)* Note that this list of options is not exhaustive, a...
-
编辑 删除
ORA-27086: unable to lock file - already in use
ORA-00202: control file: '/home/oracle/OraBase/cfgdata/CFGDB/controlfile/o1_mf_4pxvrjq1_.ctl'ORA-27086: unable to lock file - already in useLinux-x86_64 Error: 11: Resource temporarily unavailablesto...
-
编辑 删除
audit session
SQL> audit session by a,b by access whenever successful;Audit succeeded.SQL> CREATE PUBLIC SYNONYM audit4ab FOR SYS.DBA_AUDIT_SESSION;Synonym created.
-
编辑 删除
Dell OpenManage Server
# rpm -ivh net-snmp-5.1.2-11.EL4.11.x86_64.rpm#tar -zxvf OM_5.5.0_ManNode_A00.tar.gz #cd linux/supportscripts/#./srvadmin-install.sh --express#./srvadmin-services.sh starthttps://10.224.188.29:...
-
编辑 删除
ORA-00257: archiver error. Connect internal only, until freed
SQL> select * from v$flash_recovery_area_usage;FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------ ------------------ ------------------------- ------...
-
编辑 删除
Install EMGC 102050
$vi /home/oracle/mambos/102010/response/em_with_new_db.rspUNIX_GROUP_NAME="oinstall" &n...
-
编辑 删除
EMGC Tips
102050/3731593/Disk1/stage/shiphomeproperties.xml <?xml version="1.0" standalone="yes" ?><ORACLEHOME_INFO> <ARU_PLATFORM_INFO> &...
-
编辑 删除
BMR
blockrecover datafile 7 block 1234;blockrecover datafile 7 block 1234 datafile 17 block 12345;
-
编辑 删除
tar linux
Ø mount 10.224.188.188:/vol/tribox /mnt/cdromØ cd /Ø tar –czplvf /mnt/cdrom/tribox.tgz . boot
-
编辑 删除
Recovery from Complete Loss (No Controlfile)
$export ORACLE_SID=webdbSQL>startup force nomountRMAN>restore spfile from autobackup;RMAN>shutdown immediate;RMAN>startup nomount;RMAN>restore controlfile from autobackup;RMAN>alter database mou...
-
编辑 删除
Incrementally Updated Backups
RMAN> configure DEVICE TYPE DISK BACKUP TYPE TO copy ;RMAN> backup incremental level 0 tag 'IUB' database;RMAN> backup incremental level 1 for recover of copy tag 'IUB' database;-rw-r----- 1 ...
-
编辑 删除
OCP ?
2009-02-17 98% pass 1Z0-0422009-02-19 100% pass 1Z0-0072009-02-22 96% pass 1Z0-043OCP?不带劲!
-
编辑 删除
Grant general user login EM
SQL> grant select_catalog_role to scott;
-
编辑 删除
手工 RAC Archive , flashback
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+WEBLOG/' SCOPE=SPFILE SID='*';ORALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' SCOPE=SPFILE SID='*';ALTER SYSTEM SET CLUSTER_D...
-
编辑 删除
TTS (PT)
Before: PT_Table:EMPP1_Tablespace:PTS1P2_Tablespace:PTS2 After: PT_Table:EMPP1_Tablespace:PTS1P2_Tablespace:PTS2 PTS1 TTS to NewDB. Action: create ...
-
编辑 删除
LogMiner
execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_4_4qmyvk67_.arc',dbms_logmnr.new);execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_3_4qmyq1bl_.arc',dbms_logmnr.addfile);execute DBMS_LOGMNR.ADD_LOGFILE ('/....
