Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem adding database schema , eroor : not connected

legolas_wAug 19 2006 — edited Aug 25 2006
Thank you for reading my post
I download the demo sample from oracle soa web site . and i am trying to follow the tutorial to
create the database schema, to make this step complete
I create oracle_home and oracle_SID variables (Windows OS )
then
I open an sqlplus session (sys/pass as sysdba) and to make sure that i am
connected i execute

select * from V$database ;

it works

then i execute :

select * from hr.jobx

it works file.


it mean that i am connected to database.

but when i execute @build.sql i get the following errors , can some one help me ?
i should say that after i execute the @build.sql i can not execute any command because it says that SP2-0640:Not connected
SQL> @build.sql
old   1: DROP USER &&1 CASCADE
new   1: DROP USER SOADEMO CASCADE
DROP USER SOADEMO CASCADE
          *
ERROR at line 1:
ORA-01918: user 'SOADEMO' does not exist


SP2-0734: unknown command beginning "DEFAULT TA..." - rest of line ignored.
SP2-0734: unknown command beginning "TEMPORARY ..." - rest of line ignored.
SP2-0734: unknown command beginning "QUOTA UNLI..." - rest of line ignored.
SP2-0734: unknown command beginning ", create t..." - rest of line ignored.
SP2-0734: unknown command beginning ", create p..." - rest of line ignored.
SP2-0734: unknown command beginning ", create s..." - rest of line ignored.
SP2-0734: unknown command beginning ", create t..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning ", create v..." - rest of line ignored.
SP2-0734: unknown command beginning ", create s..." - rest of line ignored.
SP2-0734: unknown command beginning ", alter se..." - rest of line ignored.
SP2-0734: unknown command beginning ", create t..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning ", create m..." - rest of line ignored.
SP2-0734: unknown command beginning ", query re..." - rest of line ignored.
SP2-0734: unknown command beginning ", create d..." - rest of line ignored.
SP2-0734: unknown command beginning ", create a..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning ", alter us..." - rest of line ignored.
SP2-0734: unknown command beginning ", resumabl..." - rest of line ignored.
SP2-0734: unknown command beginning ", ALTER AN..." - rest of line ignored.
SP2-0734: unknown command beginning ", DROP ANY..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning ", LOCK ANY..." - rest of line ignored.
SP2-0734: unknown command beginning ", CREATE A..." - rest of line ignored.
SP2-0734: unknown command beginning ", SELECT A..." - rest of line ignored.
SP2-0042: unknown command "TO &&1" - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning ", execute_..." - rest of line ignored.
SP2-0042: unknown command "TO &&1" - rest of line ignored.
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
drop table 'ITEMS'
SP2-0640: Not connected
drop table 'ADDRESS'
SP2-0640: Not connected
drop table 'CUSTOMER'
SP2-0640: Not connected
drop table 'ORDERS'
SP2-0640: Not connected
drop table 'PRODUCT'
SP2-0640: Not connected
drop table 'CUSTOMER_ADDRESS'
SP2-0640: Not connected
drop sequence 'EJB_SEQ_ID_GEN'
SP2-0640: Not connected
drop sequence 'ADDRESS_EJB_SEQ_ID_GEN'
SP2-0640: Not connected
drop sequence 'ORDER_SEQ_ID_GEN'
SP2-0640: Not connected
drop table 'SSN'
SP2-0640: Not connected
SP2-0640: Not connected
create table 'ITEMS'
SP2-0640: Not connected
create table 'ADDRESS'
SP2-0640: Not connected
create table 'CUSTOMER'
SP2-0640: Not connected
create table 'CUSTOMER_ADDRESS'
SP2-0640: Not connected
create table 'ORDERS'
SP2-0640: Not connected
create table 'PRODUCT'
SP2-0640: Not connected
create primary key constraint on 'ITEMS'
SP2-0640: Not connected
create primary key constraint on 'ADDRESS'
SP2-0640: Not connected
create primary key constraint on 'CUSTOMER'
SP2-0640: Not connected
create primary key constraint on 'ORDERS'
SP2-0640: Not connected
create primary key constraint on 'PRODUCT'
SP2-0640: Not connected
create foreign key constraint on 'ITEMS'
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
create foreign key constraint on 'ORDERS'
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
What OBJECTS were created?
SP2-0734: unknown command beginning ",object_na..." - rest of line ignored.
SP2-0734: unknown command beginning "from       user..." - rest of line ignored.

SP2-0734: unknown command beginning "order by 1..." - rest of line ignored.
Are there any INVALID OBJECTS?
SP2-0734: unknown command beginning ",object_na..." - rest of line ignored.
SP2-0734: unknown command beginning "from       user..." - rest of line ignored.

SP2-0734: unknown command beginning "where      sta..." - rest of line ignored.

Comments

One alternative could be that there is a bug in the JNI code.  The use of the option ends up allowing the bug to impact the application space in a way that the OS detects it - and thus the SEGV.

Michaelt-Oracle

While a user level bug is certainly a possibility what's strange about this case is there are no user level threads making JNI calls at the time of the crash. We've also determined the crash occurs on OEL but not on Solaris Sparc, other platforms to be tested soon. The question here is simply if there are any known issues. My queries of bugdb did not yield any.

> there are no user level threads making JNI calls at the time of the crash.

Irrelevant.

SEGV occurs because the OS detected that the application did something bad.  That can occur any time once the bug occurs.  It might be immediately or hundreds of lines later.  For example if the code corrupts the native heap then the fault might not occur until the native heap manager attempts to compress the heap which can occur much later.

> We've also determined the crash occurs on OEL but not on Solaris Sparc

Different execution paths which means the potential for different behavior.  So in one case it does something the OS sees in the other it doesn't.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 22 2006
Added on Aug 19 2006
#soa-process-management, #soa-suite-discusssions
2 comments
9,190 views