Re: Post installation problem on oracle 8.15 in solaris 2.6

From: Kenny Lim <kennylim_at_techie.com>
Date: 2000/05/23
Message-ID: <QpBW4.257$YK5.2875@dfw-read.news.verio.net>#1/1

Thanks for the pointers, it seems like the problem derived from ORACLE_SID. I am now able to connect via the dbalias name on my sun solaris machine.

One questions though, I am running into the same problem when attempting to connect via the client utilities on a NT workstation machine.

ERROR:
ORA-01034: ORACLE not available

# I was able to tnsping to the sun boxes via the NT machine.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=sun)(PORT=1521)) OK (20 msec)

The funny thing is that i was also able to connect to our Linux (redhat 6.1) running
oracle 8.05 through our NT boxes using oracle client utilities and not to the
sun solaris box. (Oracle 8.15)

#enclosed here is the tnsnames for the sun box.

SPARC5 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = SUN)(PORT = 1521))     )
(CONNECT_DATA =

      (SID = ORCL)
    )
  )

Do you by anychance had run into the same problem before ? Any pointers would be greatly appreciated.

Thanks in advance and you have a pleasant day.

Kenny-

"Kenny Lim" <kennylim_at_earthlink.net> wrote in message news:YtUV4.14924$T41.346110_at_newsread1.prod.itd.earthlink.net...

> 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

> 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-
>
> installation steps :
>
> #please let me know if you need more explicit information.
>
> 1. create user oracle
> 2. create group osdba
> 3. set the following environment variables
>
> $display=workstation_name:0.0
> (ie. display=sparc5:0.0)
>
> xhost + server_machine_name
> (xhost +sparc5)   <----#this can only be done when logging as root user

and

> not oracle.
>                                   If login as oracle, it will complain '
> file not found' error.
>
> 4. mount cdrom and invoke the oracle installer.
>    ./runInstaller
>
> (a)  perform minimal installation for oracle instead of standard or

custom.

> (b)  install pre-configured database and setting up listener.
>
> 5. login as root and run root.sh script in the installed oracle home
> directory and
>     not from the cdrom.
>
> # all the setup and installation works fine.
>
> 6. problem :
>
> #when trying to startup svrmgrl, I received the following error.
>
> $./svrmgrl
> Oracle Server Manager Release 3.1.5.0.0 - Production
> Message 4505 not found; No message file for product=SVRMGR, facility=MGR
> Error while trying to retrieve text for error ORA-12571
>
> #When attempting to connect as internal, I received the following error.
>
> SVRMGR> connect internal/oracle_at_orcl
> Error while trying to retrieve text for error ORA-12154
>
> #When exit svrmgrl, I received the following error.
>
> Message 37 not found; No message file for product=SVRMGR, facility=MGR
>
> # I had also tried to reset the root.sh pointing to the dedault usr/local
> bin and also orachome bin directory but both settings did not help in

terms

> of getting the utilities to run.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

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