When I go to Database Menu | Monitor | Instance Manager | and perform a Normal or Immediate Shutdown on a database, it works fine. When I try to Startup the same database, it seems to be successful (I do not get any sort of message), but when I try to connect to the same databases using a regular user or schema, we get the error "ORA-12514: TNS: listener does not currently know of service requested in connect descriptor".
WORKAROUND 1:
Go to the machine where the database is located, and perform a manual Restart of the database from Administrative Tools | Services.
WORKAROUND 2:
1) Start SQL Plus from Command Prompt using the command, "SQLPlusW /nolog". This will open a SQL Plus window.
2) Perform the following commands in SQL Plus:
a) connect as sys/<password> as sysdba;
b) STARTUP MOUNT;
c) ALTER DATABASE OPEN;
STATUS:
Waiting for fix in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center