DBA in the Trenches

I'm not a big fan of creating a db link in the tnsnames.ora file because during clones you need to start messing around with custom files. My preferred method is using a bit of SQL to create the db link. Using the details from the tnsname.ora file of the target database: TEST=  (DESCRIPTION=   (ADDRESS=(PROTOCOL=tcp)(HOST=oradbtest.company.com)(PORT=1521))  (CONNECT_DATA=   (SERVICE_NAME=TEST)   (INSTANCE_NAME=TEST)   )  ) I can now create the database link as follows: create public database link TESTDBLINK connect to apps identified by apps using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradbtest.company.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)))'; Just remember you might want to not make it public and you may need to change user names and passwords to the target instance.

This is probably in a million places out there but just posting it here for my own reference and you might find it useful too. Disable Archiving SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /u04/archive/ref4data Oldest online log sequence     1 Next log sequence to archive   4 Current log sequence           4 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 8551575552 bytes Fixed Size                  2270360 bytes Variable Size            2634025832 bytes Database Buffers         5804916736 bytes Redo Buffers           ...

When checking for the latest PSU you might want to know what the current PSU is. I also keep a list of PSU updates and latest CPU updates on the Critical Patch Updates page. If the below returns nothing you are on the base level, e.g. 11.2.4.0 opatch lsinventory -bugs_fixed | egrep -i 'PSU|DATABASE PATCH SET UPDATE'  10248523 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.1 11724916 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011) 12419331 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011) 12827726 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011) 13343424 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPUJAN2012) 13696224 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPUAPR2012) Reference : Patch Set Updates for Oracle Products (Doc ID 854428.1...

During a PSU check I saw a list of patches that are recommended. I saw a list that has JVM and the DB bundled. I wasn't sure what this was and which one I should apply. After some digging around I understood that I could check whether I had JVM installed on the database although now I understand that with EBS it will probably be used by the database. This quick and dirty SQL will give you a list of components loaded into the database. One of which will be JServer JAVA Virtual Machine Release XXXXXXX. If its not there you probably don't have it installed. SQL> set pages 100 SQL> select * from all_registry_banners; BANNER -------------------------------------------------------------------------------- Oracle Database Catalog Views Release 11.2.0.4.0 - 64bit Production Oracle Database Packages and Types Release 11.2.0.4.0 - Development JServer JAVA Virtual Machine Release 11.2.0.4.0 - Development Oracle XDK Release 11.2.0.4.0 - Development Oracle Database Java Pac...

Dear Hilton Meyer, Thank you for your interest in the Oracle Public Cloud. We have now entered the preview availability phase. Over the next several months, we will be releasing capacity of our cloud in batches to early registrants. To request access and get in the queue, go to   cloud.oracle.com  and follow these two steps: Register to get your  oracle.com  account if you don't already have one Confirm the cloud service(s) you want to trial This information is required for us to activate your account for Oracle Public Cloud services when they become available. Register now at cloud.oracle.com.  On this site, you’ll also find additional background materials and an updated FAQ with more information on our preview availability phase. Start Now Stay Connected       Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Contact Us  |  Legal Notices  |  Privacy