Manual Database Creation
Manual Database Creation
To manually create a database:
- Log on as an Oracle 11 user and extract the create db scripts:
|
cd /exlibris/ftp_from_exlibris
tar xzvf install_ora.tar.gz
cd oracle/11
|
- Execute the install db script and follow the instructions:
|
oracle11@il-inst03(aleph24)oracle/11$csh -f pre_db_creation.csh
Enter some parameters ...
Oracle SID: aleph24
Server short Host Name (without domain name): [il-inst03] il-inst03
Host's Domain [corp.exlibrisgroup.com]: corp.exlibrisgroup.com
Set environment parameter ORACLE_BASE to determine the location of DB creation scripts and logs
Enter ORACLE_BASE path or default to [/exlibris/app/oracle]: /exlibris/app/oracle
ORACLE_HOME is set to /exlibris/app/oracle/product/19r1 Is this correct?
If not, correct the environment of oracle11 before you continue
Continue ? [y]: y
|
- Enter the data files locations.
- Insert each disk. For each disk you insert, make sure that it has oradata directory with oracle:dba permissions.
|
Enter Disk 1 Name or Enter to end of list [/exlibris]: /exlibris
Enter Disk 2 Name or Enter to end of list: /exlibris2
Enter Disk 3 Name or Enter to end of list:
************************************************************************
Enter Exlibris Product
1 - ALEPH <- default
2 - METALIB
3 - DIGITOOL
4 - VERDE
5 - ARC
6 - PRIMO
7 - DPS
8 - URM
[1]:1
|
- Type 1 for Aleph DB installation.
|
Date tablespaces definition: Service tablespaces definition:
---------+--------+---------+---------- ---------+--------+--------+----------
Table- Count* Type Seg. space Table- Count* Type Seg. space
space Size management space Size management
---------+--------+---------+----------| ---------+--------+--------+---------- DEMO database: |
ts0 1*4000Mb System Auto | For All Sizes
ts1 1*4000Mb System Auto |---------+--------+--------+----------
temp 1*1G system Uf.(1Mb) | system 1*640Mb System Manual
undo 1*500Mb system Auto | users 1*200Mb Uf.(40K) Auto
SMALL database: | tslob 1*70Mb System Auto
ts0 1*4000Mb System Auto | sysaux 1*640M System Auto
ts1 1*4000Mb System Auto | log 1*64M System Auto
ts1d 1*1000Mb System Auto |---------+--------+--------+----------
ts2d 1*4000Mb System Auto |
ts3d 1*6000Mb System Auto |
ts4d 1*2000Mb System Auto |
ts1x 1*1000Mb System Auto |
|
|
ts2x 1*4000Mb System Auto |
ts3x 1*4000Mb System Auto |
temp 1*1G system Uf.(1Mb) |
undo 1*1G system Auto |
LARGE database: |
ts0 1*4000Mb System Auto |
ts1 1*4000Mb System Auto |
ts1d 1*4000Mb System Auto |ts1x 1*2000Mb System Auto
ts2d 1*4000Mb system Auto |ts2x 1*4000Mb System Auto
ts3d 1*8Gb System Auto |ts3x 1*8000Mb System Auto
ts4d 1*16Gb System Auto |ts4x 1*16Gb System Auto
temp 1*3G system Uf.(1Mb) |
undo 1*2G system Auto |
---------+--------+---------+-------------------+--------+---------+----------
Enter database size DEMO/SMALL/MEDIUM/LARGE/HUGE [DEMO]: SMALL
|
- Choose the size you need according to the above. In this example a small size is chosen.
|
************************************************************************
Mirror redo log files can be created in a database where more than one DISK is specified. Otherwise the database only uses one group of the redo logs.
Configuration parameters:
-----------------------------------------------------------------------Product ALEPH
Oracle SID aleph24
DB Character Set UTF8
Oracle Owner oracle11
Oracle Group db
Oracle Home /exlibris/app/oracle/product/19r1
Oracle Global Name aleph24 il-inst03.corp.exlibrisgroup.com
Database size SMALL
Mirroring of the redo logs is Yes
Tablespaces:
--------------------------------------------------------------------------------SYSTEM,TEMP tbs., REDOLOG files /exlibris
INDEX tbs. /exlibris2
Mirror Redo Log files /exlibris2
UNDO tbs. /exlibris2
DATA tbs. /exlibris
|
|
Continue ? [y]:y
Starting preparations for DB Creation ...
** If you want to change tablespace files location/size further, please
open additional terminal,
correct /exlibris/ftp_from_exlibris/oracle/11/tbs.ini file
and continue installation
Continue ? [y]: y
The Oracle network files(listener.ora and tnsnames.ora) were created correctly
********************************************************************************Note:
** All Database creation scripts were created in :
/exlibris/app/oracle/admin/aleph24/scripts
** You can review/change the files,
as user oracle11 on another window and then continue
or exit and submit the creation script later, by issuing :
csh -f /exlibris/app/oracle/admin/aleph24/scripts/aleph24.csh
** If you want to change tablespace files location/size , please review
/exlibris/app/oracle/admin/aleph24/scripts/CreateDB.sql
/exlibris/app/oracle/admin/aleph24/scripts/CreateDBFiles.sql
/exlibris/app/oracle/admin/aleph24/scripts/CreateDBFilesAdd.sql
/exlibris/app/oracle/admin/aleph24/scripts/CreateDBFilesMirrRedo.sql
********************************************************************************Enter Exit/Continue [Continue]:
********************************************************************************Note:
** Database creation will start now in the background,
use tail -f /exlibris/app/oracle/admin/aleph24/log/db_creation.log to view creation progress
**After creation ends please check all log files at:
/exlibris/app/oracle/admin/aleph24/log
********************************************************************************To continue press Enter:
[1] 17429
|
To increase the performance of the Oracle database, adjust the Oracle SGA size for the created database. For more information, see Oracle SGA Sizing.
Now database creation is running in the background. After database installation completes successfully, continue with Import Demo Libs.