Re: Help me - Urgent - Oracle connection on Solaris 2.5.1

In article <01bddc3b$92af8700$3b6217c3_at_zeus>,   "Joćo Carlos Palmela Pinheiro Caldeira" <ip218083_at_ip.pt> wrote:
> I have installed Oracle 7.3.4 on Solaris 2.5.1.
> when i tried to do:
>
> -> tnsping ORCL (database instance) this fails.
>
> when i tried to do :
>
> -> svrmgrl
> connect internal
> i get this message (You can not connect to an idle database)
>
> The instance is not running, i know that, but what do i have to do
> to put it running from SHELL command line.
>
> I look up to the listener.ora and tnsnames.ora files but i think everything
> is ok.
> Do i have to add any service to the /etc/services file ?
>
> Please give me an example how to do it from the begining, or send me some
> sample files (services, listener.ora, tnsnames.ora)
>
> My hostname is -> dog
> ORACLE_SID -> ORCL
>
> give me an example
>
> mail ip218083_at_ip.pt
>
>

seems as if there is no ORACLE_SID and/or ORACLE_HOME entry in your .profile you have to change the /var/opt/oracle/oratab file and set the last param of your db instance to Y. this will start the db automatically if you give the command dbstart at the prompt when logging in as oracle (or whatever is the name of the oracle owner). dbshut in term closes all db“s having the Y set. Next you have to configure the /var/opt/oracle/listener.ora and tnsnames.ora. they must have valid entries for your ORACLE_SID. After that start the listerner with "lsnrctl start" at the oracle owner prompt. Now you should be able to do a tnsping ORCL

The svrmgrl message is likely due to the missing ORACLE_SID Parameter. You can test if it is set giving the command
env | grep ORACLE_SID

hope this helps
Andy

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 01 1998 - 03:30:07 CDT