Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…

Database design migration from SQL Server to Oracle by Enterprise Architect

Background: One of my development project initially was on SQL Server as backend database. But consistently facing problem of ‘ODBC failed to connect’ throughout a year. The database was the SQL Server XE. Convinced to transfer my database to Oracle as it is very reliable on ODBC connection. So intended to initiate a database design migration from…

Oracle Error: No listener – LISTENER failing to start upon windows startup

Case: Today morning on my development machine (Windows 10 ) I can’t login to the oracle schema with toad or from my application showing Oracle Error : No listener. Upon further investigation found that listener is not starting Automatically though its service configured to run automatically. Workaround: To resolve the “No Listener”, restarted workstation several times after changes…