Tags » 11g

Free Demo I: Oracle ADF 11g Training: Thursday, December 18 at 08:00 AM India Time

S&M Consultants is pleased to invite you to join the upcoming Online Session for Oracle ADF Training.

To attend the class please login at : … 23 more words

Blogs

OPatch failed with error code 73

Scenario :
=========

While running opatch lsinventory we get the following error in db Tier

Error :
======

$ opatch lsinventory

Invoking OPatch 11.1.0.6.2
Oracle Interim Patch Installer version 11.1.0.6.2… 255 more words

11g

Query to check debug option is Enabled in Profile

SELECT po.profile_option_name “NAME”,
po.USER_PROFILE_OPTION_NAME,
decode(to_char(pov.level_id),
‘10001’, ‘SITE’,
‘10002’, ‘APP’,
‘10003’, ‘RESP’,
‘10005’, ‘SERVER’,
‘10006’, ‘ORG’,
‘10004’, ‘USER’, ‘???’) “LEV”, 128 more words

11g

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered

Scenario :

Database went down due to power fluctuation and during that time hot backup was running.So once we started the database we face the following issue. 77 more words

11g

ORA-00600: internal error code, arguments: [4194]

ERROR:

======

ORA-00600: internal error code, arguments: , [#], [#], [], [], [], [], []

CAUSE:

======

This also can be cause by the following defect… 392 more words

11g

Enable Auditing for DB user login attempts in 11g

1 – Add initialization parameters & bounce instance:alter system set audit_trail=db scope=spfile;
audit_file_dest=’/u01/app/oracle/mysid/mydir/’

2 – Enable auditing of failed logion attempts :

SQL> audit create session whenever not successful; 104 more words

11g

GOLDENDATE HA MAA RAC ACFS XAG

Purpose is to demonstrate how to create HA for Bi-Directional Replication Goldengate installed on ACFS with RAC cluster using XAG.

XAG simplifies the process since there are no requirements to create action scripts. 2,337 more words

11g