Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Oracle SQL Developer 3.2 release on August 20, 2012. Regards Mahir M. Quluzade
Yesterday Yuva Kishore is commented on my Oracleasm - Instantiating disk : failed post and asked a question: We can list the asm disks (listdisks) but where can we find the mapping that ASMDISK1 is mapped to /dev/sda1 and so on?
I want answer this question with this post.
If you are using ASMLib for configure ASM Disks, then you can use following steps for define which device mapped which ASM Disk.
As you know, oracleasm listdisks is return only ASM disk names
[grid@oel62-rac1 ~]$ oracleasm listdisks
If you want find which ASM disk is mapped which device, then you must use oracleasm querydisk with ASM disk name.
[grid@oel62-rac1 ~]$ oracleasm querydisk -d ASMDISK01
Disk "ASMDISK01" Is a valid ASM disk On device[8,17]
As see you, ASMDISK01 is valid ASM disk on device [8,17].
What is means? It means ASMDISK01 is mapped to device [8,17].
How to find [8,17] device? We must use Linux ls –l c…
When you need safely remove broker-managed Data Guard Configuration then, oracle recommend following steps…
You know dg_broker_start parameter is TRUE and data guard configuration information contains in broker configuration files dg_broker_config_file1, dg_broker_config_file2 with broker-managed Data Guard Configuration.
Following steps I use on my test machines witch is running on Oracle Virtual Box. I captures video on this machines, too. Primary and Standby Database running on Oracle Linux Server 6.2 and installed Oracle Database 11g Release 2 (220.127.116.11).
DG – is my breoker-managed Data Guard configuration. admdb is primary database, stldb – is standby database.
DGMGRL> show configuration
Configuration - dg
Protection Mode: MaxPerformance
admdb - Primary database
stldb - Physical standby database
Fast-Start Failover: DISABLED
Archive log destinations like as
As you know Oracle recommends before installation Oracle Real Application Clusters 11g Release 2 run Cluster Verification utility with stage previous and post installation cluster ware or database.
Cluster verification utility help you for getting error before and after installation Oracle Grid Infrastructure and Real Application Clusters Database.
I getting following error :
[grid@oel62-rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n oel62-rac1,oel62-rac2 –verbose ….. Checking user equivalence... Check: User equivalence for user "grid" Node Name Status ------------------------------------ ------------------------ oel62-rac2 passed oel62-rac1 passed
Result: User equivalence check passed for user "grid"
Verifying node connectivity Version of exectask could not be retrieved from node "oel62-rac2"Version of exectask co…