Home » RDBMS Server » Server Administration » Install database with dbca and response file.
Install database with dbca and response file. [message #623381] Tue, 09 September 2014 08:47 Go to next message
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
Re: Install database with dbca and response file. [message #623382 is a reply to message #623381] Tue, 09 September 2014 08:50 Go to previous messageGo to next message
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.
Re: Install database with dbca and response file. [message #623383 is a reply to message #623382] Tue, 09 September 2014 08:54 Go to previous messageGo to next message
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?
Re: Install database with dbca and response file. [message #623384 is a reply to message #623383] Tue, 09 September 2014 09:05 Go to previous messageGo to next message
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.
Re: Install database with dbca and response file. [message #623386 is a reply to message #623381] Tue, 09 September 2014 09:47 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  


Current Time: Thu Mar 28 14:59:28 CDT 2024