emctl status dbconsole - OC4J Configuration issue

I was getting the following error when I try to run emctl:

oracle@myhost:~> emctl status dbconsole
OC4J Configuration issue. /opt/oracle/product/11gR2/db/oc4j/j2ee/OC4J_DBConsole_myhost.domain.local_myhost not found.

Cause
I discovered that some how the /etc/hosts file had enabled 127.0.0.2 entry.

Solution
Commented out the entry
#127.0.0.2 myhost.domain.local myhost

ORA-01830: date format...

ORA-01830: date format picture ends before converting entire input string

One of the possible causes of the above error could be a wrong date, e.g. 29-FEB-2010, 31-NOV-2010.

Clear Oracle Trace files in Linux

In udump folder

# find *.trc -mtime +5 -exec rm {} \;

This removes files older than 5 days

Oracle connection error

Error on connecting to Oracle, only sys as sysdba could connect but wih no access to objects. If I tried to shutdown I got this message.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

On starting up I get the following.

SQL> startup
ORACLE instance started.

Total System Global Area 496049544 bytes
Fixed Size 454024 bytes
Variable Size 209715200 bytes
Database Buffers 285212672 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01113: file 148 needs media recovery
ORA-01110: data file 148: 'H:\ORACLE\ORADATA\CALLS_TAB38.DBF'

It seems one of the data files was corrupt.

Solution
========
SQL>shutdown
SQL>startup mount
SQL>recover database
SQL>alter database open;

ORA-00600: internal error code, arguments: [kcbnew_3]

ORA-00600: internal error code, arguments: [kcbnew_3]

Solution SQL>alter system flush buffer_cache;

Am Back!!

It has been slightly over a year since I last "blogged". I guess I am back....

amvo.exe Virus

Been hit by a virus and it seems it has something to do with an "amvo.exe" process. It slows the machine and terribly affects the USB drives. This is how I managed to remove the virus and the amvo.exe process.

I recommend you do this in safe mode.

1. Run MSConfig (Go to Run, and type msconfig). Find a process with the name amvo.exe under the startup tab. It is located in Windows\System32 folder.
2. Uncheck the process, and then close the msconfig window.
3. Open Registry Editor (go to run, and type regedit). Search for "amvo.exe" and delete the key(s) found.
4. Now delete all amvo.exe, amvo1.dll. Note in most cases the file are hidden and system protect - use the attrib command to unhide the files and then delete them: c:\windows\system32>attrib -h -s -r amvo.exe
c:\windows\system32>del amvo.exe
c:\windows\system32>attrib -h -s -r amvo0.dll
c:\windows\system32>del amvo0.dll
c:\windows\system32>attrib -h -s -r amvo1.dll
c:\windows\system32>del amvo1.dll

Also the virus places Autorun.inf and *.cmd or *.bat (in my case d.com) files all the drives of your machine; do the following to remove them:
c:\>attrib -h -s -r autorun.inf
c:\>del autorun.inf
c:\>attrib -h -s -r d.com
c:\>del u.bat

After this the virus would have been removed, now run the latest anti-virus update and reboot your system and you are home and dry. I advise you run the www.kaspersky.com trial then when it has cleaned remove it and install your "normal" anti-virus pack.