Re: Oracle/Linux connect internal question

>
>
> David Sisk wrote:
>
>> Hi Unix Gurus:
>>
>> I've got Oracle8 for Linux installed and working (at least, most of it,
>> anyway). I can connect internal using svrmgrl while logged into the O/S as
>>
>> the oracle user (the account owning the software), but if I try connecting
>> internal while signed into the O/S as myself, svrmgrl asks for the internal
>>
>> password. The ORACLE_HOME/bin path and environment variables are set for
>> both the oracle user and my own userid. (I recall that with AIX, you have
>> to set TWO_TASK = P:, although I'm not sure exactly what this does.) How
>> do I correct this? Please respond via email as well as posting here?
>>
>> Thanks and regards,
>>
>> --
>> David C. Sisk
>> The Unofficial ORACLE on NT site
>> http://www.ipass.net/~davesisk/oont.htm
>
> Try granting the unix group DBA to yourself that should work for connecting
> internal. TWO_TASK should not be set as this identifies that the database
> connection should be made via SQL-net. You must however set ORACLE_SID with
> the databasename. In case you want to test a remote connection via
> tns-listener (in order to get a database connection from another machine
> (unix, nt or whatever) you can fill TWO_TASK with the required database name
> and preferably unset ORACLE_SID. Connecting internal to a remote database is
> however not allowed.

Hope this helps.

Greetings Ignace. Received on Fri Jan 15 1999 - 17:49:01 CST