Re: Post installation problem on oracle 8.15 in solaris 2.6

From: Kenny Lim <kennylim_at_earthlink.net>
Date: 2000/05/23
Message-ID: <serW4.24601$S31.490101_at_newsread2.prod.itd.earthlink.net>#1/1

Kenneth,

[Quoted] [Quoted] First of all, Many thanks for your time and advise !

[Quoted] I had added all the neccesary parameters to the environment in /var/opt/oracle/oratab but did not have any luck in the beginnig.
(added all the path as suggested from oracle doc's, ie.
oracle_base, oracle_home, ldlibrary_path, path, class_path and etc..)

So I tried to manually declare the path to the environment.

ORACLE_PATH=/export/home/Orahome1
export ORACLE_PATH

ORACLE_SID=ORCL
export ORACLE_SID

and was then able to start svrmgrl without receiving the generic error messages
that I had initially reported.

Q1.# Do you by anychance know where I can save the following 2 environment permanently
and do not have to declare the path on every new login session aside from oratab ? would it be ./profile ? if so, does this specify script resides
in the user created default directory ?

---

---

[Quoted] I was then only able to start my instance provided if I specify the path to the initorcl.ora
[Quoted] startup pfile=/export/home/Orahome1/dbs/initorcl.ora

(It seems to default to the sample init.ora file which causes it to error
out since it's loading the wrong control files)

Q2.# Is this normal ? or once again, I might had missed out something in the environment settings.

---

---

[Quoted] Upon starting up the instances and the lsnrctl, I was able only able to perform a direct login.
./sqlplus system/manager

If I attempt to login via the db alias name ./sqlplus system/manager_at_sparc5

I receive the following error message :
ora-01034 ORACLE not available.

#This kinda bummed me out this I will not be able to connect from a remote client.

After reading the documentation, this are the possible factor that might causes the problem :

(a) Oracle was not started - (I was able to mount and start the instance, so
this factor should probably
be eliminated)

[Quoted] (a) SGA requires more memory - I currently have 128 meg of RAM but the only
apps that are
[Quoted] runinng is the OS itself and Oracle.

(c) The OS variable pointing to the instance is improperly defined.
<---could this be the problem ?

Please bare with my lack of knowledge in the unix environment and any advise would be greatly
[Quoted] appreciated provided if you have a brief moment to spare.

Thanks again Kenneth and you have a pleasant day !

Kenny-

Before you can log in with svrmgrl you must set ORACLE_SID to the sid that was created (look in /var/opt/oracle/oratab) and you must also have ORACLE_HOME set to the base directory for oracle - you can also get this from /var/opt/oracle/oratab. Once you do that you should be able to log in with svrmgrl. According to Oracle, however, you should be using sqlplus to log in and forget that svrmgrl is even there.

It probably would have been better if you had actually had an Oracle DBA do the installation.

"Kenneth C Stahl" <BlueSax_at_Unforgettable.com> wrote in message news:39296833.5CF91C08_at_Unforgettable.com...

> Kenny Lim wrote:
> >
> > Hi,
> >
[Quoted] [Quoted] > > I am a newbie to sun solaris and are having some problem after the
> > "post" installation of oracle 8.15 on sun solaris 2.6 (sun sparc 5) as I

 am

[Quoted] > > not able to
[Quoted] [Quoted] > > start or use any of the oracle utilities ie. to startup the
> > instances or listener and able to get it up and running.
> > (this is a fresh installation)
> >
> > My guess is I must had misconfigured the environment variables during

 the
> > process
[Quoted] > > of installation. If anyone can lend me a helping as to how we should fix  the
> > problem,
[Quoted] [Quoted] > > it would be greatly appreacited as I will continure to troubleshoot for  a

> > possible
[Quoted] > > resolution here.
> >
[Quoted] > > Thanks all in advance and you have a pleasant sunday.
> >
> > Kenny-
> >
>
> Before you can log in with svrmgrl you must set ORACLE_SID to the sid
> that was created (look in /var/opt/oracle/oratab) and you must also have
> ORACLE_HOME set to the base directory for oracle - you can also get this
> from /var/opt/oracle/oratab. Once you do that you should be able to log
> in with svrmgrl. According to Oracle, however, you should be using
> sqlplus to log in and forget that svrmgrl is even there.
>
> It probably would have been better if you had actually had an Oracle DBA
> do the installation.
>

Received on Tue May 23 2000 - 00:00:00 CEST