Search
Tag Cloud
10.2 10.2.0.5 11.1 11.2 ADR alertlog ASM bug bundle patch cleanupDeploy database database appliance digest diskgroup enterprise manager gi grid control grid infrastructure GrindInst hashes LinkedIn listener localhost monitoring oak oakcli ODA odachk OEM one-off ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC REDO sha1 solaris troubleshooting usable_file_mb x-windws xtermCategories
-
Recent Posts
Blogroll
Tag Archives: LinkedIn
ORA-00245: control file backup operation failed
A snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. As of Oracle 11.2 (11.2.0.2 to more precise) the snapshot controlfile must be on a location shared by all … Continue reading
Posted in RAC
Tagged 11.2, 11.2.0.2.0, alertlog, database, database appliance, LinkedIn, ODA, ORA, oracle, RAC, troubleshooting
1 Comment
Oracle Database Appliance – Installing patch 2.1.0.1.0
Just recently (31 December 2012) the first Patch Bundle (MOS patch name 13539664 – LNX64-112-CMT: PLACE HOLDER BUG FOR OAK PATCH 2.1.0.1.0) for the ODA was released. This Patch Bundle only contains firmware updates for the shared disks (HDD) and … Continue reading
Posted in Database Appliance
Tagged cluster resources, database, firmware, gi, grid infrastructure, LinkedIn, oak, oakcli, ODA, oracle, oracle database appliance, patch bundle, RAC
Leave a comment
Oracle Database Appliance – Inventory and Package Repostitory
An Oracle Database Appliance has its own inventory to keep track of all installed firmware and software component versions and patches. ODA patches are released in the form of patch bundles. ODA patch bundles can contain patches for: System Firmware … Continue reading
Posted in Database Appliance
Tagged database appliance, LinkedIn, oak, oakcli, oracle, oracle database appliance
Leave a comment
Oracle Database Appliance – Appliance Manager
The Oracle Database Appliance is sold to allow customers to quickly deploy and Oracle RAC environment using Oracle’s best practices for deployment. And it is true that in less than 2 hours (thats excluding all things that needs to be … Continue reading
Oracle Database Appliance – Deployment Steps
The installation (deployment) of an Oracle Database Appliance (ODA) is done by the ODA configuration manager. After you filled out all the information in the various screens (or you have loaded a parameter file and clicked next on all the … Continue reading
Posted in Database Appliance
Tagged 11.2, ASM, database appliance, grid infrastructure, LinkedIn, oak, oakcli, ODA, oracle, oracle database appliance, RAC
9 Comments
Where does SQL*Plus look for configuation files on Solaris
This post will show you the order in which SQL*Plus for Solaris reads the configuration files like the tnsnames.ora. tnsnames.ora $HOME/.tnsnames.ora $TNS_ADMIN/tnsnames.ora /var/opt/oracle/tnsnames.ora $ORACLE_HOME/network/admin/tnsnames.ora If the specified alias is not found in (or the file does not exists) in $HOME/.tnsnames.ora … Continue reading
Solaris SMF Oracle Grid agent service killing Oracle instance
In the last couple of months we had some strange problems with all processes of Oracle database and ASM instances just disappearing. The shared memory segment was still there and you could connect internally to the instance, even execute some … Continue reading
Posted in Enterprise Manager
Tagged contract, database, enterprise manager, grid control, LinkedIn, OEM, oracle, service, SMF, solaris, troubleshooting
Leave a comment
Creating database links for another schema
There are situations (like after cloning databases) where you, as a DBA, want to create database links in other schema’s, for which you don’t have the password. Unfortunately the security of Oracle doesn’t allow (even SYS) you to drop/create database … Continue reading
Posted in Database
Tagged database, DBMS_IJOB, DBMS_SYS_SQL, LinkedIn, ORA-01031, oracle, PLSQL, privileges, run_sql_as
4 Comments
Password History – Reusing a password
By setting either one or both the profile limits PASSWORD_REUSE_MAX or PASSWORD_REUSE_TIME are set to anything other than UNLIMITED, Oracle somewhere keeps a history of passwords used by a user. This password history is stored in a table with the … Continue reading