Oracle 9i database creation on Linux

[Allen Karczmarek]

Hello all,
I need a white paper, document or plain and simple advice on the steps necessary to create an Oracle 9i instance on Linux. We have a new Oracle RAC setup. To be specific, I'd like to find out what files need to be updated like oratab, .profile, .login etc, where the files reside and what needs to be done with them. Over the years I've fallen into the trap of having the vendor come in and create this stuff and Linux is new to me. Any help would be appreciated.
Thanks,

[Steven E. Protter]

The steps are pretty much the same on all platforms.

sqlplus internal
@cr_db
# create the rollback segments
# alter rollback segment storage(maxextents,unlimited
@catproc
@create_tablespaces

This is the HP-UX forum btw.
Looking for a document for you. Back soon.
SEP

[Steven E. Protter · Accepted solution]

That was fast wasn't it.

Check here:
http://www.google.com/url?q=http://www.sswug.org/about/oracle.asp%3Fq%3Doracle&sa=l&ai=AIMbUdJOW_sqwMsphhAs44yaDka4zCwfp_agy46pDBEAkOBAk_WQACIAmWAA

You might be able to pull of the google part, its in an ad.


Create and cloning.
http://www.sapclub.com/oracle-database.shtml


http://www.mahanindia.com/oracle_dba.htm

Good Luck.

Also look at http://otn.oracle.com

SEP

[Indira Aramandla]

Hi,

When you say you have an Oracle RAC setup can I assume that Oracle software has been installed on your server with Linux OS.

If so then I assume the following were done.

From the Linux OS you have created an user account called ORACLE in the group called DBA and installed the oracle software as ORACLE user. If the installation was completed successfully then the .profile and .login for oracle user account is fine.

Now coming to creating an oracle instance here are the steps.

You can use the the tool dbaassist or DBCA to do the job for you. This tool will be in ORACLE_HOME/bin directory.

Login as user oracle. cd to $ORACLE_HOME/bin.

at the prompt type dbassist ot dbca. This will bring up an GUI display of Oracle Installer and take you through the varipus steps of oracle database creation.

It will prompt you for a sid name (database name), and the location for the init.ora file. provide the above and go to next. Then it will prompt for the control file (ctl) and datafile name (dbf) and location (SYSTEM, USER, TOOLS, ROLLBACK, TEMP, INDEX). These are the base datafiles that you need for an instance. Then it will prompt you for REDO LOGS names, path and sizes. And in the following screens it will prompt you for the SGA, DB_BLOCK and DB_BLOCK_BUFFER. You can prepare for these sizes depending on you oracle database size (large, medium or small).
Then it will prompt for the archive log option and destimation (ARCH), alert log destination (BDUMP), user dump file destination (udump).

At the final screen it will prompt you for creating the database or saving the scripts as a file. If you choose to save the scripts as a file, then you will have a chance to verify the names and paths and sizes before you create the database. And once you have varified all you need is to run the main script and that will call the other scripts.

before you run the script, make sure the following are defined correctly.

ORACLE_HOME, ORACLE_BASE, ORACLE_SID.

When the above tool creates the scripts it will update the oratab file as well. It will put an entry for the SID that you gave with ORACLE_HOME path and a flag N. Once the database is created you can change the flag to Y.

I hope this helps.

Indira

[Indira Aramandla]

Hi,

Please refer to the attachment. it might show ligh on some aspects of RAC on Linux.

[Indira Aramandla]

Forgot the attachment.