How to start ? client & database.

[Arun Goel]

I have installed Oracle client & Oracle database(9.2.0. 4) on Red Hat
9.0.
It seems to me everything went fine in installation as I followed
notes from http://www.puschitz.com/InstallingOracle9i.shtml.

But now I don't see any instructions somewhere which can explain me
how to start my client?

And how to start my database?

Any help will be apreciated.

Thanks
Arun

[Hans Forbrich]

Arun Goel wrote:

I have installed Oracle client & Oracle database(9.2.0. 4) on Red Hat
9.0.
It seems to me everything went fine in installation as I followed
notes from http://www.puschitz.com/InstallingOracle9i.shtml.

But now I don't see any instructions somewhere which can explain me
how to start my client?

And how to start my database?

Any help will be apreciated.

Thanks
Arun

Client doesn't get 'started'. Client is a program that, when run, will
communicate with Oracle Networking (aka Net8, SQL*Net).

Typical clients are SQL*Plus, Enterprise Manager, Java/C/C++/.net programs

Suggest you browse around http://otn.oracle.com/obe for some tutorial
material and around http://docs.oracle.com for the Oracle Concepts manual
to help get this cleared up.

Another fine resource is the Red Hat install guide that Howard put up at
http://www.dizwell.com

/Hans

[Arun Goel]

Hans Forbrich <fo******@yahoo .net> wrote in message news:<hOaqc.114 35$RM.3408@edtn ps89>...

Arun Goel wrote:

I have installed Oracle client & Oracle database(9.2.0. 4) on Red Hat
9.0.
It seems to me everything went fine in installation as I followed
notes from http://www.puschitz.com/InstallingOracle9i.shtml.

But now I don't see any instructions somewhere which can explain me
how to start my client?

And how to start my database?

Any help will be apreciated.

Thanks
Arun

Client doesn't get 'started'. Client is a program that, when run, will
communicate with Oracle Networking (aka Net8, SQL*Net).

Typical clients are SQL*Plus, Enterprise Manager, Java/C/C++/.net programs

Suggest you browse around http://otn.oracle.com/obe for some tutorial
material and around http://docs.oracle.com for the Oracle Concepts manual
to help get this cleared up.

Another fine resource is the Red Hat install guide that Howard put up at
http://www.dizwell.com

/Hans

Ok. Probably I asked wrong question. I want to how to 'run' client
program (I installed from Oracle 9.2.0 distribution).

[GQ]

go*****@yahoo.c om (Arun Goel) wrote in message news:<7e******* *************** ****@posting.go ogle.com>...

Hans Forbrich <fo******@yahoo .net> wrote in message news:<hOaqc.114 35$RM.3408@edtn ps89>...

Arun Goel wrote:

I have installed Oracle client & Oracle database(9.2.0. 4) on Red Hat
9.0.
It seems to me everything went fine in installation as I followed
notes from http://www.puschitz.com/InstallingOracle9i.shtml.

But now I don't see any instructions somewhere which can explain me
how to start my client?

And how to start my database?

Any help will be apreciated.

Thanks
Arun

Client doesn't get 'started'. Client is a program that, when run, will
communicate with Oracle Networking (aka Net8, SQL*Net).

Typical clients are SQL*Plus, Enterprise Manager, Java/C/C++/.net programs

Suggest you browse around http://otn.oracle.com/obe for some tutorial
material and around http://docs.oracle.com for the Oracle Concepts manual
to help get this cleared up.

Another fine resource is the Red Hat install guide that Howard put up at
http://www.dizwell.com

/Hans

Ok. Probably I asked wrong question. I want to how to 'run' client
program (I installed from Oracle 9.2.0 distribution).

First - The environment variables you had to set to install the software,
should also be set to use a client application (simpler this way).
You can set these in the .profile or by a shell script;
ORACLE_BASE= <something like /u01/app/oracle>
ORACLE_HOME= <something like /u01/app/oracle/product/9i2>
TNS_ADMIN= <something like /u01/app/oracle/product/9i2/network/admin>
ORACLE_SID= <something like MYDB1>
and the user path should include ORACLE_HOME/bin

If the database is on the same box, setting ORACLE_SID could be sufficient,
if you do not specify it in the connect string. To cover all bases, you
should however add an entry in the tnsnames.ora file for your database.

Try 'tnsping sid' where sid is the database name,
to confirm that your tnsnames.ora file is properly configured (if you need it).

Second - If your path is properly set, you should be able to do the following...
Note that before using the client, the database must be up.
You can do this manually (once all the environment variables are set) by ...
sqlplus /nolog
connect internal
startup

I hope this help.

[Hans Forbrich]

Arun Goel wrote:

Ok. Probably I asked wrong question. I want to how to 'run' client
program (I installed from Oracle 9.2.0 distribution).

Well .....

What kind of client program do you have that you want to run? Better yet,
What are you trying to do?

If your objective is to learn Oracle as a developer or DBA, then look at
http://otn.oracle.com/obe for some step by step tutorials (with screen
shots).

If your objective is to do 'Microsoft Access programming in Oracle', then
brace yourself - it's a whole new world and, even for brilliant people, it
ain't gonna be pretty.

You should do a bit of reading as well - start with an easy to read book
like 'Oracle Essentials' from http://www.oreilly.com/catalog/oressentials3/

I DID mention that you should look at the 'install on Red Hat' document at
http://www.dizwell.com ... you apparently did not do that. Howard's
document is more on the order of a kick-start tutorial than an install
manual. Mandatory!

But to answer your question - Oracle provides some client software, one of
the simplest being SQLPLUS. Check out http://docs.oracle.com and drill
into the version you've installed to get the SQLPlus User Guide and
Reference manual.

/Hans