Windows Vistat/7 starting with a temporary profile

Rename the temp profile & then rename your 'actual' profile entry in the registry by removing the .bak

HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

Oracle ORA-00600: internal error code, arguments: [keltnfy-ldmInit]

Error

Oracle ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

Solution:
Check if the hostname has not been changed, or the /etc/hosts file has the correct entry fir your host.

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;