First complete Oracle prerequisite system parameter rpm,user group etc.
Your will get rsp file from following location
oracle@apt-amd-02:~/database/response> pwd
/home/oracle/database/response
you will get this file form
oracle@apt-amd-02:~/database/response> ls -ltr
total 268
-rw-r--r-- 1 root root 88279 2008-10-06 09:35 standard.rsp
-rw-r--r-- 1 root root 5743 2008-10-06 09:35 netca.rsp
-rw-r--r-- 1 root root 88298 2008-10-06 09:35 enterprise.rsp
-rw-r--r-- 1 root root 48199 2008-10-06 09:35 dbca.rsp
-rw-r--r-- 1 root root 26205 2008-10-06 09:35 custom.rsp
take the backup of this file enterprise.rsp
oracle@apt-amd-02:~/database/response> cp enterprise.rsp enterprise.rsp.orig
then edit this file enterprise.rsp
and change following value
=====================================
UNIX_GROUP_NAME=oinstall
FROM_LOCATION="
ORACLE_HOME=/home/oracle/product/11.2/DB
ORACLE_BASE=/apps/oracle
ORACLE_HOME_NAME=orcl
n_configurationOption=3
=====================================
n_configurationOption = 1 to create the database
= 2 to configure a ASM
= 3 install the software only
./runInstaller -ignoreSysPrereqs -force -silent -responseFile
- force allows to install into nonempty directory
Starting Oracle Universal Installer...
...............
skipped ....
Installation in progress (Thu May 15 23:54:45 IST 2008)
............................................................... 18% Done.
............................................................... 36% Done.
............................................................... 54% Done.
............................................................... 73% Done.
............ 76% Done.
Install successful
Linking in progress (Thu May 15 23:59:36 IST 2008)
Link successful
Setup in progress (Fri May 16 00:06:30 IST 2008)
.............. 100% Done.
Setup successful
The following configuration scripts
/home/oracle/product/11.2/DB/root.sh
need to be executed as root for configuring the system. If you skip the execution of the configuration tools,the configuration will not be complete and the product wont function properly. In order to get the product to function properly, you will be required to execute the scripts and the configuration tools after exiting the OUI.
Then create database manually .
===========
create database manually
sample to create database manually
init_ora53old.txt file
change your parameter accordingly .
ora53old.__db_cache_size=2231369728
ora53old.__java_pool_size=16777216
ora53old.__large_pool_size=16777216
ora53old.__shared_pool_size=318767104
ora53old.__streams_pool_size=33554432
*.db_name='ora53old'
*.db_domain=''
*.core_dump_dest='/opt/oracle/admin/ora53old/cdump'
*.user_dump_dest='/opt/oracle/admin/ora53old/udump'
*.audit_file_dest='/opt/oracle/admin/ora53old/adump'
*.background_dump_dest='/opt/oracle/admin/ora53old/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/opt/oracle/oradata/ora53old/control01.ctl','/opt/oracle/oradata/ora53old/control02.ctl','/opt/oracle/oradata/ora53old/control03.ctl'
*.db_block_size=8192
*.db_file_multiblock_read_count=16
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=418381824
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=2621440000
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
-bash-3.00$ cat v
export ORACLE_SID=ora53
export ORACLE_SID=ora53old
export ORACLE_SID=CCCUAT65
-bash-3.00$ ls -lt init*
-bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 26 11:20:13 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SYS AS SYSDBA>startup nomount pfile='/export/home/oracle/init_ora53old.txt' ;
ORACLE instance started.
CREATE DATABASE "ora53old"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/opt/oracle/oradata/ora53old/system01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/opt/oracle/oradata/ora53old/sysaux01.dbf' SIZE 120M
REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'/opt/oracle/oradata/ora53old/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON
NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE
'/opt/oracle/oradata/ora53old/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/opt/oracle/oradata/ora53old/redo01.log') SIZE 51200K,
GROUP 2 ('/opt/oracle/oradata/ora53old/redo02.log') SIZE 51200K,
GROUP 3 ('/opt/oracle/oradata/ora53old/redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY "sys" USER SYSTEM IDENTIFIED BY "sys";
spool instance name.log
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp
for jvm
$ORACLE_HOME/javavm/install/initjvm.sql
for xml
$ORACLE_HOME/xdk/admin/initxml.sql for xml
#
====
#
inter Media
Verify that Oracle JVM is installed and is valid.
You can verify that Oracle JVM is correctly installed by running
SQL*Plus, connecting as SYSDBA, and issuing the following query:
SQL> select version, status from dba_registry where comp_id='JAVAVM';
Ensure that the version is correct and the status is VALID.
SQL> connect SYS/password as SYSDBA
SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK
Where:
CTXSYS - is the ctxsys user password
SYSAUX - is the default tablespace for ctxsys
TEMP - is the temporary tablespace for ctxsys
LOCK|NOLOCK - ctxsys user account will be locked or not
connect CTXSYS/ctxsys
------------------- cut here ------------------------------
connect SYS/password as SYSDBA
set pages 1000
col object_name format a40
col object_type format a20
col comp_name format a30
column library_name format a8
column file_spec format a60 wrap
spool text_install_verification.log
-- check on setup
select comp_name, status, substr(version,1,10) as version from
dba_registry where comp_id = 'CONTEXT';
select * from ctxsys.ctx_version;
select substr(ctxsys.dri_version,1,10) VER_CODE from dual;
select count(*) from dba_objects where owner='CTXSYS';
-- Get a summary count
select object_type, count(*) from dba_objects where owner='CTXSYS' group
by object_type;
-- Any invalid objects
select object_name, object_type, status from dba_objects where
owner='CTXSYS' and status != 'VALID' order by object_name;
spool off
------------------- cut here ------------------------------
/opt/oracle/oradata/ora53old/
Create tablespace DM_CCCUAT2_DOCBASE datafile
'/opt/oracle/oradata/ora53old/dm_cccuat2_docbase01.dbf' size 4g
autoextend on next 100M maxsize unlimited extent management local
segment space management auto;
Create tablespace DM_CCCUAT2_DOCBASE datafile
'/opt/oracle/oradata/ora53old/dm_cccuat2_docbase01.dbf' size 4g
autoextend on next 100M maxsize unlimited extent management local
segment space management auto;
Create tablespace DM_CCCUAT2_index datafile
'/opt/oracle/oradata/ora53old/dm_cccuat2_index' size 3g
autoextend on next 100M maxsize unlimited extent management local
segment space management auto;
;
SYS AS SYSDBA>create user cccuat2 identifed by cccuat2 ;
create user cccuat2 identifed by cccuat2
*
ERROR at line 1:
ORA-00922: missing or invalid option
SYS AS SYSDBA>create user cccuat2 identified by cccuat2 ;
User created.
SYS AS SYSDBA>alter user cccuat2 default tablespace DM_CCCUAT2_DOCBASE ;
User altered.
SYS AS SYSDBA>grant connect,resource to cccuat2;
Grant succeeded.
create directory expdp_dir as '/opt/oracle/'
grant read,write on directory expdp_dir to system,cccuat2
CCCUAT2_pump.dmp
impdp cccuat2/cccuat2 DIRECTORY=expdp_dir DUMPFILE=CCCUAT2_pump.dmp SCHEMAS=cccuat2 TABLE_EXISTS_ACTION=REPLACE
impdp " '/ as sysdba'" DIRECTORY=expdp_dir DUMPFILE=CCCUAT2_pump.dmp SCHEMAS=cccuat2 TABLE_EXISTS_ACTION=REPLACE LOGFILE=ora53old.log
tested on 19c !!!
dbca -silent -createDatabase -responseFile NO_VALUE -gdbName 'orclcd' -templateName General_Purpose.dbc -characterSet AL32UTF8 -datafileDestination '+DATA' -sid 'orclcd' -redoLogFileSize 50 -systemPassword OraPasswd1 -sysPassword OraPasswd1 -enableArchive true -createAsContainerDatabase true -pdbName ORCLPBB -numberOfPDBs 1 -useLocalUndoForPDBs true -pdbAdminPassword OraPasswd1 -recoveryAreaDestination '+DATA' -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet AL16UTF16 -databaseConfigType SINGLE automaticMemoryManagement=false -initParams SGA_TARGET='5000M' PGA_AGGREGATE_TARGET='200M'
