This is the error message: Error 6 initializing SQL*Plus SP2-0667: Message... It might be that the ORACLE_HOME environment variable is not properly set or a missing sp1<lang>.msb (for example sp1us.msb ) file. But for my Ubuntu system, there was no such thing as sp1<lang>.msb , and it wasn't caused by a missing ORACLE_HOME . The error was resolved after I restored the shared library file libsqlplusic.so .

It seems that the JDBC standard way to create a BLOB is to call Connection.createBlob . However, this does not work for PostgreSQL (as of version 9.0-801 jdbc4): Exception in thread "main" org.postgresql.util.PSQ... The workaround is to call a PostgreSQL function to create the Blob, then use JDBC to update it: Connection conn = jdbcTemplate.getDataSource().get... Oracle Note: the Oracle way function to create an empty BLOB is EMPTY_BLOB() . stmt.execute ("INSERT INTO my_blob_table VALUES ('...

These are the steps to diagnose the "javax.jms.Destination found at the specified destination-location" error an MDB in the Oracle application server (oc4j) environment. The data source is correctly configured and connection can be successfully established. Test this from the Oracle AS em console. The destination queue exists and is started. If you are using PL/SQL Developer, you can check this by right clicking on the queue name and make sure that "Enqueue Enabled" and "Dequeue Enabled" are checked. Deployment descriptors are correctly set up. The database user used for the JDBC connection pool has the proper privileges to enqueue and dequeue. Usually this means that the database user is assigned the AQ_USER_ROLE . The ultimate test is to run some PL/SQL code in the oc4j...

When you start Tomcat for the first time, you may get the "port 8080 is already in use" error. Indeed, port 8080 is commonly used by a lot of development servers by default (Oracle XE for another example). Luckily, it's quite easy to ask Tomcat to use a different port. I use port 8086, which is a natural next step and superior to 8080. Simply edit $CATALINA_BASE/conf/server.xml and change 8080 to 8086: <!-- A "Connector" represents an endpoint by w... If you have not configured Tomcat 6 for multiple instances by setting a CATALINA_BASE directory, then $CATALINA_BASE will be set to the value of $CATALINA_HOME , the directory into which you have installed Tomcat 6.

Solution: grant unlimited tablespace to <user> or alter user <user_name> quota 250m on <tablespace_n... Example: SQL> create table customer ( 2 id number(9),...

This seemed to happen when Oracle does not know which instance to connect to. Instead of telling you that you didn't give enough information, Oracle decides that you are better informed by telling you that it's a "protocol adapter error". In the following I didn't give the SID, nor did I set LOCAL: C:\>sqlplus scott/tiger SQL*Plus: Release 1... It does seem to give the right information on Linux: $ sqlplus scott/tiger SQL*Plus: Release 10.... Strange enough, when I change the connection string to connect to my echo server instead of the Oracle listener, I got "packet checksum failure": C:\tmp>sqlplus scott/tiger@xe SQL*Plus: Rel...

This happens when you don't have connectivity to the Oracle server. This could be that the server is not up or you are blocked because of some firewall rules. A typical session looked like this: C:\>sqlplus scott/tiger@xe SQL*Plus: Releas... Use tnsping to confirm the cause: C:\>tnsping xe TNS Ping Utility for 32-bit ...

I got "ORA-12638: Credential retrieval failed" while trying to log in an Oracle database. But my colleagues had no problems at all. C:\tmp>sqlplus scott@xe SQL*Plus: Release 1... Changing SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora from NTS to NONE fixed the problem. SQLNET.AUTHENTICATION_SERVICES= (NONE)

The ORA-06512 code is not the actual error. It merely indicates on which line the error occurred. The real error precedes ORA-06512 . For example: ERROR at line 1: ORA-29400: data cartridge e...

Use alter package to recompile a PL/SQL package. SQL> alter package UTIL compile; Warning: P...