OraFAQ Forum: Server Administration » Install database with dbca and response file.

Home » RDBMS Server » Server Administration » Install database with dbca and response file.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Install database with dbca and response file. [message #623381]

Tue, 09 September 2014 08:47

Malakay79
Messages: 41
Registered: September 2007

Member

I need to create a database with a response file.
I have found the template file in $ORACLE_HOME/assistant/dbca.

I can I set the location for redo log files? And their size, their group...? I didn't find this information in the response file template

Oracle 11.2.0.3 on linux

Report message to a moderator

Re: Install database with dbca and response file. [message #623382 is a reply to message #623381]

Tue, 09 September 2014 08:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It is your system & you are free to do what ever you desire to it.

Report message to a moderator

Re: Install database with dbca and response file. [message #623383 is a reply to message #623382]

Tue, 09 September 2014 08:54

Malakay79
Messages: 41
Registered: September 2007

Member

With parameter shoul I set in response file?
For example for datafiles there is this options:
DATAFILEDESTINATION = /oradata/dbname/dbfiles/dbname -- > my value

For redo log files, what are the parameters?

Report message to a moderator

Re: Install database with dbca and response file. [message #623384 is a reply to message #623383]

Tue, 09 September 2014 09:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I need to create a database with a response file.
why?

why not use dbca to create & capture SQL (text) file which then can be easily edited to meet any new or different environment.

Report message to a moderator

Re: Install database with dbca and response file. [message #623386 is a reply to message #623381]

Tue, 09 September 2014 09:47

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

The location of the redo logs will depend on the "template" you choose and typically
will be "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}"

1) In the response file set OPERATION_TYPE = "createDatabase"
2) Choose a template: TEMPLATENAME = "General_Purpose.dbc"

You only need to set the "CREATEDATABASE" section of the response file and can ignore the rest.

PS: I recommend you create a "custom" template where you can modify the init parameters, etc... to your choosing.

Good luck!

[Updated on: Tue, 09 September 2014 10:12] by Moderator

Report message to a moderator

Re: Install database with dbca and response file. [message #623419 is a reply to message #623386]

Wed, 10 September 2014 04:56

Malakay79
Messages: 41
Registered: September 2007

Member

I know I have to use the OPERATION_TYPE = "createDatabase" and TEMPLATENAME = "General_Purpose.dbc".
But are there some parameters I can set in the response file about redo log informations? Just like DATAFILEDESTINATION for datafiles?

[Updated on: Wed, 10 September 2014 05:42]

Report message to a moderator

Re: Install database with dbca and response file. [message #623490 is a reply to message #623419]

Wed, 10 September 2014 10:25

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Malakay79 wrote on Wed, 10 September 2014 05:56

I know I have to use the OPERATION_TYPE = "createDatabase" and TEMPLATENAME = "General_Purpose.dbc".
But are there some parameters I can set in the response file about redo log informations? Just like DATAFILEDESTINATION for datafiles?

Not in the response file, but you can make a copy of the "General_Purpose.dbc", rename it and change the values there
-- it's a text file.
That is why I recommended to create your own custom template.

[Updated on: Wed, 10 September 2014 11:23] by Moderator

Report message to a moderator

Previous Topic:	ORA-16403: shut down in progress - remote connection is not permitted
Next Topic:	How to know the when the query was executed?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:45:50 CST 2025