svrmgrl

[scohan]

I have scripts used to create Oracle 7.3 and 8i databases which use svrgml. Has this been deprecated in 9i? What do I use instead of svrmgrl to create databases from a script?

I haven't kept up with the newer gui database configuration assistants. Isn't it better to use scripts to create the database so that the process is repeatable and all your settings are written down in the scripts? Or is it better to use the configuration assistant? We have maybe 10 SIDs to create.

Thanks.

 

[jee]

According to the 9i documentation, the Oracle-preferred tools for generating a database are the Database Configuraiton Assistant and SQL*PLus Worksheet.

Here is a blurb about SQL*PLUS Worksheet:

When you need to administer your database environment with SQL, PL/SQL, or SQL*Plus commands, use Oracle SQL*Plus Worksheet. With Oracle SQL*Plus Worksheet, you can enter SQL and PL/SQL code and DBA commands dynamically and run scripts which are stored as files.


I agree with you about using scripts for all of the reasons you note.

 

[scohan]

Thanks. I'll look into it.

 

[stefanhei]

Hi.
In 9i you can use:
sqlplus /nolog
instead of svrmgrl.

Stefan