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 upgrading your storage to a new SAN or NAS.  The storage architect says, “Yep…according to this shiny marketing page on the storage vendor’s website, its…

SYNC 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 following steps For Starting NTP on Solaris:     Logon to the server using root.     Now go to /etc/inet/     Rename ntp.client to ntp.conf    …

GRT 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 bpduplicate(pid=8212) db_IMAGE() failed: database system error (220)        4/9/2012 10:10:02 AM – Error bpduplicate(pid=8212) Status = no images were successfully processed.       4/9/2012 10:10:02 AM – Error…

Responsibility 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 are not able to view the responsibilities in the list of responsibilities assigned. 1. Check if the responsibility is not end dated. 2. Run the…

RMAN 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 (add-on) as well). The NBU client and Oracle extension should both be at the same version, and no higher then the version of the media…

Validating 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 Y then Sysadmin password is correct If it returns N then sysadmin password that we are using is wrong. try to change sysadmin password using…