Create Database manually for File System Storage Mechanism
Step 1: Create a initSID.ora (Example: initRWDB.ora) file in $ORACLE_HOME/dbs/ directory.
Example: $ORACLE_HOME/dbs/initRWDB.ora
Put following entry in initTEST.ora file
*.audit_sys_operations=TRUE
*.audit_trail=’db’
*.compatible=’19.3.0.0.0′
*.control_files=’/oracle/DATA/control01.ctl’,’/oracle/DATA/control02.ctl’
*.db_block_size=8192
*.db_name=’RWDB’
*.diagnostic_dest=’/home/oracle’
*.memory_max_target=754974720
*.memory_target=754974720
*.open_cursors=300
*.os_roles=FALSE
*.processes=300
*.recyclebin=’OFF’
*.remote_login_passwordfile=’EXCLUSIVE’
*.undo_tablespace=’UNDOTBS1′
Step 2: Set ORACLE_HOME , PATH and ORACLE_SID enviroment
export ORACLE_HOME=/oracle/19c_home
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=RWDB
Step 3: Create a password file
cd $ORACLE_HOME/dbs
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwdtest password=manager
Step 4: Run the following sqlplus command to connect to the database and startup the instance.
$sqlplus ‘/ as sysdba’
SQL> startup nomount
Step 5: Create the Database. Use following scripts
CREATE DATABASE RWDB
USER SYS IDENTIFIED BY manager
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 (‘/oracle/DATA/redo01.log’) SIZE 50M,
GROUP 2 (‘/oracle/DATA/redo02.log’) SIZE 50M,
GROUP 3 (‘/oracle/DATA/redo03.log’) SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 50
MAXDATAFILES 100
MAXINSTANCES 1
DATAFILE ‘/oracle/DATA/system01.dbf’ SIZE 100M autoextend on
SYSAUX DATAFILE ‘/oracle/DATA/sysaux01.dbf’ SIZE 100M autoextend on
DEFAULT TABLESPACE users datafile ‘/oracle/DATA/users01.dbf’ size 100m autoextend on
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE ‘/oracle/DATA/temp01.dbf’ SIZE 50m
UNDO TABLESPACE undotbs1
DATAFILE ‘/oracle/DATA/undotbs01.dbf’
SIZE 200M;
Step 6: Run the scripts necessary to build views, synonyms, etc.:
@$ORACLE_HOME/rdbms/admin/catalog.sql — creates the views of data dictionary tables and the dynamic performance views.
@$ORACLE_HOME/rdbms/admin/catproc.sql — establishes the usage of PL/SQL functionality and creates many of the PL/SQL Oracle supplied packages.
conn system/manager
./sqlplus/admin/pupbld.sql
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
Step 7: Create Listener file.
cd $ORACLE_HOME/network/admin
vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = AQA1VMSITORA01)(PORT = 1521))
)
)
lsnrctl start
Step 8: Create tnsnames.ora file
LISTENER = (ADDRESS = (PROTOCOL = TCP)(HOST = AQA1VMSITORA01)(PORT = 1521))
RWDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = AQA1VMSITORA01)(PORT = 1521))
) (CONNECT_DATA = (SERVICE_NAME = RWDB) ) )
tnsping rwdb
Responses