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 .

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

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)

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

I get this error using PL/SQL to enqueue a JMS message in Oracle XE: Oracle: PLS-00302: component 'CONSTRUCT' must be declared . Following an advice I found on the web , I ran the script "$ORACLE_HOME/rdbms/admin/prvtaqal.plb" as SYS in sqlplus. That worked even though I got a bunch of errors running the script: Warning: Package created with compilation errors. ...

I have a PL/SQL package which uses DBMS_AQADM to create a queue. Oracle gave " PLS-00201 identifier 'DBMS_AQADM' must be declared " error when I tried to create the package. This happened even after I gave the user AQ_ADMINISTRATOR_ROLE , which has EXECUTE privilege on DBMS_AQADM, as can be confirmed with this query: select * from role_tab_privs where role= 'AQ_ADMIN... I have to grant EXECUTE right to the user directly to make it work. It turned out that roles are disabled in any named PL/SQL block ! The following comes from Oracle9i Database Concepts doc: PL/SQL Blocks and Roles The use of roles in a PL/SQL block depends on whether it is an anonymous block or a named block (stored procedure, function, or trigger), and...

SQL> drop table update_queue_tab; drop table up... Following a tip on dbaforums.org , I entered alter session set events '10851 trace name context... And was able to drop the table with drop table update_queue_tab