| 1 |
On Thursday 29 June 2006 01:32, pat wrote: |
| 2 |
> Thanks for your advice. I've finished the configuration, but I have a |
| 3 |
> problems :-\ |
| 4 |
> |
| 5 |
> The installation was like this: |
| 6 |
> 1) oracle 10gR2 - I've followed the |
| 7 |
> http://www.akadia.com/services/ora_linux_install_10g.html |
| 8 |
> 2) I've followed the suggested page |
| 9 |
> |
| 10 |
> I'm able to start dbora script and lsnrora like this: |
| 11 |
> ***** |
| 12 |
> korin ~ # /etc/init.d/dbora start |
| 13 |
> * Starting Oracle ... |
| 14 |
> [ ok ] |
| 15 |
It should be more verbose, it encounters no error nonetheless it doesn't |
| 16 |
start: you should see something like: |
| 17 |
|
| 18 |
chroot32 / #/etc/init.d/dbora start |
| 19 |
Starting Oracle: |
| 20 |
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 29 18:53:08 2006 |
| 21 |
|
| 22 |
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. |
| 23 |
|
| 24 |
SQL> Connected to an idle instance. |
| 25 |
SQL> ORACLE instance started. |
| 26 |
|
| 27 |
Total System Global Area 236000356 bytes |
| 28 |
Fixed Size 451684 bytes |
| 29 |
Variable Size 201326592 bytes |
| 30 |
Database Buffers 33554432 bytes |
| 31 |
Redo Buffers 667648 bytes |
| 32 |
Database mounted. |
| 33 |
Database opened. |
| 34 |
SQL> Disconnected from Oracle9i Release 9.2.0.4.0 - Production |
| 35 |
JServer Release 9.2.0.4.0 - Production |
| 36 |
Database "ffmr" warm started. |
| 37 |
|
| 38 |
chroot32 / #echo $ORACLE_SID |
| 39 |
ffmr |
| 40 |
|
| 41 |
as you can see the database ffmr is started |
| 42 |
|
| 43 |
> korin ~ # /etc/init.d/lsnrora start |
| 44 |
> * Start Oracle Listeners ... |
| 45 |
> |
| 46 |
> LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2006 |
| 47 |
> 01:20:17 |
| 48 |
> |
| 49 |
> Copyright (c) 1991, 2005, Oracle. All rights reserved. |
| 50 |
> |
| 51 |
> Starting /opt/oracle/product/10.2.0.1.0/bin/tnslsnr: please wait... |
| 52 |
> |
| 53 |
> TNSLSNR for Linux: Version 10.2.0.1.0 - Production |
| 54 |
> System parameter file is |
| 55 |
> /opt/oracle/product/10.2.0.1.0/network/admin/listener.ora Log |
| 56 |
> messages written to |
| 57 |
> /opt/oracle/product/10.2.0.1.0/network/log/listener.log Listening on: |
| 58 |
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: |
| 59 |
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) |
| 60 |
> |
| 61 |
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) |
| 62 |
> STATUS of the LISTENER |
| 63 |
> ------------------------ |
| 64 |
> Alias LISTENER |
| 65 |
> Version TNSLSNR for Linux: Version 10.2.0.1.0 - |
| 66 |
> Production Start Date 29-JUN-2006 01:20:17 |
| 67 |
> Uptime 0 days 0 hr. 0 min. 0 sec |
| 68 |
> Trace Level off |
| 69 |
> Security ON: Local OS Authentication |
| 70 |
> SNMP OFF |
| 71 |
> Listener Parameter File |
| 72 |
> /opt/oracle/product/10.2.0.1.0/network/admin/listener.ora |
| 73 |
> Listener Log File |
| 74 |
> /opt/oracle/product/10.2.0.1.0/network/log/listener.log Listening |
| 75 |
> Endpoints Summary... |
| 76 |
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) |
| 77 |
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) |
| 78 |
> Services Summary... |
| 79 |
> Service "PLSExtProc" has 1 instance(s). |
| 80 |
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this |
| 81 |
> service... The command completed successfully |
| 82 |
|
| 83 |
Here too it's lacking a reference to the SID: |
| 84 |
|
| 85 |
chroot32 / #/etc/init.d/lsnrora start |
| 86 |
Starting Oracle Listeners: |
| 87 |
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 29-JUN-2006 |
| 88 |
18:51:52 |
| 89 |
|
| 90 |
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. |
| 91 |
|
| 92 |
Starting /oracle92/product/9.2.0/bin/tnslsnr: please wait... |
| 93 |
|
| 94 |
TNSLSNR for Linux: Version 9.2.0.4.0 - Production |
| 95 |
System parameter file |
| 96 |
is /oracle92/product/9.2.0/network/admin/listener.ora |
| 97 |
Log messages written to /oracle92/product/9.2.0/network/log/listener.log |
| 98 |
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) |
| 99 |
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0) |
| 100 |
(PORT=1521))) |
| 101 |
|
| 102 |
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) |
| 103 |
STATUS of the LISTENER |
| 104 |
------------------------ |
| 105 |
Alias LISTENER |
| 106 |
Version TNSLSNR for Linux: Version 9.2.0.4.0 - |
| 107 |
Production |
| 108 |
Start Date 29-JUN-2006 18:51:52 |
| 109 |
Uptime 0 days 0 hr. 0 min. 0 sec |
| 110 |
Trace Level off |
| 111 |
Security OFF |
| 112 |
SNMP OFF |
| 113 |
Listener Parameter |
| 114 |
File /oracle92/product/9.2.0/network/admin/listener.ora |
| 115 |
Listener Log |
| 116 |
File /oracle92/product/9.2.0/network/log/listener.log |
| 117 |
Listening Endpoints Summary... |
| 118 |
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) |
| 119 |
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) |
| 120 |
Services Summary... |
| 121 |
Service "PLSExtProc" has 1 instance(s). |
| 122 |
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this |
| 123 |
service... |
| 124 |
Service "ffmr" has 1 instance(s). |
| 125 |
Instance "ffmr", status UNKNOWN, has 1 handler(s) for this service... |
| 126 |
The command completed successfully |
| 127 |
|
| 128 |
Indeed, a bunch of spawned processes prove it! |
| 129 |
|
| 130 |
chroot32 / #ps fxa | grep 'ff[m]r' |
| 131 |
10582 ? Ss 0:00 ora_pmon_ffmr |
| 132 |
10584 ? Ss 0:00 ora_dbw0_ffmr |
| 133 |
10586 ? Ss 0:00 ora_lgwr_ffmr |
| 134 |
10588 ? Ss 0:00 ora_ckpt_ffmr |
| 135 |
10590 ? Ss 0:00 ora_smon_ffmr |
| 136 |
10592 ? Ss 0:00 ora_reco_ffmr |
| 137 |
10594 ? Ss 0:00 ora_cjq0_ffmr |
| 138 |
10596 ? Ss 0:00 ora_qmn0_ffmr |
| 139 |
10598 ? Ss 0:00 ora_s000_ffmr |
| 140 |
10600 ? Ss 0:00 ora_d000_ffmr |
| 141 |
|
| 142 |
> ***** |
| 143 |
> |
| 144 |
> But when I try to access the DB I'm receiving this: |
| 145 |
> ***** |
| 146 |
> korin ~ # /mnt/data/.home/st0rm $ sqlplus test |
| 147 |
> |
| 148 |
> SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 29 01:21:01 2006 |
| 149 |
> |
| 150 |
> Copyright (c) 1982, 2005, Oracle. All rights reserved. |
| 151 |
> |
| 152 |
> Enter password: |
| 153 |
> ERROR: |
| 154 |
> ORA-01034: ORACLE not available |
| 155 |
> ORA-27101: shared memory realm does not exist |
| 156 |
> Linux Error: 2: No such file or directory |
| 157 |
> ***** |
| 158 |
> |
| 159 |
> Did I missed something ??? When I installed the oracle I was able to |
| 160 |
> create database etc. |
| 161 |
|
| 162 |
Maybe you just overlooked /etc/oratab: |
| 163 |
|
| 164 |
chroot32 / #grep 'ffmr' /etc/oratab |
| 165 |
ffmr:/oracle92/product/9.2.0:Y |
| 166 |
|
| 167 |
You have to edit it to have the uppercase "Y" as in "yes!" |
| 168 |
|
| 169 |
> Please, could you help me ??? |
| 170 |
> |
| 171 |
> Thanks a lot |
| 172 |
> |
| 173 |
> Pat |
| 174 |
Cheers |
| 175 |
Francesco |
| 176 |
-- |
| 177 |
Linux Version 2.6.17-gentoo, Compiled #2 PREEMPT Tue Jun 20 20:17:15 |
| 178 |
CEST 2006 |
| 179 |
One 2.2GHz AMD Athlon 64 Processor, 2GB RAM, 4410.79 Bogomips Total |
| 180 |
aemaeth |
| 181 |
-- |
| 182 |
gentoo-user@g.o mailing list |
Archives