This content has been marked as final. Show 16 replies
Which GUI are you using? Try with XMING am sure it will take just 15 to 20 minutes max time to complete.
Check below url for more info.
Mark as correct if it is helpful..
Whathas to do XMING server. Its not time the concern, but avoiding clicking the choices on the GUI every time.
I found also such resources, beifre that what is most important,
if you know on how many steps (scripts+distinct required commands) its possible.
Can all commands - to achieve those configurations needed - be put into a MEGA SCRIPT so to execute just that and end of the story.
Or which are the minimum steps possible at least? (approximately)
Always the identical configurations areneeded for every DB I have to create.
You have 2 options if you DON'T want to go through the GUI:1 person found this helpful
1. Create database manually through CREATE DATABASE command, and scripts.
2. Create a database through DBCA in Silent MODE (non - interactive)
So way 2 with Silent Mode is it possible in one step as it seenms ?!
You can exaclty put ALL your personal parameters from a file, and end of the story ?!
But way 1 with CREATE DATABASE is it the same fast in one step - if you manage to create te complex statement ?
or executions of other commands is required afterwards make it more time consuming?
TARGET IS the most automated process possible for creating the database, with the fewer steps-user intervent
Use dbca and at the end say "save scripts" instead of "create database"
You'll see what dbca does (hint: it creates a batch file/shell script for you to run everything)
! WOW can it be so simple ?!
Thank you very much !
For way 1 through CREATE DATABASE can it be the same simple and in 1 step,
so if you manage to create all the commands pack them in a mega- script also?
Or other eg console commands may be required and its not possible ?
Oh and don't forget, if possible I would like to pack also nts + tablespace creation.
Probably it can't be done from this script so
1. Can I execute the DBCA script from another script so to execute a nts confinguration script + the Tablespace script afterwards ?
Maybe this needs a different thread, deverges from tite a bit
Edited by: Goodfire on 17-May-2013 00:26
Edited by: Goodfire on 17-May-2013 00:31
You can do whatever you want in the script.1 person found this helpful
Oh so in that same script I can afterwards setup the nts and the create tablespace wright
Problem : I selected only create scipts and press finalize but no script appears at selected directory lol, is it logical?
Do I have to select also create database and templates maybe?
Edited by: Goodfire on 17-May-2013 00:43
Edited by: Goodfire on 17-May-2013 00:47
1 person found this helpful
Problem : I selected only create scipts and press finalize but no script appears at selected directory lol, is it logical?No, it's not logical, that would be a problem. It has always worked for me.
Oh maybe I have some installation problem then. Sigh I was so happy, thank you however. :(
The other way is to create a database script manually as it was sed.
Edited by: Goodfire on 17-May-2013 00:51
You do have to click "finish" (or in your case "Beenden") for the scripts to be generated1 person found this helpful
Left the standard datapath and it worked lol. Still my path was on the same Disk. So funny problem
*2nd Part Question :* It has created many scripts. Which script is the last executed so I can put commands for NTS and CREATE TABLESPACE afterwards?
You sed it can be done in the script
Edited by: Goodfire on 17-May-2013 01:05
Edited by: Goodfire on 17-May-2013 01:07
Edited by: Goodfire on 17-May-2013 01:14
Look at the batch file/shell script and all will become clear.1 person found this helpful
Did you notice step 8 in dbca? The step where you say whether you want sample data? There is a tab there which you can use to add your own scripts in via DBCA and then have it included...
Oh so there I can include scripts to be run after my DB creation scripts are run wright? Thanks
Oh and so thought he bat I execute the scripts. Thank you.
I will look what I have to change for DBNAME and passwords each time.
Edited by: Goodfire on 17-May-2013 01:30