SILENT DATABASE INSTALLATION 11gR2 on RHEL5.4

Go to 11gR2 database SETUP location like this :-

[oracle@sonu ~]$ cd
/SETUP/11gR2/database/response/

[oracle@sonu response]$ vi dbca.rsp

                           Edit dbca.rsp Script

Edit GDBNAME,SID,HOSTUSERNAME, Value :-

GDBNAME = "orcl11g.us.oracle.com"  Replace by “rim.oracle.com”
<enter database name which you create>

SID = "orcl11g"   Replace by  " rim " 
<database name which you create>

HOSTUSERNAME =  <sonu.oracle.com> 
<Enter server hostname.Dominname.com>

#.Save DBCA.rsp Script

STEPS :-2
New Sessions Set env. :-
give below step :-
[oracle@sonu ~]$ . oraenv
ORACLE_SID = [oracle] ? Idea  <your old SID>
The Oracle base for ORACLE_HOME=/11g/oracle/app/oracle/product/11.2.0/dbhome_1 is /11g/oracle/app/oracle

After that run Script Use below syntax :-
Go to dbca.rsp Script location..
[oracle@sonu ~]$ cd /setup/11g_r2/database-11.2.0.1/database/response/
[oracle@sonu response]$ ll
total 76
-rwxrwxrwx 1 oracle dba 44972 Jul 13 09:54 dbca.rsp
-rwxrwxrwx 1 oracle dba 22557 Jul 12 17:18 db_install.rsp
-rwxrwxrwx 1 oracle dba  5740 Jul 12 17:18 netca.rsp

Run dbca.rsp Script :-

[oracle@sonu response]$ dbca -silent -responseFile dbca.rsp

Enter SYS user password: sys  <enter password sys>
Press ENTER
Enter SYSTEM user password: manager  <enter password system>
Press ENTER
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/11g/oracle/app/oracle/cfgtoollogs/dbca/rim/rim.log" for further details.
[oracle@sonu response]$


Processes END your database SID= “RIM” created successful.

Open New Terminal :-
Set INV. Like this ….
[oracle@sonu ~]$ . oraenv
ORACLE_SID = [idea] ? rim
The Oracle base for ORACLE_HOME=/11g/oracle/app/oracle/product/11.2.0/dbhome_1 is /11g/oracle/app/oracle
[oracle@sonu ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 13 14:57:55 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Enter user-name: sys as sysdba
Enter password: ***  <sys>

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v$database;
NAME
---------
RIM

This is your new database which you create SILENT MODE through dbca.rsp Script......

************************END******************************

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...