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
--
[email protected] mailing list
