HP-Oracle database

[Deanna Tran]

Hi,I have accomplished put Oracle 9i on the HP. My question is that
1.do i have to load the client as well before I can start up the database?
2. Is there any special instruction on how to start up the database?
3. If I want to run some I/O on some mount points, does the procedure to create a vg and logical and filesystem the same as stated in LVM?
Thank you very much for your help

[Sanjay_6]

Hi Deanna,

Try the oracle Administrator Guide for hp-ux,

http://docs.oracle.com/HTML_Storage/a90347/toc.htm

you should be installing the client part on your workstation.

hope this helps.

Regds

[Sanjay_6]

Hi Deanna,

Missed your last question. The procedure is same as creating normal lvm filesystems and vg's. you won't have to create the filesystem on the logical volume is you plan to use raw disk space to store your database.

Hope this helps.

regds

[Deanna Tran]

I have browsed through the documenatation that you sent out as a link. i am new at this database thing, as I read through it, i got confuse? Can you help me to simiply the procedure on how to start up the database?

[Roger Baptiste]

Hi,


On a tangent,
I would suggest this good book - OracleDBA 101, to get a nice and entertaining intro
do DB administration.
A quicklink:
http://www.amazon.com/exec/obidos/ASIN/0072121203/qid=1014340182/sr=1-1/ref=sr_1_1/103-2894632-2274224

-raj

[Andreas D. Skjervold]

Hi

1. You do not have to have a client to start the database, just run the sqlplus:
startup pfile=/oracle/admin/pfile/init.ora
(The Oracle client is installed by default if you haven't deselected it during custom install.)

2. As oracle user (oracle software owner) start sqlplus:
SQL> startup
pfile=/oracle/admin//pfile/init.ora

If link to init.ora is placed in $ORACLE_HOME/dbs :
SQL> startup

You'll see the startup sequence:
Instance started
Database Mounted
Database Open

and the SGA sizes spelled out.

3. To create I/O on specific mount points you have to push data into the database in segments (tables) placed in tablespace that is placed on that spesific mount point.

Andreas