Oracle Database HOWTO: Creating a Database
3. Creating a DatabaseNow the Oracle server is installed we need to create a database to test the installation.If you are using Oracle 7.2.x or earlier, please read the troubleshooting section below.
3.1 Create the Initialisation FileCopy the $ORACLE_HOME/dbs/init.ora to $ORACLE_HOME/dbs/initorcl.ora:
$ cd $ORACLE_HOME/dbs
$ cp init.ora initorcl.oraModify it by adding the following lines:
db_name = orcl
COMPATIBLE=7.3.3.0.03.2 Creating the Database Install ScriptCreate a script file called makedb.sql in the $ORACLE_HOME/dbs directory:
connect internal
startup nomount
set echo on
spool makedb.log
create database orcl
maxinstances 1
maxlogfiles 8
datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
logfile
'$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
@$ORACLE_HOME/rdbms/admin/catalog.sql
create tablespace rollback
datafile '$ORACLE_HOME/dbs/orcl_roll_01.dbf' size 8.5M reuse;
create tablespace temp
datafile '$ORACLE_HOME/dbs/orcl_temp_01.dbf' size 5M reuse
temporary;
create tablespace users
datafile '$ORACLE_HOME/dbs/orcl_user_01.dbf' size 10M reuse;
create rollback segment r1 tablespace rollback
storage ( optimal 5M );
alter rollback segment r1 online;
connect system/manager
@$ORACLE_HOME/rdbms/admin/catdbsyn.sql
connect internal
@$ORACLE_HOME/rdbms/admin/catproc.sql
connect system/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
spool off
exit3.3 Running the Database Installation ScriptStart svrmgrl and run the script:
$ cd $ORACLE_HOME/dbs
$ svrmgrl
Oracle Server Manager Release 2.3.3.0.0 - Production
Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup nomount
ORACLE instance started.
Total System Global Area 4313312 bytes
Fixed Size 41876 bytes
Variable Size 4140364 bytes
Database Buffers 122880 bytes
Redo Buffers 8192 bytes
SVRMGR> @makedb
<loads of messages>
SVRMGR> exit
Server Manager complete.3.4 Starting the DatabaseFirstly, we need to bring up the database by hand (we will automate this later on). To startup an Oracle database we need to issue the startup command when connected internally:
$ svrmgrl
Oracle Server Manager Release 2.3.3.0.0 - Production
Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 4313316 bytes
Fixed Size 41876 bytes
Variable Size 4140368 bytes
Database Buffers 122880 bytes
Redo Buffers 8192 bytes
Database mounted.
Database opened.
SVRMGR> exit
Server Manager complete.3.5 Stopping the DatabaseIt is worth mentioning here that restarting a Linux server without shutting down the Oracle database first there is a high risk of corrupting the database.So, before we issue the Linux shutdown command it is wise to bring down the database:
$ svrmgrl
Oracle Server Manager Release 2.3.3.0.0 - Production
Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> exit
Server Manager complete.3.6 Create a Default UserThe database, as created, has a two special users which are automatically created. These are:
Username Password
SYSTEM MANAGER
SYS change_on_installThese users are typically used to hold the standard data dictionary information for the database. It is a good idea to change the passwords from the defaults as soon as possible.This can be achieved by:
sqlplus system/manager
SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release
SQL> alter user system identified by <newpassword>;
User altered.
SQL> alter user sys identified by <newpassword>;
User altered.
SQL> exit;
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - ProductionSince the user system/manager is similar to using root on a UNIX machine, we need to create a user with less ability to cause damage. (remember to bring up the database before attempting to create a user)Connect to SQL*Plus and create a user:
$ sqlplus system/manager
SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
SQL> create user <user> identified by <psw>
2 default tablespace users
3 temporary tablespace temp;
User created.
SQL> grant connect, resource to <user>
Grant succeeded.
SQL> exit
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - ProductionNow that you have a new user on the system you can play with the new system. To login to the Oracle database:
$ sqlplus <user>/<password>If this completes with no error messages then you have a working Oracle database. If you never want to connect to this database from anywhere but this server then the job is complete, enjoy!If, however, like most people you want to configure the networking software so that you can connect from other machines, keep on reading.
L
Wyszukiwarka
Podobne podstrony:
oracle howto 6 l2qdgdsr3ci2pskmuzrtz4aomt3e422zeba3xcy l2qdgdsr3ci2pskmuzrtz4aomt3e422zeba3xcyoracle howto 8 dbpav6jvc6lgqbjwwopqb7ugmz6pr6xir65un3y dbpav6jvc6lgqbjwwopqb7ugmz6pr6xir65un3yoracle howto 1 bksshc3lsojtrc6if34lgpmpdsqkhf2g7iwkupyoracle howto 4 qvnvgg5v4si74gh5xgbzzf73ue6t67mhwiyna2aoracle howto 2 7odlbvtf5fahbnezs3xjfbriwoyiwasqa5rtmjaoracle howto 9 5dbaoarazpzx4qckhbwiupakwaxypoemkd4fesa 5dbaoarazpzx4qckhbwiupakwaxypoemkd4fesaoracle howto e6tzl4llrpelmipsxxukzd76nvwzgidmosf6feioracle howto 5 hygqhhjd6j6ygbgloydr245p3ujkwzroq6lxqly hygqhhjd6j6ygbgloydr245p3ujkwzroq6lxqlybootdisk howto pl 8PPP HOWTO pl 6 (2)NIS HOWTO pl 1 (2)kernel howto 3 clbigwpagydoy3epnkmic3ys7wlqwsg4rlwwgvq clbigwpagydoy3epnkmic3ys7wlqwsg4rlwwgvqconsultants howto 18cdrom howto pl 1jtz howto pl 5Keystroke HOWTO pl (2)PostgreSQL HOWTO pl 14więcej podobnych podstron