Oracle/Linux connect internal question 
Author Message
 Oracle/Linux connect internal question

CONNECT INTERNAL will ask for a password if the OS user you're logged in as is
not part of the "dba" group.  The "dba" group can be any OS group, but it is
typically "dba".  The group is configurable during installation if you're doing
a Custom Install.  After install, you'll have to modify the
?/rdbms/lib/config.c file and relink the oracle executable to change the group
used for authenticating CONNECT INTERNAL.

You can do a few things:
- Only log in as a member of the dba group when doing a CONNECT INTERNAL.
- Setup a password file using ?/bin/orapwd.  You also need to set the init.ora
parameter remote_login_passwordfile for this.

An additional point ot remember - Oracle will always ask for a password if you
are connecting through the listener (a non-local connection), even if svrmgrl
is running on the same system.  If you need to connect through the listener,
setup a password file.

Setting TWO_TASK=P: forces Oracle to use the SQL*Net v1 pipe driver, which
along with the v2 BEQ protocol adapter, are the two types of local
connections.  SQL*Net v1 is only available with 7.2 and earlier, so it won't
work with Oracle8.

Regards, Doug.

Quote:

> 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.***.com/ ~davesisk/oont.htm



Wed, 20 Jun 2001 03:00:00 GMT
 Oracle/Linux connect internal question

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



Thu, 21 Jun 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Oracle/Linux connect internal question

2. another connect internal question

3. Newbie question on connect internal

4. Problem connecting internal w/ svrmgrl on IRIX 6.3 running Oracle 7.3.2

5. Connect Internal in Oracle 8i

6. Can't connect internal on server manager with Personal Oracle 8

7. connecting internal in Personal Oracle

8. 8i: connect / as sysdba not equivalent to connect internal

9. Oracle "connect internal" from Pro*C

10. Oracle 8.0.5 client on linux connecting to Oracle 7.3.4 on Solaris

11. Internal heap ERROR (connecting from oracle 8.0.4 for linux to Oracle 7.3.2 for hp_ux 10.20)

12. Connecting Linux Server to Linux Client


 
Powered by phpBB® Forum Software