General
cancel
Showing results for 
Search instead for 
Did you mean: 

I need help on generate a database using the scirpt

Deanna Tran
Frequent Advisor

I need help on generate a database using the scirpt

1. I know that database uses raw I/O , and that means I do not create any filesystem.
Is that also mean that I do not need to create vgroup as well?
2. without filesystem how does oracle mount and knows what and where to run to?
3. how to check these ?
4. I need a simple script to generate the database and command on how to incorporate them to run using sqlplus
5. Currently, I have a database name is sales
thank you for your help
3 REPLIES
Ian Dennison_1
Honored Contributor

Re: I need help on generate a database using the scirpt

Deanna,

4. Just as long as the filesystem structure (directories) and space are present, then the Database can be installed. You can put the whole database in 1 logical volume if you like.

Want to know the scripts commands to create a database? Log onto another database then connect internal and type 'alter database backup controlfile to trace;'.

Use this as a template for creating your new database. To call an SQL script within SQLPLUS, use the @ symbol before the full pathname of the File.

Hope this helps. Share and Enjoy! Ian
Building a dumber user
Deanna Tran
Frequent Advisor

Re: I need help on generate a database using the scirpt

Hi Ian,
What do mean by as long as I have the filesystem (structure) available and space,
database will write to it?
Can you give me an example on to start this?
Ian Dennison_1
Honored Contributor

Re: I need help on generate a database using the scirpt

Deanna,

Here is a de-classified version of what we do here,...

/pkg/[SID] - Home directory for Application
/pkg/[SID]/ora - Home directory for Oracle
/pkg/[SID]/ora/data1,2,3 - Data Directories
/pkg/[SID]/ora/index1,2,3 - Index Directories

All of these can be mount points, or all can be under 1 mount point. As long as the directories exist and the space is available, you can place these files anywhere.

I would suggest the Oracle Admin Manuals will help a great deal. www.oracle.com

Share and Enjoy! Ian
Building a dumber user