Re: sqlplus login question

From: Michael George III <michael_george_III_at_hotmail.com_NOSPAM>
Date: Wed, 11 Jul 2001 00:57:00 GMT
Message-ID: <wvN27.186885$DG1.31361879@news1.rdc1.mi.home.com>

> sqlplus username/password_at_INST

This one uses the Oracle listener. This is a good way to test and see if your listener is running and accepting new connections.

> versus
> export ORACLE_SID=INST
> sqlplus username/password

This connects without going through the network. This is nice when you need to do maintenance on a busy box. For example, shutdown the database and listener, then bring up only the database and not the listener. It keeps the hordes which connect over the network at bay and you don't have to worry about locks and contention on objects. It is also nice for performing a CLEAN export and maintaining referential integrity, since no data can change (unless of course you have programs on that same box that do not connect throught the listener).

-Michael Received on Tue Jul 10 2001 - 19:57:00 CDT