Creating a Simple Database

I am new to working with Oracle, and right now, I am just trying to create a simple database from scratch that one can connect to and create tables, etc, though with the following sequence of commands, all user connections result in errors. I am working under Solaris (SunOS 5.7) with Oracle 8.1.5.

Because in the init<sid>.ora file, I have the line:

     remote_login_passwordfile = exclusive

I begin the creation of the new database with the the following line executed while logged on to the Oracle User Account under Solaris:

    orapwd file=/opt/oracle-8.1.5i/dbs/orapwwork \

         password=change_on_install entries=10

and then, I start the server manager and start the new database as follows:

     connect internal
     startup nomount
      
     create database WORK
     datafile 'work_system' size 10m
     logfile group 1 ('work_log1a', 'work_log1b') size 500k,
     group 2 ('work_log2a', 'work_log2b') size 500k;



     @/opt/oracle-8.1.5i/rdbms/admin/catalog.sql


     @/opt/oracle-8.1.5i/rdbms/admin/catproc.sql

Then, I connect to the oracle instance WORK with the command:

     connect system/manager

and execute the script:

@/opt/oracle-8.1.5i/sqlplus/admin/pupbld.sql

and then logged on as system/manager again, I execute:

     create tablespace work_users
     datafile '/opt/oracle-8.1.5i/dbs/work_users01.dbf' size 50M
     default storage (initial 500K next 50k pctincrease 0);

     create user jurek identified by pword
     default tablespace work_users
     quota 25M on work_users;

     grant create session to jurek;
     grant alter database to jurek;
     grant create any table to jurek;

however, when logging on as system/manager I get the messages:

     ERROR:
     ORA-06550: line 1, column 7:
     PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
     ORA-06550: line 1, column 7:
     PL/SQL: Statement ignored

     Error accessing package DBMS_APPLICATION_INFO
     ERROR:
     ORA-06550: line 1, column 7:
     PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
     ORA-06550: line 1, column 7:
     PL/SQL: Statement ignored

and when logging on as jurek/pword, I get the messages:

     ERROR:
     ORA-06550: line 1, column 7:
     PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
     ORA-06550: line 1, column 7:
     PL/SQL: Statement ignored

     Error accessing PRODUCT_USER_PROFILE
     Warning:  Product user profile information not loaded!
     You may need to run PUPBLD.SQL as SYSTEM
     Error accessing package DBMS_APPLICATION_INFO
     ERROR:
     ORA-06550: line 1, column 7:
     PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
     ORA-06550: line 1, column 7:
     PL/SQL: Statement ignored

Can anyone suggest and/or point me to sequence of commands and/or scripts that will initialize a database so that I can add users, who can then create and manipulate tables? At this point, I don't mind dropping this database and starting over. Was it a mistake to executed the scripts catalog.sql, catproc.sql, or pupbld.sql?

Thank you for your time,

Josef Jurek
jaj3_at_midway.uchicago.edu Received on Mon Mar 27 2000 - 11:56:52 CST