
DBA


Oracle DB IOPS requirements
So…let’s say you’re moving your database from the antique hardware its running on (the old hardware is always relatively an antique, right?) to the newest latest greatest hardware. You’re also …
Read MoreSYNC TIME in Solaris 10 Server with Local Windows(Active Directory) NTP Server
SYNC TIME in Solaris 10 Server with Local Windows(Active Directory) NTP Server There are certain steps to configure NTP on Solaris, and it’s really easy and simple. Just follow the …
Read MoreGRT Image Duplication Fail With Status Code 191 (Database System Error 220)
Problem Duplication of GRT images from Disk to Tape fail with status 191. Job Datail stated "database system error (220)". Error Application Log: Job Detail: 4/9/2012 10:10:02 AM – Error …
Read MoreResponsibility Not Visible to user in the list of responsibilites assigned to User:
Responsibility Not Visible to user in the list of responsibilites assigned to User: Recently came to know that though the system adminstrator is given the responsibility access to users, users …
Read MoreRMAN with NETBACKUP
Installation The NetBackup client software must first be installed as the root user. (for versions 6.x and earlier you also need to install the Oracle RMAN NBU client extension …
Read MoreValidating sysadmin password in 11i/R12
Validating sysadmin password in 11i/R12 Use Following query to validate wether sysadmin password that we are using is correct or not select fnd_web_sec.validate_login(‘SYSADMIN’,'<SYSADMIN PASSWORD>’) from dual; If it returns …
Read MoreHow to change the SYSADMIN password
How to change the SYSADMIN password at E-Business Suite 11i. 1. run the apps environment. 2. cd $FND_TOP/bin 3. FNDCPASS apps/*** 0 Y system/manager USER SYSADMIN new_password Tip: Check the …
Read MoreORA-00600: internal error code, arguments: [opixrb]
ORA-00600: internal error code, arguments: [opixrb-4], [1036] ORA-00600: internal error code, arguments: [opixrb-4], [1036], [ORA-01036: illegal variable name/number ], [], [], [], [], [] According to metalink , this is …
Read MoreORA-02062: DISTRIBUTED RECOVERY RECEIVED DBID 01010101, EXPECTED DB21020
Cause The default internal name of the Oracle Database Gateway for DRDA 11.2 is 01010101 (see manual -> HS_DB_INTERNAL_NAME) whereas the TG4DB2 gateway used DB21020. Checking out the dba_2pc_pending table …
Read More