Nicolas Bronke wrote:
>>> After I installed on Oracle 10g 2.0.2 the patch to 2.0.3 I cannot
>>> access anymore to the previous installed instance. The Listener tells me
>>>
>>> ORA-12514: TNS:Listener konnte in Verbindungsdeskriptor angegebenen
>>> SERVICE_NAME nicht auflösen
>>>
>>> and I cannot find why? If I am installing a new instance everything
>>> works fine. (but not the old instance)
>>>
>>> Can someone help me?
>>>
>>> Thank you
>>> Nicolas
>>
>> Operating system?
>
>> ORACLE_BASE?
>> ORACLE_HOME?
>> ORACLE_SID?
>> TNSPING?
>
> The Operating System win Windows 2003
> Meanwhile I found a hint an information on the internet, that explains,
> that the listener.ora has to be reconfigured and yes the entry of my
> database was lost. :-(
>
> But after I reconfigured it, I could see that the database is not startet
>
> ERROR: : ORA-01034: ORACLE not available : ORA-27101: shared memory
> realm does not exist
>
> I also could not login with sys as sysdba, it tells me insufficient
> privileges.
>
> Does exist any recommendation? Meanwhile I created another instance,
> which is working fine, but I would like to get the old instance running
> again.
>
> Kind regards
> Nicolas
Use ORADIM to drop and recreate OracleService<SID>.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Apr 26 2007 - 09:32:24 CDT
