Linux

What is the use of cora?
before creating an oracle instance..need to set the oracle_sid using cora.what is the use of setting?
how we can do this in linux?
all unix shells are valid in Linux also?
Pls help me to understand
Thanks
Shruti

Have no idea what Cora is. (A google search turned up Congress of Romanian Americans and California Outdoor Roller Skating - Needless to say, probably not what you are looking for)

Can you elaborate on your environment? What OS are you using and what shell? What do you know about CORA? (Did you possibly mean CORBA?)

before creating an oracle instance..need to set the oracle_sid using cora.what is the use of setting? oracle_sid represents the value of the Oracle Schema ID or the instance of the database you are creating/connecting to. This is required to make a connection.

all unix shells are valid in Linux also? - This depends on the actual shell being used. Not all UNIX shells will run under linux (or vice versa) without some modification. What that modification is depends on how the shell was written.

There isn't anything called cora that I'm aware of pertaining to Oracle. There is a coraenv script which sets up the environment; that is to say, it defines where ORACLE_HOME is and ORACLE_SID, you database ID. This script is designed for C shell use. If you are using SH, KSH, BASH, etc. you want to use oraenv. Here is the syntax:

Code:

. /usr/local/bin/oraenv

Notice the period followed by a space.

Since you are creating an instance, your ORACLE_SID with not be found and you will have to specify it and where ORACLE_HOME is located.

Thomas