Database Administration (MOSC)

MOSC Banner

Need to create 50 databases

edited Apr 28, 2016 4:59AM in Database Administration (MOSC) 5 commentsAnswered

hello,

I need to create 50 database, with the same size, the datafiles are locate at the same directory structure on different server.  I can use dbca and generate the scripts, but I can't use it to create a database with a different name, because it's create a controlfile (TempControl.ctl) with the name of the database in it.

So I can use the scripts, change the SID and run it.

Here is my questions what is the best approach to be able to create my 50 databases.

I use Oracle 12c without multitenant.

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center