Re: Using OPS$ for local login

Sean Garagan wrote:
>
> Greetings all,
>
> We are trying to develop an application that logs into Oracle
> securely by using the OPS$ protocol. All of the Oracle manuals
> point to this being only for a networked database. The application
> is local to the database so there is no reason to run SQL*Net.
>
> Is there any way to use OPS$ without going through a network
> protocol, or should we look into another way to access the
> database?
>
> The system is Oracle 7.1.4 on SVR4.
>
> Thanks in advance,
> Sean

If you have a valid ops$user in the database (ops$oracle in this example) and your Oracle environment variables are set right the following will work fine using IPC (Inter-Process Communications) instead of the network:

	[AIX:oracle]: sqlplus -s / <<EOF
	> show user
	> exit
	> EOF
	user is "OPS$ORACLE"
	[AIX:oracle]:

Pro*C, Forms, etc. are all the same way.

brian.maclean_at_teldta.com Received on Wed May 29 1996 - 00:00:00 CEST