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 [...]

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 [...]

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 [...]

ORA-09275: CONNECT INTERNAL

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 SYS/PASSWORD AS SYSDBA or – CONNECT / AS SYSDBA instead.

Connect Remotely as SYSDBA using orapwd

- Set init parameter to REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE. 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 [...]

Disable connect / as sysdba

How to disable “connect / as sysdba” ? Do one of this step : 1. change your authentication from SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (BEQ,NONE) in you sqlnet.ora if on windows. 2. remove user from the dba group note: consider using the Password file authentication method

Unable to allocate record buffer

FRM-40900: Unable to allocate record buffer. Clear form to continue. Cause: Failed attempt to allocate memory for a fetched or new record. The remaining records that are queried are temporarily buffered on disk. This is an indication that no more temporary files can be written to the disk. Action: Clear form and then attempt to [...]

Oracle Enterprise Manager Cannot Restart Database

Oracle Enterprise Manager when Restart Database:Specify Host and Target Database Credentials has raise error message : RemoteOperationException: ERROR: Wrong password for user It because OEM use OS user name and password to login to target database machine which OS user name must have right “Logon as a batch job”. You can set this right just by – run secpol.msc in Windows | Run [...]

ORA-06553: PLS-801: internal error [56319]

When i have finish update oracle 32-bit to 64-bit, then i try to compile procs and I got this message, Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-06553: PLS-801: internal error [56319] ————————————————— ORA-00604: error occurred at recursive SQL level 2 ORA-06544: PL/SQL: internal error, arguments: [56319],[], [], [], [], [], [],[] ORA-06553: PLS-801: internal error [56319] i have tried steps to fix this problem - run STANDARD.SQL to reinstall [...]

Enterprise Manager is not able to connect to the database instance

Today i got this message from OEM, “Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.” I have search the solution that help me to fix this problem, - first, check DBSNMP, SYSMAN, and SYS not locked and password value is ok. default password for DBSNMP is DBSNMP, SYSMAN is SYSMAN, SYS is MANAGER or CHANGE_ON_INSTALL. to ensure the correct password, it is better to alter it with new password. - emca -deconfig dbcontrol db Database SID : [...]