[gentoo-user] rc script to start Oracle

[gentoo-user] rc script to start Oracle

[pat]

Hi,

I've successfully installed the OracleDB 10gR2 and I want to start it at boot.
Are there any rc startup scripts ???

Thanks a lot.

     Pat
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] rc script to start Oracle

[Teresa and Dale]

pat wrote:

>Hi,
>
>I've successfully installed the OracleDB 10gR2 and I want to start it at boot.
>Are there any rc startup scripts ???
>
>Thanks a lot.
>
>     Pat
>  
>

Do you mean rc-update?  rc-update add oracle default

Dale
:-)
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] rc script to start Oracle

[pat]

There are not rc scripts in the /etc/init.d - I've installed the Oracle using
the installation notes in Gentoo wiki. There's not noted where to get the rc
scripts or how to create them.

     Pat

On Sat, 24 Jun 2006 18:55:18 -0500, Teresa and Dale wrote
> pat wrote:
> 
> >Hi,
> >
> >I've successfully installed the OracleDB 10gR2 and I want to start it at boot.
> >Are there any rc startup scripts ???
> >
> >Thanks a lot.
> >
> >     Pat
> >  
> >
> 
> Do you mean rc-update?  rc-update add oracle default
> 
> Dale
> :-)
> 
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] rc script to start Oracle

[Mark Kirkwood]

Teresa and Dale wrote:
> pat wrote:
> 
>> Hi,
>>
>> I've successfully installed the OracleDB 10gR2 and I want to start it at boot.
>> Are there any rc startup scripts ???
>>
>> Thanks a lot.
>>
>>     Pat
>>  
>>
> 
> Do you mean rc-update?  rc-update add oracle default
> 

Pat might be after the actual oracle startup script - its been a while 
since I used Oracle, but essentially you just need to copy one of the 
existing Gentoo rc scripts and make sure it does:

on start:
  su - oracle -c "dbstart"
  su - oracle -c "lsnrctl start"

On stop:
  #su - oracle -c "dbshut"
  su - oracle "lsnrctl stop"

(Note that dbshut used to be rather stupid, and refuse to terminate 
existing connections, so may just leave it commented out and let the 
oracle server get killed - never hurt it as I recall!)

Cheers

Mark

-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] Re: rc script to start Oracle

[Francesco Talamona]

On Sunday 25 June 2006 00:20, pat wrote:
> Hi,
>
> I've successfully installed the OracleDB 10gR2 and I want to start it
> at boot. Are there any rc startup scripts ???
>
> Thanks a lot.
>
>      Pat

I adapted the script found on akadia website, to run a 9.2.0.4 inside a 
chroot. You may need to edit one for your setup.

This will save you a lot of work:
http://www.akadia.com/services/ora_linux_install_10g.html

HTH
	Francesco
-- 
Linux Version 2.6.17-gentoo, Compiled #2 PREEMPT Tue Jun 20 20:17:15 
CEST 2006
One 1GHz AMD Athlon 64 Processor, 2GB RAM, 2004.90 Bogomips Total
aemaeth
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Re: rc script to start Oracle

[pat]

On Sun, 25 Jun 2006 08:32:41 +0200, Francesco Talamona wrote
> On Sunday 25 June 2006 00:20, pat wrote:
> > Hi,
> >
> > I've successfully installed the OracleDB 10gR2 and I want to start it
> > at boot. Are there any rc startup scripts ???
> >
> > Thanks a lot.
> >
> >      Pat
> 
> I adapted the script found on akadia website, to run a 9.2.0.4 
> inside a chroot. You may need to edit one for your setup.
> 
> This will save you a lot of work:
> http://www.akadia.com/services/ora_linux_install_10g.html
> 
> HTH
> 	Francesco

Thanks for your advice. I've finished the configuration, but I have a problems :-\

The installation was like this:
1) oracle 10gR2 - I've followed the
http://www.akadia.com/services/ora_linux_install_10g.html
2) I've followed the suggested page

I'm able to start dbora script and lsnrora like this:
*****
korin ~ # /etc/init.d/dbora start
 * Starting Oracle ...                                                       
                                                                             
                                                               [ ok ]
korin ~ # /etc/init.d/lsnrora start
 * Start Oracle Listeners ...

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2006 01:20:17

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /opt/oracle/product/10.2.0.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0.1.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0.1.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                29-JUN-2006 01:20:17
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  
/opt/oracle/product/10.2.0.1.0/network/admin/listener.ora
Listener Log File         /opt/oracle/product/10.2.0.1.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
*****

But when I try to access the DB I'm receiving this:
*****
korin ~ #  /mnt/data/.home/st0rm $ sqlplus test

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 29 01:21:01 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
*****

Did I missed something ??? When I installed the oracle I was able to create
database etc.

Please, could you help me ???

Thanks a lot

     Pat
-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] Re: rc script to start Oracle

[Francesco Talamona]

On Thursday 29 June 2006 01:32, pat wrote:
> Thanks for your advice. I've finished the configuration, but I have a
> problems :-\
>
> The installation was like this:
> 1) oracle 10gR2 - I've followed the
> http://www.akadia.com/services/ora_linux_install_10g.html
> 2) I've followed the suggested page
>
> I'm able to start dbora script and lsnrora like this:
> *****
> korin ~ # /etc/init.d/dbora start
>  * Starting Oracle ...
>                                                                [ ok ]
It should be more verbose, it encounters no error nonetheless it doesn't 
start: you should see something like:

chroot32 / #/etc/init.d/dbora start                                                                                                                     
Starting Oracle: 
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 29 18:53:08 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size		     451684 bytes
Variable Size		  201326592 bytes
Database Buffers	   33554432 bytes
Redo Buffers		     667648 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Database "ffmr" warm started.

chroot32 / #echo $ORACLE_SID 
ffmr

as you can see the database ffmr is started

> korin ~ # /etc/init.d/lsnrora start
>  * Start Oracle Listeners ...
>
> LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2006
> 01:20:17
>
> Copyright (c) 1991, 2005, Oracle.  All rights reserved.
>
> Starting /opt/oracle/product/10.2.0.1.0/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 10.2.0.1.0 - Production
> System parameter file is
> /opt/oracle/product/10.2.0.1.0/network/admin/listener.ora Log
> messages written to
> /opt/oracle/product/10.2.0.1.0/network/log/listener.log Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
> STATUS of the LISTENER
> ------------------------
> Alias                     LISTENER
> Version                   TNSLSNR for Linux: Version 10.2.0.1.0 -
> Production Start Date                29-JUN-2006 01:20:17
> Uptime                    0 days 0 hr. 0 min. 0 sec
> Trace Level               off
> Security                  ON: Local OS Authentication
> SNMP                      OFF
> Listener Parameter File
> /opt/oracle/product/10.2.0.1.0/network/admin/listener.ora
> Listener Log File        
> /opt/oracle/product/10.2.0.1.0/network/log/listener.log Listening
> Endpoints Summary...
>   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
>   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
>   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service... The command completed successfully

Here too it's lacking a reference to the SID:

chroot32 / #/etc/init.d/lsnrora start 
Starting Oracle Listeners: 
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 29-JUN-2006 
18:51:52

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /oracle92/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file 
is /oracle92/product/9.2.0/network/admin/listener.ora
Log messages written to /oracle92/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)
(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - 
Production
Start Date                29-JUN-2006 18:51:52
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter 
File   /oracle92/product/9.2.0/network/admin/listener.ora
Listener Log 
File         /oracle92/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this 
service...
Service "ffmr" has 1 instance(s).
  Instance "ffmr", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Indeed, a bunch of spawned processes prove it!

chroot32 / #ps fxa | grep 'ff[m]r'                                                                                                                      
10582 ?        Ss     0:00 ora_pmon_ffmr
10584 ?        Ss     0:00 ora_dbw0_ffmr
10586 ?        Ss     0:00 ora_lgwr_ffmr
10588 ?        Ss     0:00 ora_ckpt_ffmr
10590 ?        Ss     0:00 ora_smon_ffmr
10592 ?        Ss     0:00 ora_reco_ffmr
10594 ?        Ss     0:00 ora_cjq0_ffmr
10596 ?        Ss     0:00 ora_qmn0_ffmr
10598 ?        Ss     0:00 ora_s000_ffmr
10600 ?        Ss     0:00 ora_d000_ffmr

> *****
>
> But when I try to access the DB I'm receiving this:
> *****
> korin ~ #  /mnt/data/.home/st0rm $ sqlplus test
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 29 01:21:01 2006
>
> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
>
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
> *****
>
> Did I missed something ??? When I installed the oracle I was able to
> create database etc.

Maybe you just overlooked /etc/oratab:

chroot32 / #grep 'ffmr'  /etc/oratab                                                                                                                    
ffmr:/oracle92/product/9.2.0:Y

You have to edit it to have the uppercase "Y" as in "yes!"

> Please, could you help me ???
>
> Thanks a lot
>
>      Pat
Cheers
	Francesco
-- 
Linux Version 2.6.17-gentoo, Compiled #2 PREEMPT Tue Jun 20 20:17:15 
CEST 2006
One 2.2GHz AMD Athlon 64 Processor, 2GB RAM, 4410.79 Bogomips Total
aemaeth
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Re: rc script to start Oracle - [SOLVED]

[pat]

Thanks a lot. The problem was in the oratab.

	Pat

Francesco Talamona wrote:
> On Thursday 29 June 2006 01:32, pat wrote:
> 
>>Thanks for your advice. I've finished the configuration, but I have a
>>problems :-\
>>
>>The installation was like this:
>>1) oracle 10gR2 - I've followed the
>>http://www.akadia.com/services/ora_linux_install_10g.html
>>2) I've followed the suggested page
>>
>>I'm able to start dbora script and lsnrora like this:
>>*****
>>korin ~ # /etc/init.d/dbora start
>> * Starting Oracle ...
>>                                                               [ ok ]
> 
> It should be more verbose, it encounters no error nonetheless it doesn't 
> start: you should see something like:
> 
> chroot32 / #/etc/init.d/dbora start                                                                                                                     
> Starting Oracle: 
> SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 29 18:53:08 2006
> 
> Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
> 
> SQL> Connected to an idle instance.
> SQL> ORACLE instance started.
> 
> Total System Global Area  236000356 bytes
> Fixed Size		     451684 bytes
> Variable Size		  201326592 bytes
> Database Buffers	   33554432 bytes
> Redo Buffers		     667648 bytes
> Database mounted.
> Database opened.
> SQL> Disconnected from Oracle9i Release 9.2.0.4.0 - Production
> JServer Release 9.2.0.4.0 - Production
> Database "ffmr" warm started.
> 
> chroot32 / #echo $ORACLE_SID 
> ffmr
> 
> as you can see the database ffmr is started
> 
> 
>>korin ~ # /etc/init.d/lsnrora start
>> * Start Oracle Listeners ...
>>
>>LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2006
>>01:20:17
>>
>>Copyright (c) 1991, 2005, Oracle.  All rights reserved.
>>
>>Starting /opt/oracle/product/10.2.0.1.0/bin/tnslsnr: please wait...
>>
>>TNSLSNR for Linux: Version 10.2.0.1.0 - Production
>>System parameter file is
>>/opt/oracle/product/10.2.0.1.0/network/admin/listener.ora Log
>>messages written to
>>/opt/oracle/product/10.2.0.1.0/network/log/listener.log Listening on:
>>(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on:
>>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
>>
>>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
>>STATUS of the LISTENER
>>------------------------
>>Alias                     LISTENER
>>Version                   TNSLSNR for Linux: Version 10.2.0.1.0 -
>>Production Start Date                29-JUN-2006 01:20:17
>>Uptime                    0 days 0 hr. 0 min. 0 sec
>>Trace Level               off
>>Security                  ON: Local OS Authentication
>>SNMP                      OFF
>>Listener Parameter File
>>/opt/oracle/product/10.2.0.1.0/network/admin/listener.ora
>>Listener Log File        
>>/opt/oracle/product/10.2.0.1.0/network/log/listener.log Listening
>>Endpoints Summary...
>>  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
>>  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
>>Services Summary...
>>Service "PLSExtProc" has 1 instance(s).
>>  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
>>service... The command completed successfully
> 
> 
> Here too it's lacking a reference to the SID:
> 
> chroot32 / #/etc/init.d/lsnrora start 
> Starting Oracle Listeners: 
> LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 29-JUN-2006 
> 18:51:52
> 
> Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
> 
> Starting /oracle92/product/9.2.0/bin/tnslsnr: please wait...
> 
> TNSLSNR for Linux: Version 9.2.0.4.0 - Production
> System parameter file 
> is /oracle92/product/9.2.0/network/admin/listener.ora
> Log messages written to /oracle92/product/9.2.0/network/log/listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)
> (PORT=1521)))
> 
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
> STATUS of the LISTENER
> ------------------------
> Alias                     LISTENER
> Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - 
> Production
> Start Date                29-JUN-2006 18:51:52
> Uptime                    0 days 0 hr. 0 min. 0 sec
> Trace Level               off
> Security                  OFF
> SNMP                      OFF
> Listener Parameter 
> File   /oracle92/product/9.2.0/network/admin/listener.ora
> Listener Log 
> File         /oracle92/product/9.2.0/network/log/listener.log
> Listening Endpoints Summary...
>   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
>   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
>   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this 
> service...
> Service "ffmr" has 1 instance(s).
>   Instance "ffmr", status UNKNOWN, has 1 handler(s) for this service...
> The command completed successfully
> 
> Indeed, a bunch of spawned processes prove it!
> 
> chroot32 / #ps fxa | grep 'ff[m]r'                                                                                                                      
> 10582 ?        Ss     0:00 ora_pmon_ffmr
> 10584 ?        Ss     0:00 ora_dbw0_ffmr
> 10586 ?        Ss     0:00 ora_lgwr_ffmr
> 10588 ?        Ss     0:00 ora_ckpt_ffmr
> 10590 ?        Ss     0:00 ora_smon_ffmr
> 10592 ?        Ss     0:00 ora_reco_ffmr
> 10594 ?        Ss     0:00 ora_cjq0_ffmr
> 10596 ?        Ss     0:00 ora_qmn0_ffmr
> 10598 ?        Ss     0:00 ora_s000_ffmr
> 10600 ?        Ss     0:00 ora_d000_ffmr
> 
> 
>>*****
>>
>>But when I try to access the DB I'm receiving this:
>>*****
>>korin ~ #  /mnt/data/.home/st0rm $ sqlplus test
>>
>>SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 29 01:21:01 2006
>>
>>Copyright (c) 1982, 2005, Oracle.  All rights reserved.
>>
>>Enter password:
>>ERROR:
>>ORA-01034: ORACLE not available
>>ORA-27101: shared memory realm does not exist
>>Linux Error: 2: No such file or directory
>>*****
>>
>>Did I missed something ??? When I installed the oracle I was able to
>>create database etc.
> 
> 
> Maybe you just overlooked /etc/oratab:
> 
> chroot32 / #grep 'ffmr'  /etc/oratab                                                                                                                    
> ffmr:/oracle92/product/9.2.0:Y
> 
> You have to edit it to have the uppercase "Y" as in "yes!"
> 
> 
>>Please, could you help me ???
>>
>>Thanks a lot
>>
>>     Pat
> 
> Cheers
> 	Francesco

-- 
gentoo-user@gentoo.org mailing list