Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Personal Oracle 7.3.4. on Win98
With the wrong value in the registry, and not specifying the
right one during connect, the software was trying to start up an SGA for a
database which does not exist.
Solution
1. Run REGEDT32 and go to HKEY_Local_Machine on Local_Machine. 2. Got to Software. 3. Go to Oracle. 4. Look for ORACLE_SID and verify it is set to the SID to which the you aretrying to connect. If not, double click on ORACLE_SID and modify the string.
You can only connect using this designation if you are using Oracle7 and SQL*Net version 2.x. This is not valid for Oracle8 and NET8 configurations.
I hope this of any help.
Regards
"The Views expressed here are my own and not necessarily those of Oracle Corporation"
Grigor Coric <grigor.coric_at_lijanovici.com> wrote in message
news:7mctnq$k94$1_at_as102.tel.hr...
> Hi!
>
> When I try to connect to local database from SQL*Plus, I get the following
> errors:
> ERROR: ORA-01034: ORACLE not available
> ORA-09243: smsget: error attaching to SGA
> OSD-04101: invalid SGA: SGA not initialized
>
>
> Does anybody know what might be the problem?
> Does Personal Oracle 7 for Windows 95 works on Windows 98?
>
> --
> Grigor Coric /grigor.coric_at_lijanovici.com/
> Zagreb, Croatia
>
>
Received on Mon Jul 19 1999 - 10:44:47 CDT