Re: newbie question

"Valentine Gogichashvili" <valgog_at_biofrontera.de> wrote in message news:3e6cb4f3$1_at_news.piro.net...
> To say the truth, is will be faster for you to read the Administration
Guide
> first :) but I will try to answer some questions of yours :-)
>
> > I have been working with SQL Server 6.5 and 2000 for about 3 years
and
> > starting to use oracle (installed it the weekend) and encountered a few
> > problems (I'm sorry if these seem stupid questions but I am new to
> > Oracle) -- 9i release 2 redhat linux 8 ---
> >
> >
> >
> > 1.- I install oracle OK (create the groups, the oracle user, tweak
> > memory of kernel) but when I tried to connect with SQLPLUS I get a
Oracle
> > not available. So I configured another port with Oracle network
> > configuration and It now connect ok. Is this normal or something going
> > wrong?
>
> For sqlplus to connect it first needs to know wich instance it connects
to.
> So you have to set the environment variable ORACLE_SID for that.
> It also can use the tnsname that is stored in
> ${ORACLE_HOME}/network/admin/tnsnames.ora
>
> firt try to "tnsping" the instance

small, but not insignificant correction. TNSPING does not ever communicate with the INSTANCE it talks to the LISTENER to see if it knows a way to connect to the instance. This is of course why a successful tnsping does not guarantee a successful db connection.

> > 3.- I hear there is an Oracle Enterprise manager (like SQL Server's
> one)
> > where is it located?, I looked in the bin directory and can't find it (I
> > installed the database and client tools of the oracle 9i2 cd's)
>
> it is usually installed by default. As it is the java aplication you
should
> run it using "oemapp" application.

Don't expect OEM to have the functionality/usability of the SQL Server offering. :(

> > 4.- Is there any (integrated or third party) tools to create stored
> > procedures like SQL server's query analyzer, is there any tool like SQL
> > Server's profiler.
>
> You will find everything in Enterprise Manager :-)

Creating code can be done through OEM, You might want to take a look at JDeveloper from OTN if you want a proper GUI. There isn't a GUI equivalent of SQL Profiler. You can either install the OEM Management packs which give you a utility called Oracle Expert which does some of the job, or - for a closer equivalent - trace individual sessions and use a command line utility called TKPROF to obtain explain plan/wait etc information.

--
Niall Litchfield
Oracle DBA
Audit Commission UK