Database:
+Cross platform migration from windows to linux of oracle database
+Restricting TOAD,PLSQL,EXCEL,SQL access from ORACLE App Schema who has DBA Priv
+Create Duplicate role as like DBA role
+SQLPLUS hangs from client server
+ Refresh of PROD database using RMAN duplicate
+Drop database for RAC and NON RAC
+Installing latest version of OPatch
+ORA-12543 due to iptables server firewall.
+Rman backup falis with RMAN-00601 fatal error in recovery manager
+INS-30060 while installing oracle database software
+PRKC-1140 while installing oracle database software
+How to reset the same password for oracle user
+RMAN Backup fails with DBGSQL: TARGET - RMAN-03014 ORA-01008 sqlcode = 1008
+Patch error with genclntsh: Failed to link libclntsh.so.11.1
+OPatch error with wrong stage patch location UtilSession failed: Invalid patch location
+OPatch error with ibclntsh.so.11.1 executables are active
+OPatch warring with ins_precomp.mk overriding commands for target `pcscfg.cfg'
+OPatch warring with ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'
+ To calulation ORACLE data guard / standby Bandwidth.
+ Archive log not shiping to standby or datagaurd error ORA 03135 ORA 12152 ORA-16198 ORA-12152 ORA-12592
+Oracle database 12C Documentation reference
+To finding ITL wait hot block objects to increace initrans
+Mlog refresh status and Mlog segment space details
+RAC database installation INFO: PRVF-9652 : Cluster Time Synchronization Services check failed
+FAL[server]: DGID from FAL client not in Data Guard configuration
+v$archive_dest shows BAD PARAM in status column
+PLSQL developer - Initialization error SQL*Net not properly installed OracleHomeKey: OracleHomeDir
+To know the status of sub partition indexes- all_ind_subpartitions status UNUSABLE or N/A in dba_indexes
+ORA-04030: out of process memory when trying to allocate 4032 bytes
+Error RMAN-03002 RMAN-05501 RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed - when using restoring RMAN auxiliary Duplicate db
+ORA-25153: Temporary Tablespace is Empty
+Oracle flashback logs not being deleted
+Recovery Writer (RVWR) is stuck until more space - DR database is not sync error with
+Changing Temp tablespace Location to new RAC ASM disk group
+Changing archive log location LOG_ARCHIVE_DEST_1 and db_recovery_file_dest to the new ASM disk Group
+ORA-01261: Parameter db_create_file_dest destination string cannot be translated
+ORA-13518 Invalid database id ORA-06512 at SYS.DBMS_WORKLOAD_REPOSITORY - dbms_workload_repository.create_snapshot
+Drop and Reinstall AWR
+WRI$_OPTSTAT_HISTHEAD_HISTORY and WRI$_OPTSTAT_HISTGRM_HISTORY are not purged.
+RMAN-03009 ORA-19504 ORA-27040 ORA-27040: file create error, unable to create file
+Clearing Dead-marked for killing session in Oracle
+dbms_stats.gather_table_stats ORA-20000: Unable to analyze TABLE
+PRVF-7532 Package pdksh is missing on node - 11204 installation in RHEL6
+ Oracle - Clean the objects inside the schema for refresh using Import(Impdp).
+Standby logs not applying with warning: Waiting for all non-current ORLs to be archived... Media Recovery Waiting for thread 1 sequence
+How to sync oracle data guard DR with missing archive log in PROD and DR
+Error: ORA-00317: file type 0 in header is not log file ORA-00334
+Oracle 11.2.0.4 installation-Package pdksh-5.2.14 - This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system.
+Setting HugePages for Oracle linux
+PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared
+RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
+ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified ORA-17629: Cannot connect to the remote database server
+RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
+Migrating oracle Database using RMAN Active Database Duplication from Old dataguard standby server to New dataguard standby server without touching PROD.
+Primary database alertlog giving below error(TNS-12564) for DGMGRL data guard services DBSID_DGB.
+ORA-17503: ksfdopn:2 Failed to open file ORA-15173: entry 'dr1DBSID.dat' does not exist in directory 'brokerfile'
+ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim
+Oracle Connection error : Provider cannot be found.It may not be properly installed
+backup controlfile for standby error with RMAN-03009 ORA-01671: control file is a backup, cannot make a standby control file
+ORA-12801: error signaled in parallel query server ORA-01114 ORA-01114 ORA-29701
+Oracle Data Guard config ORA-16057: server not in Data Guard configuration
+SHUTDOWN: Active processes prevent shutdown operation
+Duplicate database fail with RMAN-04014 ORA-01127: database name '/SIDDEVLOP' exceeds size limit of 8 characters
+PRVF-0002:Could not retrieve local hostname
+Moving datafile form NON ASM to ASM
+ORA-00600 on ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
+Adding multiple oracle datagaurd standby database
+drop logfile group ORA-01624: log 1 needed for crash recovery of instance ORA-00312
+ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetChildNo,qmemNextBuf:alloc)
+TNS-12545 TNS-12560 TNS-00515 Linux Error: 99: Cannot assign requested address
+RHEL 7 : PRVF-7532 : Package "compat-libstdc++-33(x86_64)" is missing on node
+PRVF-0002: could not retrieve local node name
+ORA-00214: control file version inconsistent with file
+ORA-00334 ORA-00353 ORA-00283 ORA-00354: corrupt redo log block header
+oracle runInstaller bash: xclock: command not found...
+IMPDP table import ORA-31693 ORA-29913 ORA-29400 ORA-26059
+ORA-38706 ORA-38788 ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
+alter database backup controlfile ORA-01110 ORA-01187 cannot read from file because it failed verification tests
+DBUA : InitParamAttributes.loadInitParams java.util.NoSuchElementException java.util.StringTokenizer
+TNS-12542: TNS:address already in use TNS-12560 TNS-00512 Linux Error: 98: Address already in use
Monitoring Scripting:
+Tablespace Monitoring and altering through mail when reaches 90%
+Oracle Data guard log gap status monitoring shell script and alerting through mail
+Oracle Alert log monitoring shell script and alerting through mail
+Oracle ASM Disk Group free space/used space monitoring shell script and alerting through mail
+Oracle RMAN Backup job monitoring shell script and alerting through mail
+Oracle User expiry monitoring shell script and alerting through mail
+Oracle Database Lock details status monitoring shell script and alerting through mail
+ORA 12514 Data guard is not in sync with primary
Performance:
+Unix top CPU and Memory
+Sequence to analysis database level performance
+Object which are all accessed and locked
+Tuning BO report of FCUBS which is taking more than 30mins
+Oracle database is hanging or slow in night due to Auto job
+How to disable DEFAULT_MAINTENANCE_PLAN from DBA_SCHEDULER_WINDOWS
+How to make status column to False in DBA_SCHEDULER_WINDOWS
+Oracle to find over sized(fragmented) index whos size is greater than tablesize
+Wait Event:db file sequential reads
+Wait Event: db file scattered reads
+Wait Event: log file parallel write
+Wait Event: log file sync
+Wait Event: buffer busy waits
+Wait Event: free buffer waits
+Wait Event: enqueue waits
+Wait Event: Direct Path Writes
+Wait Event: Latch Free Waits
+Wait Event: Library cache latch
+Wait Event: Shared pool latch
+Wait Event: Row cache objects latch
+ORACLE RAC Performance reference
+ optimizer_skip_scan_enabled performance issue and wrong stats in explain plan
+Oracle database I/O performance issue
GRID/RAC/ASM:
+Deinstall oracle Grid standalone installation after failed instal
+OS Kernal upgrade on RAC ASM system
+PRVF-5184 : check of following Udev attributes
+PRVF-4661 : Found inconsistent hosts entry in /etc/nsswitch.conf
+Rac GRID instal hangs at oracle.cluster.deployment.ractrans.ClientHandlerSupervisor.threadCleanup
+ntcontab.o - Error in Grid control agent instal
+INS 40912 - Rac Grid installation fail with
++11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Node-2 root.sh fails with CRS-2674
+ASM terminated ORA-00020: maximum number of processes 100 exceeded
+Adding ASM disk group in VM lab
+enq: DD - contention while adding ASM disk and ASM command hangs
+RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O
+oracleasm createdisk marking disk FAILED with Unable to open device Device or resource busy
+ocrcheck PROC-26: Error while accessing the physical storage
+11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Moving UNDO tablespace to NEW ASM diskgroup in RAC
+Multiplexing control file in ASM
+Changing Redo Log to new disk group in ASM RAC
+Moving RAC database from one disk group to other new ASM disk group
+ORA-15032: not all alterations performed ORA-15063: ASM discovered an insufficient number of disks for diskgroup
APPS DBA: +OS Kernal upgrade on RAC ASM system
+PRVF-5184 : check of following Udev attributes
+PRVF-4661 : Found inconsistent hosts entry in /etc/nsswitch.conf
+Rac GRID instal hangs at oracle.cluster.deployment.ractrans.ClientHandlerSupervisor.threadCleanup
+ntcontab.o - Error in Grid control agent instal
+INS 40912 - Rac Grid installation fail with
++11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Node-2 root.sh fails with CRS-2674
+ASM terminated ORA-00020: maximum number of processes 100 exceeded
+Adding ASM disk group in VM lab
+enq: DD - contention while adding ASM disk and ASM command hangs
+RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O
+oracleasm createdisk marking disk FAILED with Unable to open device Device or resource busy
+ocrcheck PROC-26: Error while accessing the physical storage
+11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Moving UNDO tablespace to NEW ASM diskgroup in RAC
+Moving RAC database from one disk group to other new ASM disk group
+ORA-15032: not all alterations performed ORA-15063: ASM discovered an insufficient number of disks for diskgroup
+Oracle Apps dba R12 installation(12.1.1) and database 11.1.0.7
+Oracle apps fresh installation 12.1.1 and upgrade to 12.1.3
+Rapid Install found an already existing /tmp/RapidInstall
+Apps WorkFlow Too many pending requests already exist in the system
+R12 login fails with FND_NO_DATABASE_CONNECTION
+ Oracle Apps ADPATCH interview question and common information's
+ Oracle Apps CONCURRENT MANAGERS basics and information's
+Oracle Apps concurrent managers interview question and common information's
+Oracle Apps 11i and R12 Apps Password
+Manual cloning of appsTier and db tier with out Rapid cloning adcfgclone.pl
+Updating Test Mail ID override address for Workflow Notification Mailer in backend in R12
+
+Oracle apps Work Flow mailer inbound response - Unable to connect to the mail account. Check the host, user name and password
+R12 Application font, colour, feel and looks different after applying patch
+oracle apps password reset: Too many pending request already exist in the system. Please check your email or contact the system administrator for further assistance.
+RW-50010 Error script has returned an error: 127 RW-50004 Error code received when running external process
+Oracle Apps Information Centers most of useful matalink note
+admerge patch usage
+AutoPatch error: The following ORACLE error: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
+How to invoke admsi.pl before applying patch.
+Checking adpatch worker status using adctrl
+adpatch - An error occurred while generating Oracle Forms library files. Continue as if it were successful
+adpatch FND_INSTALL_PROCESSES table - ORA-00955: name is already used by an existing object
+Oracle apps How to find the adpatch is applied or not
+In the mid of main adpatch you got error for applying pre patch,So How to apply the pre_patch
+oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition of type View Definition not found
+adhoc approver in HRMS Errors- oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.addApprover
+adpreclone.pl - java.io.FileNotFoundException: /appsutil/clone/jlib/oui/jlib/Libraries.old
+RC-50014: Fatal: Execution of AutoConfig was failed - java.sql.SQLException: Could not get connection to the database
+RC-50004 AC-00005 No write permissions for creating the Context file /appsutil/temp.xml - perl adcfgclone.pl dbTier
+SYSADMIN Error Login failed. Please verify your login information or contact the system administrator.
+Oracle apps R12 : Login Page is blank
No comments:
Post a Comment