Search code examples
oracle-sqldevelopersqlplusoracle19c

Issues connecting to an Oracle Database 19c


I am attempting to create and use an oracle DB.

Was able to create the DB using sql plus however when I attempt to connect to it via sqldeveloper I get the following error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

When I check that all services are running I notice OracleVssWriterORCL is not running. However upon attempting to start it I get the following error: Windows could not start OracleVssWriterORCL service on local machine Error 0x80070005: Access is Denied

This is my first time using Oracle for DB so any help is greatly appreciated. I should also note this is on a windows 10 VM


Solution

  • As stated above my listener was not running and going into cmd using the lsnrctrl start command fixed that issue but now I get a ORA-12505 error. Oh the fun of learning new things