I had a HUGE dilemma, my DB server locked up because the HDD filled up due to the transaction log file getting over 50GB (Daaamn!)

Now, I am not a DB admin… at all. So I turned to Google. I was told to run DBCC Shrinkfile and all would be ok. Wrong. Nothing Happened. Turns out, my database was somehow stuck in Replication mode for the log_reuse_wait_desc in sys.databases. After a few days of Google-scrounging, I foud this gem:

Run this scheduled task: sp_removedbreplication

No i backed up my database, and then ran the DBCC Shrinkfile command and BAM! It’s all good now =)

.: Adam

1. Installing Oracle Enterprise Linux 5 Update 3 on VMWare
2. Installing and Configuring Oracle Database 11g Revision 2 (11gR2)
3. Installing WebLogic Server 11gR1 (10.3.3)
4. Executing and Configuring the Repository Creation Utility 11g
5. Installing, Patching, and Configuring Oracle Identity Management 11g
6. Installing and Patching the SOA Suite 11g
7. Installing Oracle Identity and Access Manager 11g
8. Configuration of Oracle Identity Manager 11g
9. WebLogic Server and Domain Start-up Options
10. Starting Oracle Database and Directories

Part 10 – Starting Oracle Database and Directories

This video tutorial will walk you though differnt ways to startup and stop various database and directory services.

FIN

The original source videos are available for download via Vimeo.com You’ll have to sign in to download them though. To get there, click on the “Vimeo” logo in the video.

If you have any questions, please post them below. I’m pretty tied up at the moment, but others will be able to help too!

Thanks!

.: Adam

1. Installing Oracle Enterprise Linux 5 Update 3 on VMWare
2. Installing and Configuring Oracle Database 11g Revision 2 (11gR2)
3. Installing WebLogic Server 11gR1 (10.3.3)
4. Executing and Configuring the Repository Creation Utility 11g
5. Installing, Patching, and Configuring Oracle Identity Management 11g
6. Installing and Patching the SOA Suite 11g
7. Installing Oracle Identity and Access Manager 11g
8. Configuration of Oracle Identity Manager 11g
9. WebLogic Server and Domain Start-up Options
10. Starting Oracle Database and Directories

Part 2 – Installing and Configuring Oracle Database 11g Revision 2

This video tutorial will walk you though the installation procedure for Oracle’s Database 11g Revision 2.  I also make a couple configurations for the installation of the Identity Management Suite. Lastly I’ll show you how to stop and start it (setting environment variables, etc).

Download Oracle Database 11g Revision 2 (11gR2) Here

Next >> Part 3 – Installing WebLogic Server 10.3.3

The original source videos are available for download via Vimeo.com You’ll have to sign in to download them though. To get there, click on the “Vimeo” logo in the video.

If you have any questions, please post them below. I’m pretty tied up at the moment, but others will be able to help too!

Thanks!

.: Adam

The beautiful thing about installing Oracle Database (11g in this case), is that when you reboot the linux machine, it doesn’t come back up. Also, there isn’t a singular command that starts it up either.

Awesome.

My biggest hurdle was figuring out how to start the Enterprise Manager web console. I knew that if I could get that up and running, I should be ok.

Trial by fire:

Error #1: Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

Solution #1: Remember, we’re talking linux here, so run: export ORACLE_UNQNAME=[Global Database Name]    (it’s default is orcl)

Error #2: [ORACLE_HOME]/localhost.localdomain_[DB NAME] not found.

Solution #2: This happens because if you don’t have ORACLE_HOSTNAME set, it’ll pull the domain name out of the first line of your /etc/hosts file (which is localhost.localdomain by default on OEL5). Just edit the hosts file, or edit the variable.

Now you should be able to run: emctl start dbconsole

Later!

.: Adam