Re: Post installation problem on oracle 8.15 in solaris 2.6

If you are able to do a direct login, but not through the alias. The problem is either with your listener, or your tnsnames.ora file

I suspect, the problem to be the SID entry in the tnsnames.ora file.

--
[Quoted] Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Kenny Lim" <kennylim_at_earthlink.net> wrote in message
news:serW4.24601$S31.490101_at_newsread2.prod.itd.earthlink.net...


>

> Kenneth,


>

> First of all, Many thanks for your time and advise !

>

> 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 ?

>

> --------------------------------------------------------------------------

 --


> ------------------------------


>

> I was then only able to start my instance provided if I specify the path

 to


> the initorcl.ora

> 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.

>

> --------------------------------------------------------------------------

 --


> ---------------------------------


>

> 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)


>

> (a) SGA requires more memory - I currently have 128 meg of RAM but the

 only


> apps that are


> 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


> 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,

> > >

> > > 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


> > > not able to

> > > 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

> > > of installation. If anyone can lend me a helping as to how we should

 fix
 the


> > > problem,

> > > it would be greatly appreacited as I will continure to troubleshoot

 for
 a


> > > possible

> > > resolution here.

> > >

> > > 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.

> >

>

>