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
