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