topic Re: I need help on generate a database using the scirpt in Operating System - HP-UX

I need help on generate a database using the scirpt

Deanna Tran — Wed, 13 Mar 2002 17:09:06 GMT

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

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

Ian Dennison_1 — Wed, 13 Mar 2002 17:13:44 GMT

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

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

Deanna Tran — Wed, 13 Mar 2002 17:42:41 GMT

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?

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

Ian Dennison_1 — Wed, 13 Mar 2002 17:55:18 GMT

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