General discussion

Locked

ORACLE DB Question

By unixlvr ·
I'm at a loss. My firm does not have the manuals and those that know are not willing to share knowledge. However, I really need this info to complete a project. The platform is UNIX. I can log onto the system as the oracle id, but I cannot find the command or correct syntax to create a DB or instance and bring it up. I'm using version 7.x - 8.x and know how to startup the server and listener as well as bring them down. Anyone who knows what books I could purchase and/or the correct syntaxwould be hero for life.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

ORACLE DB Question

by outlaw4 In reply to ORACLE DB Question

If the documentation set was isntalled on your server during the install of the server software, you should find it in the directory DOC under your Oracle Home. If it was not loaded down, it can be found on the install CD for the server. Other options are to go to www.oracle.com and go to the Oracle Store. There they have Documentation for sale. Also Osborne publishers put out a variety of Oracle PRESS manuals which put out a condensed set of manuals on a variety of Oracle topics (go to www.osborne.comr). If you have a CSI # regarding your purchase of the server software, you can also get the server documentation from the web site.

Collapse -

ORACLE DB Question

by unixlvr In reply to ORACLE DB Question

The question was auto-closed by TechRepublic

Collapse -

ORACLE DB Question

by sonalsejal In reply to ORACLE DB Question

Get the dba handbook from oracle press.
The syntax for setting up the oracle instance is
set oracle_sid=<sid_name>
This is true for NT. I guess the variable is $oracle_sid in Unix.
For creating the database,
CREATE DATABASE <Database_name>
LOGFILE 'D:\orant\database\log1.ora' size 5M reuse,
'D:\orant\database\log2.ora' size 5M reuse,
'D:\orant\database\log3.ora' size 5M reuse,
'D:\orant\database\log4.ora' size 5M reuse
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'd:\orant\database\Sys1.ora' SIZE 25M
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;


Alter the values of the parameters as per your need.
Hope this is a help.Sonal

Collapse -

ORACLE DB Question

by unixlvr In reply to ORACLE DB Question

The question was auto-closed by TechRepublic

Collapse -

ORACLE DB Question

by unixlvr In reply to ORACLE DB Question

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Hardware Forums