OracleDBs.com

1) Connect to target rman target / 2) Set destination to Tape or disk: CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; 3) Run backup with TAG: (Note: Replace highlighted with actual tag and retention period) rman target / catalog rcat/pass@host:port/rcat.service RUN { show all; CONFIGURE DEFAULT DEVIC...

1. Ensure Flashback Database Is ON: SQL> SELECT FLASHBACK_ON FROM V$DATABASE; FLASHBACK_ON ------------------ YES 2. If flashback is OFF, turn it on: SQL> ALTER DATABASE FLASHBACK ON; SQL> SELECT FLASHBACK_ON FROM V$DATABASE; 3. Create a guaranteed restore point: SQL> CREATE RESTORE POINT {restore_...

Hi twitt,

The errors are usually due to usage, application or configuration issues but in some cases they may be caused by a bug issue.
Refer to OERR: ORA-6110 "NETTCP: message send failure" Reference Note (Doc ID 19930.1).

If you have metalink account, file an SR with Oracle Support.

Hi twitt,

The errors are usually due to usage, application or configuration issues but in some cases they may be caused by a bug issue.
Refer to OERR: ORA-6110 "NETTCP: message send failure" Reference Note (Doc ID 19930.1).

If you have metalink account, file an SR with Oracle Support.

After restarting the machine, we have mostly got he following error: SQL> startup ORACLE instance started. Total System Global Area ***** bytes Fixed Size ***** bytes Variable Size ***** bytes Database Buffers ***** bytes Redo Buffers ***** bytes Database mounted. ORA-00333: redo log read error bloc...

By default, Office Communicator 2007 R2 enable users to set their presence to one of the following five states: Available Busy Do Not Disturb Be Right Back Away But Administrators can provide users with another option for setting their presence: Appear Offline . When a user selects this option, he o...

To list execution history: set lines 999 set pages 999 col WINDOW_NAME for a16 col JOB_START_TIME for a40 col JOB_DURATION for a15 col JOB_STATUS for a9 col JOB_INFO for a70 SELECT WINDOW_NAME, JOB_START_TIME,JOB_DURATION,JOB_STATUS,JOB_INFO FROM DBA_AUTOTASK_JOB_HISTORY WHERE client_name ='auto opt...

1. Stop agent: $<AGENT_HOME>/bin/emctl stop agent 2. Run the following command from the Oracle home of the Management Agent: $<ORACLE_HOME>/oui/bin/runInstaller -deinstall -silent "REMOVE_HOMES={absolute_path_to_agent_oracle_home}" -removeallfiles e.g. /u01/oracle/base/product/11.2.0.3/oui...