Hi,
Is it possible to connect to database when listener is down with Toad?
I mean the same way you connect to a database using sqlplus and defining ORACLE_SID before.
As far as I know, the only way you can connect to a database when the listener is down, is if your database is running on the same DB as Toad (or SQL*Plus or anything else that connects via the OCI).
In which case, yes, you can connect if your TNSNames entry is something like:
myDB = (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
If your database is on a different server, then there is no way to do that, with Toad or SQLPlus or any other tool. I am wondering if you are SSHing to the server, THEN connecting with SQLPlus. If that's what you are doing, the SQLPlus instance that you are running is on the server, not your local pc.
Toad is running on the same server where the database is running.
What exactly should the TNS Names Entry syntax be in this case, if the SID of the database is inst1?
I don't know offhand, but I can try to figure it out tomorrow. Is there some reason why you don't want to run the listener?
I want to prevent applications from connecting to the database quickly and easily while I perform an operation, without needing to restart or change settings like RESTRICTED mode or similar.
I tried connecting to my database this way and was unable to. a BEQ_LOCAL connection should work, but I was unable to get it working. There's an example here Where to find a bequeath connect description parameters documentation? - Oracle Forums but it didn't work for me.
The easiest thing you could do though - make your connection as you normally do, THEN kill the listener. You'll stay connected.