All posts by admin

Oracle Export/Import Utility

These tools are used to transfer data from one oracle database to another oracle database. You Export tool to export data from source database, and Import tool to load data into the target database. When you export tables from source database export tool will extracts the tables and puts it into the dump file. This dump file is transferred to the target database. At the target database the Import tool will copy the data from dump file to the target database. Continue reading Oracle Export/Import Utility

Oracle 10gR2 EMCA Commands

Create a database of EM
emca-repos create
EM reconstruction of a database
emca-repos recreate
Delete a database EM
emca-repos drop
Database Control configuration database
emca-config dbcontrol db
Remove the Database Control configuration database
emca-deconfig dbcontrol db
Reconfigure the db control of the port, the default port 1158
emca-reconfig ports
emca-reconfig ports-dbcontrol_http_port 1160
emca-reconfig ports-agent_port 3940
First set the ORACLE_SID environment variable, start EM console services
emctl start dbconsole
After the first set the ORACLE_SID environment variable, stop EM console services
emctl stop dbconsole
After the first set the ORACLE_SID environment variable, see EM console status of the service
emctl status dbconsole

Steps to configure dbconsole
emca-repos create
emca-config dbcontrol db
emctl start dbconsole
The steps to reconfigure dbconsole
emca-repos drop
emca-repos create
emca-config dbcontrol db
emctl start dbconsole

Using EMCA When Database Host Name or IP Address Changes

When the database host name (including the domain name) or the IP address changes, deconfigure and then reconfigure the Database Console with the repository create command. Run the following command:

emca -deconfig dbcontrol db -repos drop emca -config dbcontrol db -repos create


emca -deconfig dbcontrol db emca -config dbcontrol db -repos recreate


Using EMCA When the TNS Configuration Is Changed

When the TNS configuration is changed, set the environment variable and then run the following command:

emca -config dbcontrol db

Life as a U.S. Marine

The Oakland MEPS station was a crowded busy terminal where families said their goodbyes.  I did not get the chance to say goodbye.  I sat alone as I waited for my bus to the Oakland airport.  Little did I know that the process would lead me to a new way of life, a life as a U.S. Marine.  I arrived at the San Diego airport at approximately 11:30pm setting me up for the longest night of my life.

As I stepped out of the bus, drill instructors lead us from one location to another making sure that the indoctrination process was complete.  The processing began at midnight and did not end until 3:30 am.  By the time morning had arrived, my civilian clothes and sneakders were packed in boxes and exchanged for cami’s  and boots.  After my shoulder length hair was cut unceremonously I quickly realized that the other recruits I met on the bus or plane disappeared as we became one melting pot of different colored recruits.  Hair apparently is the one key feature that allows us to identify each other, without it, I had to rely on other features such as eyes, nose, mouth and ears.  My drill instructors quickly identified the more mature recruits and quickly weeded out the weak in the first week.  We had not even done any real physical exercises, it was more of speaking loudly and in your face that broke many of the recruits down.  As soon as the recruit started crying and asking to go home, they would him if they were sure and got them out in a matter of minutes.   Platoon 3115 lost 7 recruits in 7 days for unfit for military duty.

The indoctrination continued the following week as we shuffled front to back with our heads down from the chow hall to the fitness fields.  There was no routine, every day there was a different activity.  Most our time was spent on learning how to become Marines; from polishing brass and boots to ironing our “woodland cami’s” and folding our t-shirts.  Wrinkles, smudges and mistakes were not tolerated.

There were 4 drill instructors, the most memorable one was Sgt. Wesley.  He was a stocky dark green Marine.  He was in the airwing and was working on becoming a staff NCO and serving as a drill instructor would allow him to earn points towards the cutting score.  He was probably the most human out of the 4 drill instructors and was the only one that could sing a cadence that was at least motivating to hear.