java.lang.ClassNotFoundException: oracle.forms.engine.Main

Oracle Application Server 10g has a form service to run a form on the web,
Start -> Programs ->Oracle Application Server 10g -> Forms Services -> Run a form on the web for form=test.fmx

If the applet is not display correctly and receive the error:
java.lang.ClassNotFoundException: oracle.forms.engine.Main

you should check if JInitiator already installed.

If already installed, then check in
Control Panel -> JInitiator administration console , the option “Use browser settings” and “use proxies” has to be unchecked.

Add Y!M and Live M Online Status to Web Pages

Add Yahoo! Messenger and Windows Live Messenger Online Status to Web Pages

Online status icon allows people who visit your web page to see if the you currently online using Yahoo! Messenger or Windows Live Messenger.

There are many places where you can insert your online presence. Some examples include:
– Your Homepage
– Your Weblog
– Your Online Journal
– Message Boards

You can get online status for Yahoo! Messenger at Add Presence, just type your Yahoo! ID then copy and paste the HTML text below it into your web document.

If a visitor of your web page clicks your online status, an instant message window will open for them so they can type you an instant message to contact online with you.

And to get HTML code for Live Messenger online status, you can get at page Live Messenger Settings. But first you must be login and then check list the option “Allow websites to see your Messenger status and send you messages”. Then you click link of “Create HTML” and choose the appropriate control you desire. Final step, copy the HTML and paste it into your webpage.

There is another service that provide service that lets you put a small image on a web page to show if you are online on AOL Instant Messenger, ICQ, IRC, Jabber, MSN Messenger, Skype, and Yahoo Messenger.


Create or Export data from MDB to DBF

To export data that have been query by “SELECT … FROM” in mdb file to dbf file, you can use this sample query :

SELECT * INTO [dBase IV;database=C:\].newdbf FROM bank

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00257: archiver error. Connect internal only, until freed.
Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.

Action: Check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.


I clear some archivelog that have fill up until server harddisk has no space anymore. After clear some archivelog, then automatically the message not display anymore.


ORA-09275: CONNECT INTERNAL is not a valid DBA connection
Cause: CONNECT INTERNAL is no longer supported for DBA connections.
Action: Please try to connect AS SYSDBA or AS SYSOPER.

INTERNAL is a desupported account,

use :





Connect Remotely as SYSDBA using orapwd


parameter be set to either SHARED or EXCLUSIVE.
SHARED the password file can be used by multiple databases and only the SYS user is recognized.
EXCLUSIVE the password file can be used by only one database and multiple users can exist in the file.

The parameter value can be confirmed by:

SQL> show parameter password


—————————– ———– ———-
remote_login_passwordfile string EXCLUSIVE

– Create the password file using the ORAPWD utility.

orapwd file=<filename> password=<password> entries=<max_users>

– Connect to the database as user SYS (or as another user with the administrative privilege).
If the user does not already exist in the database, create the user.
Grant the SYSDBA or SYSOPER system privilege to the user.
This will add the user to the password file, and that user’s name and privilege information are added to the password file.

SQL> grant sysdba to scott;

Grant succeeded.

– Confirm that the user is listed in the password file.

SQL> select * from v$pwfile_users;


—————————— —— ——-



Disable connect / as sysdba

How to disable “connect / as sysdba” ?

Do one of this step :
1. change your authentication
in you sqlnet.ora if on windows.

2. remove user from the dba group

note: consider using the Password file authentication method