DBAsupport.com Forums - Powered by vBulletin

View Poll Results: If i run my database it will start smoothly

Voters
2. You may not vote on this poll
  • yes

    0 0%
  • no

    2 100.00%
Results 1 to 8 of 8

Thread: while running catproc.sql

  1. #1
    Join Date
    Jul 2009
    Posts
    6

    Question while running catproc.sql

    Dear Seniors,

    Right now am Creating an Database Manually.
    i created and for the compleation i run these following files
    catalog.sql
    &
    catproc.sql


    while running the CATPROC.SQL
    .
    .
    .
    ERROR:
    ORA-03114: not connected to ORACLE

    ERROR:
    ORA-03114: not connected to ORACLE

    ERROR:
    ORA-03114: not connected to ORACLE

    ERROR:
    ORA-03114: not connected to ORACLE

    Enter value for wpi_file_var:

    i dont know what i have to enter ,, ?????

    Please help me,,
    and let me know is my database is created well,, is there any problem for this here after..

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you did it wrong - your database is broken - start again

  3. #3
    Join Date
    Jul 2009
    Posts
    6

    Exclamation Brocken

    What it means,, i ran it very clearly

    create database natur
    logfile group 1 'D:/oracle/product/10.2.0/oradata/natur/redo1.log' size 10m,
    group 2 'D:/oracle/product/10.2.0/oradata/natur/redo2.log' size 10m,
    group 3 'D:/oracle/product/10.2.0/oradata/natur/redo3.log' size 10m
    datafile 'D:/oracle/product/10.2.0/oradata/natur/system.dbf' size 20m autoextend on
    next 2m maxsize 30m
    sysaux datafile 'D:/oracle/product/10.2.0/oradata/natur/sysaux.dbf' size 10m autoextend on
    next 1m maxsize 20m
    undo tablespace UNDOTBS1 datafile 'D:/oracle/product/10.2.0/oradata/natur/undo.dbf' size 10m
    default temporary tablespace temp tempfile 'D:/oracle/product/10.2.0/oradata/natur/temp.dbf' size 10m



    This creation commands did well after this i ran

    D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN/catalog.sql
    this also ran well,
    then i ran this catprog
    D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN/catproc.sql

    here comes the problem,, its not a problem it may be a file missing,,
    please help me,,i want to run this database,,, its a must one

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you lost connection, thats why you have the no connection error

    start again and use dbca

  5. #5
    Join Date
    Jul 2009
    Posts
    6

    Smile Thank u

    Thank u very much,,

    Can u please post how to create a database in manual,, please tell me in ur own way..

    (if u free just post it)

  6. #6
    Join Date
    Jul 2009
    Posts
    6
    Quote Originally Posted by honeyonair View Post
    Dear Seniors,

    Right now am Creating an Database Manually.
    i created and for the compleation i run these following files
    catalog.sql
    &
    catproc.sql


    while running the CATPROC.SQL
    .
    .
    .
    ERROR:
    ORA-03114: not connected to ORACLE

    ERROR:
    ORA-03114: not connected to ORACLE

    ERROR:
    ORA-03114: not connected to ORACLE

    ERROR:
    ORA-03114: not connected to ORACLE

    Enter value for wpi_file_var:

    i dont know what i have to enter ,, ?????

    Please help me,,
    and let me know is my database is created well,, is there any problem for this here after..

    Enter value for wpi_file_var: eee
    SP2-0310: unable to open file "D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN/eee.sql"


    this is what happened when i enter ee

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look, its obvious you have no idea what you are doing

    use dbca to create you database

  8. #8
    Join Date
    Jul 2009
    Posts
    6
    Now its running fine

    u are correct, its connection was broken,, now i stared again and running well,,

    thank u for u a kind polite reply

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width