TNS-12514 After Installation of MYSQL
Heya,
I have got an Oracle 11gR2 Installation running, with APEX 4.1.2 on top of it.
Everything went well, and today I am returning from the holiday and the Oracle Database isn't available.
Alertlog tells me:
<msg time='2012-09-03T18:18:09.869+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='SRV02-CLEARIT'
host_addr='fe80::513c:a8ac:96f0:3b05%11'>
<txt>TNS-12514: TNS: Listener kann in Connect-Deskriptor angegebenen Service aktuell nicht auflösen
</txt>
</msg>
------------------------------------
LSNRCTL
------------------------------------
LSNRCTL> status
Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS des LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Startdatum 03-SEP-2012 18:12:35
Uptime 0 Tage 0 Std. 19 Min. 23 Sek.
Trace-Ebene off
Sicherheit ON: Local OS Authentication
SNMP OFF
Parameterdatei des Listener D:\app\Service.Intern\product\11.2.0\dbhome_1\network\admin\listener.ora
Log-Datei des Listener d:\app\service.intern\diag\tnslsnr\SRV02-CLEARIT\liste
ner\alert\log.xml
Zusammenfassung Listening-Endpunkte...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=[server].[domain].local)(PORT=1521)))
Services ▄bersicht...
Dienst "CLRExtProc" hat 1 Instanzen.
---------------------------------------------
Everytime it try to startup the database:
---------------------------------------------
C:\Users\Service.Intern>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mo Sep 3 18:35:56 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn sys as sysdba
Kennwort eingeben:
Bei einer nicht hochgefahrenen Instanz angemeldet.
SQL> startup;
ORACLE-Instanz hochgefahren.
Total System Global Area 3323752448 bytes
Fixed Size 2180304 bytes
Variable Size 2734689072 bytes
Database Buffers 570425344 bytes
Redo Buffers 16457728 bytes
Datenbank mounted.
ORA-03113: Unerwartetes ▄bertragungsende in Kommunikation
Prozess-ID: 6588
Session-ID: 88 Seriennummer: 3
So what am I doing wrong? Suddenly the HTTP prasentation listener is gone AND even if I am able to connect via enterprise manager, the database is not able to startup.
When I was on holiday someone installed a MYSQL Installation on the same machine.
any advice?
Thank you.
Edited by: roman on 03.09.2012 10:42