Thursday, June 22, 2006

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory


Solution :
You need to Manually startup the database


check ORACLE_SID has value

sqlplus "sys/password as sysdba"
startup;
Connected to an idle instance.

SQL> startORACLE instance started.
SQL> exit

$ export ORACLE_SID=ANOTHER_SID
$ sqlplus "sys/password as sysdba"

SQL> startup;
SQL> exit

$ export ORACLE_SID=jcrdb
$ sqlplus "sys/password as sysdba"
SQL> startup;
SQL> exit

Monday, June 05, 2006

Bigger type length than Maximum

Bigger type length than Maximum problem in oracle
I copied a different classes12.jar file from an application that works. after I reinstalled the application with the new jar file it works like a champ.To anyone who may have this problem in the future, look at the manifest.mf file in the classes12.jar. this will tell you the oracle version of that driver. the one that worked for me was oracle version 9.0.2.0.0. the version 10 jar is the one that did not work.

Web Hosting Cheap PHP Plans Also at For free flags of the world