Forum Stats

  • 3,768,181 Users
  • 2,252,755 Discussions
  • 7,874,485 Comments

Discussions

problem adding database schema , eroor : not connected

legolas_w
legolas_w Member Posts: 547
edited Aug 25, 2006 10:28AM in SOA Suite Discusssions
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

  • legolas_w
    legolas_w Member Posts: 547
    Hi
    I almost resolved the issue but i do not know whether it is a correct path that i used or not.

    i have made some changes in build.sql as follow :
    -i changed the schema name to HR , and its pass to HR_PASS
    -i comment schema creation command

    now it successfully executed.

    but i can not understand what was the problem.

    Thanks
  • gdmccarty
    gdmccarty Member Posts: 20
    For me, the problem was 'blank' lines intersperced in the build.sql and createSchema.sql files.

    I edited each and removed the empty lines. All worked well.
This discussion has been closed.