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 auflsen
> 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
Daniel A. Morgan
>> 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 auflsen
>> 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
-----------------------------------------------Reply-----------------------------------------------
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 auflsen
>>> 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
damor
@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org -----------------------------------------------Reply-----------------------------------------------
Nicolas Bronke schreef:
> 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.
Odd, especially if it worked before.
This being Windows - did you try:
c:>SET ORACLE_SID=your_old_SID
c:>sqlplus / as sysdba
?!? That should work *without* any network config, just the services
running!
> 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
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
