It was exciting when my instructor, Gordon Reade at Sundance Flying Club stepped out after signing my logbook to solo and wished me luck before I taxi and took off from Runway 31. After the tower granted me clearance to take off, I lined up and used full throttle to rotate (Vr) at about 55kts in the Cessna 172SP aircraft (837SP) to complete my first solo flight of three takeoffs and landings in the traffic pattern over the bay at KPAO airport. It was fun and best of all I was relaxed and confident in my newly acquired skills. All three landings were smooth on touchdown and my instructor congratulated me on a solo flight well done. Now I look forward to completing my cross country flights and passing my checkride to receive my private pilot license!
Friday, April 12, 2013
First solo flight and my quest to become a private pilot for fun!
This year I started my journey to accomplish a childhood dream of earning my private pilot license to have the freedom and skill to fly aircraft in my free time. This past week I completed my first solo flight successfully at KPAO airport in Palo Alto!
It was exciting when my instructor, Gordon Reade at Sundance Flying Club stepped out after signing my logbook to solo and wished me luck before I taxi and took off from Runway 31. After the tower granted me clearance to take off, I lined up and used full throttle to rotate (Vr) at about 55kts in the Cessna 172SP aircraft (837SP) to complete my first solo flight of three takeoffs and landings in the traffic pattern over the bay at KPAO airport. It was fun and best of all I was relaxed and confident in my newly acquired skills. All three landings were smooth on touchdown and my instructor congratulated me on a solo flight well done. Now I look forward to completing my cross country flights and passing my checkride to receive my private pilot license!
It was exciting when my instructor, Gordon Reade at Sundance Flying Club stepped out after signing my logbook to solo and wished me luck before I taxi and took off from Runway 31. After the tower granted me clearance to take off, I lined up and used full throttle to rotate (Vr) at about 55kts in the Cessna 172SP aircraft (837SP) to complete my first solo flight of three takeoffs and landings in the traffic pattern over the bay at KPAO airport. It was fun and best of all I was relaxed and confident in my newly acquired skills. All three landings were smooth on touchdown and my instructor congratulated me on a solo flight well done. Now I look forward to completing my cross country flights and passing my checkride to receive my private pilot license!
NoCOUG Events for April and May 2013
As the new conference director for the Northern California Oracle User Group (NoCOUG), we have many exciting events planned for the Oracle user community.
Next week, on April 16th we have a meetup for cloud computing with Oracle technology at the Hacker Dojo in Mountain View, CA:
http://www.meetup.com/Northern-California-Oracle-Users-Group/events/112651522/?a=me1_grp&rv=me1&_af_eid=112651522&_af=event
In May, we have the NoCOUG spring/summer conference planned with events for Big Data and Oracle technology.
http://www.technicalconferencesolutions.com/pls/caat/caat_abstract_reports.schedule?conference_id=124
To attend this exciting conference you may sign up below and RSVP:
http://www.nocoug.org/rsvp.html
So if you are in northern California please come learn the latest greatest things about all things Oracle.
Friday, December 28, 2012
End of 2012
Year in review
As we end 2012, in closing I have not posted much due to work and many activities wrapping up the year. My new Oracle R12 EBS book is available and ready for folks to learn the tips and tricks for Oracle R12 Financials from Oracle Press. Each year I pursue a new goal and try to master or improve a skill or ability. This keeps me sharp and motivated and happy. Last year, I learned to scuba dive. Right now, I am learning to fly! My goal by 2013 is to pass my checkride and obtain my private pilot license. I have always had a passion for aviation and aeronautics. I am doing this purely as a hobby and do not want to be a professional pilot. For one, the pay is quite low until one has a decade of experience and two, I like working in technology as a job better than to fly planes for a living. I also will be focused on bring new events to the NoCOUG Oracle User Group in the bay area and northern California for Oracle users who want to learn new developments in database technology from Oracle. Happy Holidays and best wishes to all for a safe, peaceful and prosperous 2013!
Cheers,
Ben
Monday, April 2, 2012
Quick tip: Cloning Oracle 11gR2 RAC node in Oracle VM 3.0.3
Oracle VM 3.0.3 Server and Manager provide you with the ability to clone virtual machines quickly and easily. However, as of yet, there is not live hot clone facility available. The Oracle RAC VM must be powered off before you perform the clone operation.
There are two options available for cloning within Oracle VM: simple clone and advanced clone. Simple clone takes a quick snapshot of the VM to be copied to the new clone. Advanced provides you with the ability to create a custom clone process based on a menu driven GUI that you can create based on your requirements for cloning VM images.
There are two options available for cloning within Oracle VM: simple clone and advanced clone. Simple clone takes a quick snapshot of the VM to be copied to the new clone. Advanced provides you with the ability to create a custom clone process based on a menu driven GUI that you can create based on your requirements for cloning VM images.
Thursday, March 29, 2012
Upgrading Oracle VM 3.0.3 to latest patchset
Recently I had to upgrade an older version of Oracle VM 3.0 to the latest patch version to resolve some bugs in the initial releases of OVM 3.0. Below are the steps that I followed to perform the upgrade.
1. Download the patchset from Oracle Support (http://support.oracle.com)
2. Unzip the patch to the OVM Manager /tmp directory
3. backup config files for OVM Manager:
. Back up/copy the Oracle VM Manager configuration file located at:
# /u01/app/oracle/ovm-manager-3/.config
4. Mount the ISO image for the upgrade:
# mount -o loop V29654-01.iso /mnt
# cd /mnt
# ls
components runUpgrader.sh upgrade
#
Upgrade OVM 3.x to OVM 3.0.3:
# ./runUpgrader.sh
Oracle VM Manager 3.0.3.126 upgrade util
Oracle VM Manager is running ...
Verifying installation status ...
Read Oracle VM Manager config file ...
Skipping database upgrade for the same product version (3.0.3 to 3.0.3)
Found Oracle VM Manager install files ...
Found Oracle VM Manager upgrader ...
Found Oracle WebLogic Server ...
Found Java ...
Using the following information :
Database Host : localhost
Database SID : XE
Database LSNR : 1521
Oracle VM Schema : ovs
Oracle VM Manager UUID : 0004fb00000100004bd6b7c313170105
Current Build ID : 3.0.3.126
Using /tmp/workdir.hcUHL29831 for backup and export location.
Using /tmp/patchdir.Rvea29832 for patching.
Undeploying previous version of Oracle VM Manager application ...
Undeploying Oracle VM Manager help ...
Note: make sure that OVM Manager is up and running during the upgrade!
Once completed, the version should look like this:
In my next series of posts for OVM 3.0.3, I will discuss how to deploy Oracle 11gR2 RAC environment as well as use the new features for OVM 3.0.3 such as live migration and converting P2V- physical to virtual as well as managing an OVM 3.x environment.
1. Download the patchset from Oracle Support (http://support.oracle.com)
2. Unzip the patch to the OVM Manager /tmp directory
3. backup config files for OVM Manager:
. Back up/copy the Oracle VM Manager configuration file located at:
# /u01/app/oracle/ovm-manager-3/.config
4. Mount the ISO image for the upgrade:
# mount -o loop V29654-01.iso /mnt
# cd /mnt
# ls
components runUpgrader.sh upgrade
#
Upgrade OVM 3.x to OVM 3.0.3:
# ./runUpgrader.sh
Oracle VM Manager 3.0.3.126 upgrade util
Oracle VM Manager is running ...
Verifying installation status ...
Read Oracle VM Manager config file ...
Skipping database upgrade for the same product version (3.0.3 to 3.0.3)
Found Oracle VM Manager install files ...
Found Oracle VM Manager upgrader ...
Found Oracle WebLogic Server ...
Found Java ...
Using the following information :
Database Host : localhost
Database SID : XE
Database LSNR : 1521
Oracle VM Schema : ovs
Oracle VM Manager UUID : 0004fb00000100004bd6b7c313170105
Current Build ID : 3.0.3.126
Using /tmp/workdir.hcUHL29831 for backup and export location.
Using /tmp/patchdir.Rvea29832 for patching.
Undeploying previous version of Oracle VM Manager application ...
Undeploying Oracle VM Manager help ...
Note: make sure that OVM Manager is up and running during the upgrade!
Once completed, the version should look like this:
In my next series of posts for OVM 3.0.3, I will discuss how to deploy Oracle 11gR2 RAC environment as well as use the new features for OVM 3.0.3 such as live migration and converting P2V- physical to virtual as well as managing an OVM 3.x environment.
Uploading templates for OVM 3.0.3 to ftp server
Dear readers,
Its been a while since I've blogged due to many busy demands between work, finishing a new Oracle book and scuba diving. Recently, I setup a new Oracle VM 3.0.3 environment and the interface and tools have changed quite a bit since I last worked with OVM 2.2 version. One challenge is that now in OVM 3.0.3 you have to upload the VM templates via a web http or ftp server and no longer can you copy the Oracle VM templates over to the /OVS/seed_pool directory on the OVM server. In my case, I hit a wall of frustration trying to import a template for OVM 3.0.3 via a Windows FTP server. The solution for importing Oracle VM 3.0.3 templates into OVM manager is to use the following ftp string:
ftp://domainname%5Cusername:password@url-path
in our case we have:
ftp://oraben%5Coracle:mypassword@winftpserver.benoracle.com/V25331-01.zip
In my experience, OVM Manager prefers that you use the root base directory of the ftp server.
Otherwise you will have server access denied errors and the template import operation will fail.
Once you have imported the template into OVM 3.0.3 you will see a screen similar to the following:
Hope this helps. Stay tuned for a continuation of my series on tips and tricks for Oracle VM 3.0.3
Its been a while since I've blogged due to many busy demands between work, finishing a new Oracle book and scuba diving. Recently, I setup a new Oracle VM 3.0.3 environment and the interface and tools have changed quite a bit since I last worked with OVM 2.2 version. One challenge is that now in OVM 3.0.3 you have to upload the VM templates via a web http or ftp server and no longer can you copy the Oracle VM templates over to the /OVS/seed_pool directory on the OVM server. In my case, I hit a wall of frustration trying to import a template for OVM 3.0.3 via a Windows FTP server. The solution for importing Oracle VM 3.0.3 templates into OVM manager is to use the following ftp string:
ftp://domainname%5Cusername:password@url-path
in our case we have:
ftp://oraben%5Coracle:mypassword@winftpserver.benoracle.com/V25331-01.zip
In my experience, OVM Manager prefers that you use the root base directory of the ftp server.
Otherwise you will have server access denied errors and the template import operation will fail.
Once you have imported the template into OVM 3.0.3 you will see a screen similar to the following:
Hope this helps. Stay tuned for a continuation of my series on tips and tricks for Oracle VM 3.0.3
Monday, November 28, 2011
How to fix archive stuck error with Oracle 11gR2
Recently, I encountered an issue with Oracle R12 EBS environment unable to login to database tier with APPS schema with our Oracle 11gR2 database tier.
ORA-00257: archiver error. Connect internal only, until freed.
Sure enough, upon examination of the ADRCI alert.log entries, I found this:
* 2011-10-27 16:24:51.990 4265 krsh.c
ARC1: Error 19809 Creating archive log file to '+FRA'
*** 2011-10-27 16:24:51.990 2864 krsi.c
krsi_dst_fail: dest:1 err:19809 force:0 blast:1
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
DDE: Problem Key 'ORA 312' was flood controlled (0x5) (no incident)
ORA-00312: online log 2 thread 3: '+DATA/vis/onlinelog/group_2.259.743840813'
ORA-00312: online log 2 thread 3: '+FRA/vis/onlinelog/group_2.259.743840815'
Solution:
The Fast Recovery Area (FRA) is full with old archive log files so we need to clean this up by removing old archive logs.
If you have production environment, back these up to tape or storage for recovery and archival purposes.
Login to RMAN and run the following commands:
RMAN> CONNECT target /
connected TO target DATABASE: INSTANT (DBID=1234567890)
RMAN> crosscheck archivelog ALL;
Note: You can schedule this command once a week.
The crosscheck command does NOT DELETE the information about the logs that it
could NOT find ON disk, it just updates their STATUS IN the repository AS 'EXPIRED'.
TO obtain a list OF logs marked AS 'EXPIRED' USE the following command:
RMAN> list expired archivelog ALL;
IF it IS NOT necessary TO keep the information about these
logs IN the repository, DELETE them WITH command:
RMAN> DELETE expired archivelog ALL;
RMAN> delete archivelog all completed before 'SYSDATE-1';
The above RMAN command will delete old archive logs past 24 hours.
Now you should be able to connect to the database.
Below are some useful queries to check on FRA available space:
SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 "%" FROM v$asm_diskgroup;
NAME FREE_MB TOTAL_MB %
------------------------------ ---------- ---------- ----------
DATA 823641 1044450 78.8588252
FRA 207743 511992 40.5754387
LOG 306958 307191 99.9241514
SQL>
set lines 100
col name format a60
select name
, floor(space_limit / 1024 / 1024) "Size MB"
, ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest
order by name
/
NAME Size MB Used MB
------------------------------------------------------------ ---------- ----------
+FRA 102400 302965
If you want to change the default size for the FRA you can issue the following command from SQL*PLUS:
SQL> alter system set db_recovery_file_dest_size=600G;
System altered.
Then you should archive logs:
SQL> archive log all;
3 logs archived.
ORA-00257: archiver error. Connect internal only, until freed.
Sure enough, upon examination of the ADRCI alert.log entries, I found this:
* 2011-10-27 16:24:51.990 4265 krsh.c
ARC1: Error 19809 Creating archive log file to '+FRA'
*** 2011-10-27 16:24:51.990 2864 krsi.c
krsi_dst_fail: dest:1 err:19809 force:0 blast:1
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
DDE: Problem Key 'ORA 312' was flood controlled (0x5) (no incident)
ORA-00312: online log 2 thread 3: '+DATA/vis/onlinelog/group_2.259.743840813'
ORA-00312: online log 2 thread 3: '+FRA/vis/onlinelog/group_2.259.743840815'
Solution:
The Fast Recovery Area (FRA) is full with old archive log files so we need to clean this up by removing old archive logs.
If you have production environment, back these up to tape or storage for recovery and archival purposes.
Login to RMAN and run the following commands:
RMAN> CONNECT target /
connected TO target DATABASE: INSTANT (DBID=1234567890)
RMAN> crosscheck archivelog ALL;
Note: You can schedule this command once a week.
The crosscheck command does NOT DELETE the information about the logs that it
could NOT find ON disk, it just updates their STATUS IN the repository AS 'EXPIRED'.
TO obtain a list OF logs marked AS 'EXPIRED' USE the following command:
RMAN> list expired archivelog ALL;
IF it IS NOT necessary TO keep the information about these
logs IN the repository, DELETE them WITH command:
RMAN> DELETE expired archivelog ALL;
RMAN> delete archivelog all completed before 'SYSDATE-1';
The above RMAN command will delete old archive logs past 24 hours.
Now you should be able to connect to the database.
Below are some useful queries to check on FRA available space:
SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 "%" FROM v$asm_diskgroup;
NAME FREE_MB TOTAL_MB %
------------------------------ ---------- ---------- ----------
DATA 823641 1044450 78.8588252
FRA 207743 511992 40.5754387
LOG 306958 307191 99.9241514
SQL>
set lines 100
col name format a60
select name
, floor(space_limit / 1024 / 1024) "Size MB"
, ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest
order by name
/
NAME Size MB Used MB
------------------------------------------------------------ ---------- ----------
+FRA 102400 302965
If you want to change the default size for the FRA you can issue the following command from SQL*PLUS:
SQL> alter system set db_recovery_file_dest_size=600G;
System altered.
Then you should archive logs:
SQL> archive log all;
3 logs archived.
Subscribe to:
Posts (Atom)
