By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,885 Members | 1,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,885 IT Pros & Developers. It's quick & easy.

How to start ? client & database.

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Jul 19 '05 #2

P: n/a
Hans Forbrich <fo******@yahoo.net> wrote in message news:<hOaqc.11435$RM.3408@edtnps89>...
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).
Jul 19 '05 #3

P: n/a
GQ
go*****@yahoo.com (Arun Goel) wrote in message news:<7e**************************@posting.google. com>...
Hans Forbrich <fo******@yahoo.net> wrote in message news:<hOaqc.11435$RM.3408@edtnps89>...
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.
Jul 19 '05 #4

P: n/a
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
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.