startupforce.wordpress.com
DBA scripts | StartupForce
https://startupforce.wordpress.com/dba-scripts
Where all the Action Is! What is in store for you? Query to find the foreign keys and their parent keys. To find Foreign key for a corresponding primary key. To view allocated, used and free space in a datafile. Query to find the failed logins. How to find a session with high archive logs. You can query v$sess io and v$session to findout the the session which is generating lot of redo. i.e. lot of block changes occuring. Get description of oracle processes. How large is the database. Col owner format a15...
startupforce.wordpress.com
Convert non-asm standalone database to RAC with ASM – 11gR2 | StartupForce
https://startupforce.wordpress.com/2013/08/21/convert-non-asm-standalone-database-to-rac-with-asm-11gr2
Where all the Action Is! What is in store for you? Convert non-asm standalone database to RAC with ASM – 11gR2. Convert non-asm standalone database to RAC with ASM – 11gR2. August 21, 2013. In this post we will see how to convert a standalone database to a RAC database with ASM. 11gR2 GI has been installed and configured. 2 Oracle homes have been installed, one is RAC aware and the other is for standalone database. A standalone database is also created. Overview of Non-RAC environment. SQL alter database...
startupforce.wordpress.com
August | 2013 | StartupForce
https://startupforce.wordpress.com/2013/08
Where all the Action Is! What is in store for you? Archive for August, 2013. What are candidate and provisioned disks in ASM. August 30, 2013. Disks that were discovered but that have not yet been assigned to a disk group have a header status of either CANDIDATE or PROVISIONED. Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement. Below are the various HEADER STATUS in the v$ASM DISK. I have taken below status from 11gR2. PROVISIONED – Disk is not par...
startupforce.wordpress.com
Configuring ASM disks using UDEV | StartupForce
https://startupforce.wordpress.com/2013/08/18/configuring-asm-disks-using-udev
Where all the Action Is! What is in store for you? Configuring ASM disks using UDEV. Configuring ASM disks using UDEV. August 18, 2013. Why are we using UDEV if ASMLib is available for working with ASM disks? 8211; UDEV rules files will be available in /etc/udev/rules.d directory. Filenames begin with two decimal digits, to sequence the rules into ascending numerical order. After a dash, filenames contain descriptive words. The filename must end with “.rules” to be recognized. Blank lines are OK. VBoxMan...
startupforce.wordpress.com
StartupForce | Where all the Action Is !!!! | Page 2
https://startupforce.wordpress.com/page/2
Where all the Action Is! What is in store for you? How does an instance registers with the listener! August 23, 2013. If you check the status of the listener, some times we will see as instance status is UNKNOWN or instance is READY…. So what are these messages? 8230;When do they appear…? Lets explore it now,. There are basically 2 ways of getting a database registered with listener. This is the first and old method of registering a database with the listener. SID LIST LISTENER bharatdb. Uptime 0 days 0 ...
startupforce.wordpress.com
What is in store for you?? | StartupForce
https://startupforce.wordpress.com/sample-page
Where all the Action Is! What is in store for you? What is in store for you? Sample data in sample page. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Follow Blog via Email.
startupforce.wordpress.com
DBA Interview Questions | StartupForce
https://startupforce.wordpress.com/dba-interview-questions
Where all the Action Is! What is in store for you? 1 What is Thread Merge Recovery. Changes from multiple instances may not be written into datafiles, so redo logs from multiple threads are merged when crash recovery happens in RAC called Thread Merge Recovery. 1) What is ASM? 2) How do we identify if we are connected to Normal Instance or ASM instance? SQL sho parameter instance type. 3) What are Diskgroup’s and Failuregroups? Failuregroups are used when using Normal/High Redundancy. They contain th...
startupforce.wordpress.com
Metalink ID’s | StartupForce
https://startupforce.wordpress.com/metalink-ids
Where all the Action Is! What is in store for you? 1296124.1 – How To Setup ASM (11.2) On An Active/Passive Cluster (Non-RAC). 1086199.1 – ASM Concepts Quick Overview. 782974.1 – How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository. 336014.1 – How To Cleanup Orphaned DataPump Jobs In DBA DATAPUMP JOBS. 942166.1 – How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation. 1377349.1 – How to Deconfigure/Reconfigure(Rebuild OCR) or Deinstall Grid Infrastructure. 438049.1 – How T...131321&...
SOCIAL ENGAGEMENT