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;

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.

Going LIVE!!

After a year on a project, finally the day of reckoning has come.

Doing my final migration of data from old COBOL system to Oracle database system. I hope everything goes on well. And I don't intended to spend the whole night at work. Just sitting waiting for the mugration procedure finish.

Come 30-01-2008 users should be LIVE.

Programming & Pungwe

Pungwe is Shona term for an overnight vigil (working, church vigil, or even political gathering).

Had to stay at work on 22.01.2008 till 3am trying to complete a task; and this is not my first time to be in that situation. I don't know what it is about programmers working late(early).

But good thing come the follwong day you are not in the office, and everyone has an issue that they want solved yesterday. Of-course your phone will be not reachable, and also it is "unethical" to call someone who is resting after the whole night at work.

Oracle EXP error EXP-00056

When I was trying to run the EXP commnand as follows
EXP userid=username/pwd@sid file=d:\dumps\20080113_1.dmp log=d:\dumps\20080113_1.log tables=(pm1,pm2,pm3,pm4,pm5a,pm5b,pm6)

got this error:

EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully

Found the following to solve my misery; just remove the @sid ! And it worked.

EXP userid=username/pwd file=d:\dumps\20080113_1.dmp log=d:\dumps\20080113_1.log tables=(pm1,pm2,pm3,pm4,pm5a,pm5b,pm6)

Have a bug free day :)

Some Music for You!

I like music, and sing as well. I am a part of our local church men's choir (Warren Park Methodist Church in Zimbabwe (MCZ) - Vabvuvi)

We recorded our first album, MWEYA WANGU (My Soul), in 2006 and it consists of 8 songs. On the album sleeve I am seated next to the ngoma (drum).



Buy this CD or Cassette when you see one. I promise you, you will enjoy the music.

Merry Christmas & Happy 2008

Hoping you all had a wonderful Christmas, and may 2008 bring you a lot of peace and joy.

Notepad 'Bug' - Disabled Status Bar

Had a problem, and been handicapped for the whole day. My Status Bar in notepad (one of my favourite editor) was disabled. Tried all I could, even rebooted my PC twice, but no solution.

Finally towards knock off time, I discovered my problem. The Status bar and Word Wrap do not work together!!!!

Simply unchecked the Word Wrap function, and walla!!!!!

Tapinda Tapinda

Just created my blog. I hope I will be able to Blog all the way.

My Blog will mainly involve my day to day life in Software Development. Might include a few personal issues.

I am a Systems Administrator (Databases & Business Applications ), mainly involved in systems development. Strong skills in Oracle & SQLServer Administration, PL-SQL, VB6.0 VB.net, Cobol (the old horse).

Have put my hands on C++ , Java and Web development, but haven't had any real live industry experience on those.