How to Solve: SQL Developer can’t start because MSVCR71.dll is missing (On Windows)

I have installed SQL Developer (with JDK) on Windows many times before, and almost all the time I receive the system error bellow when trying to execute it by the first time. Due to this, I decided to publish the Continue reading How to Solve: SQL Developer can’t start because MSVCR71.dll is missing (On Windows)

Have a sneak peek of my book

Do you want to have a sneak peek of my book “Oracle 12c Backup and Recovery Survival Guide” I wrote with my good friend Aman Sharma? If yes, you can download the chapter 1 of the book as a demo Continue reading Have a sneak peek of my book

DB Control/DB Console (OEM) Changing Hostname or IP Address

I just got a client that changed his server  hostname and discovered that after this change he was unable to use the DB Control. To solve this problem you will just need to follow these simple steps: 1) Set  $ORACLE_HOSTNAME Continue reading DB Control/DB Console (OEM) Changing Hostname or IP Address

Next stop: Insync’10 , NZOUG OTN Days and Sangam’10

I received some emails recently asking were will be my next presentations, and to make it public here we go: Insync’10, Melbourne August 16 – Topic: Tips and Best Practices for DBAs @ 9:55AM to 10:40 AM more info at  Continue reading Next stop: Insync’10 , NZOUG OTN Days and Sangam’10

NZOUG and LAOUC June and July Webinars (Recording)

Hi All, NZOUG (New Zealand Oracle Users Group) and LAOUC (Latin American Oracle Users Communty) is organizing a serie of webinars to Oracle Community (over 42 Webinars) with the participation of several Oracle Celebrities, and is my desire to share the first 8 webinars Continue reading NZOUG and LAOUC June and July Webinars (Recording)

Back to Basics:The Oracle Editions

Sometimes understanding the Oracle Database Editions is a little confuse, and on my opinion know all the options available in the market is something very important and fundamental for any DBA. The main idea of this post is to help you Continue reading Back to Basics:The Oracle Editions

RemoteOperationException: ERROR: NMO not setuid-root (Unix-only)

One of my DBA’s just ask me why he was receiving the following error each time he tried to setup the host information thru the dbconsole (OEM): – RemoteOperationException: ERROR: NMO not setuid-root (Unix-only) The answer is very easy, this Continue reading RemoteOperationException: ERROR: NMO not setuid-root (Unix-only)

LOGGING or NOLOGGING, that is the question – Part VIII

By Francisco Munoz Alvarez How to find Sessions Generating Lots of Redo To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, Continue reading LOGGING or NOLOGGING, that is the question – Part VIII

Are you having problems with the OEM Host Credential?

If you are using LINUX/Windows the hostname credentials should be the same user who has installed the oracle  database software, if Windows the user you are using need to be member of the ORA_DBA group and have Local Security privilege Continue reading Are you having problems with the OEM Host Credential?