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:
Post a Comment