Operating System - HP-UX
1747988 Members
4857 Online
108756 Solutions
New Discussion юеВ

Re: Password for "connect internal" on Oracle8.0.5

 
Sungwon Yang
Occasional Contributor

Password for "connect internal" on Oracle8.0.5

Dear Everybody,

Actualy, I've installed the Oracle8.0.5 for ITO, following the Installation Guide.
I Completed the Installation of Oracle and ITO. When I start "opcconfig" to configure the ITO and Oracle. One serious problem comes out.
When I start the Oracle : svrmgrl > connect internal, I was required to type the Password.
e.g
***************************
$ svrmgrl
SVRMGRL > connect internal
SVRMGRL > password :
**************************
Even if I've tried every password related on the system, nothing worked out.

Could you anyone help me how to solve it?
Asaph
8 REPLIES 8
Alex Glennie
Honored Contributor

Re: Password for "connect internal" on Oracle8.0.5

I'm not an Oracle expert but the only thing I can think that may be responsible is Oracle Authentication :

Password or Operating System Authentication
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Password Authentication
~~~~~~~~~~~~~~~~~~~~~~~
Unless a connection to the instance is considered 'secure' then you
must use a password to connect with SYSDBA or SYSOPER privilege.
Users can be added to a special 'password' file using either the
'ORAPWD' utility, or 'GRANT SYSDBA to USER' command. Such a user can
then connect to the instance for administrative purposes using the
syntax:

CONNECT username/password AS SYSDBA
or
CONNECT username/password AS SYSOPER

Users with SYSDBA or SYSOPER privilege can be seen in the view
V$PWFILE_USERS.


Operating System Authentication
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If the connection to the instance is local or 'secure' then it is
possible
to use the operating system to determine if a user is allowed SYSDBA
or
SYSOPER access. In this case no password is required. The syntax to
connect
using operating system authentication is:

CONNECT / AS SYSDBA
or
CONNECT / AS SYSOPER


Oracle determines if you can connect thus:

On Unix: On UNIX the Oracle executable has two group names
compiled into it, one for SYSOPER and one for SYSDBA.
These are known as the OSOPER and OSDBA groups.
Typically these can be set when the Oracle software is
installed and are set in a file called either
$ORACLE_HOME/rdbms/lib/config.c or config.s . The
default
group for OSOPER and OSDBA is generally set to 'dba'.

When you issue the command 'CONNECT / AS SYSOPER' Oracle
checks if your Unix logon is a member of the 'OSOPER'
group
and if so allows you to connect. Similarly to connect as
SYSDBA
your Unix logon should be a member of the Unix 'OSDBA'
group.

The OSDBA groups is the same group as has been
historically
used to allow CONNECT INTERNAL.


On NT: On NT the OSOPER and OSDBA groups are hard coded names
thus:

Group Name Oracle uses this as...
~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~
ORA_OPER OSOPER group for all instances
ORA_DBA OSDBA group for all instances
ORA_sid_OPER OSOPER group for a specific Oracle SID
ORA_sid_DBA OSDBA group for a specific Oracle SID

When you issue a 'CONNECT / AS SYSDBA' Oracle checks if
your
NT logon is a member of the 'ORA_sid_DBA' or 'ORA_DBA'
group.
Note: 1) the 'sid' should be in upper case.
2) ensure "SQLNET.AUTHENTICATION_SERVICES =
(NTS)" is
set
in the SQLNET.ORA file on the server.


For other platforms see the port specific documentation.

Hope this helps ?
John Palmer
Honored Contributor

Re: Password for "connect internal" on Oracle8.0.5

One thing is to ensure that you unset the veriable TWO_TASK before calling svrmgrl:-

unset TWO_TASK
svrmgrl
Thomas Schler_1
Trusted Contributor

Re: Password for "connect internal" on Oracle8.0.5

Choose operating system authentication and login as uid oracle and gid dba.
no users -- no problems
CHRIS ANORUO
Honored Contributor

Re: Password for "connect internal" on Oracle8.0.5

This will not require a password if you log into the oracle home directory.
Try using following:
typeset -x ORACLE_SID=sid
svrmgrl
connect internal
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Richard Mertz
Regular Advisor

Re: Password for "connect internal" on Oracle8.0.5

If you are not logged in as oracle, you need a password to connect internal. Are you logged in as user oracle?

Richard
What anybody thinks of me is none of my business.
Geetam
Frequent Advisor

Re: Password for "connect internal" on Oracle8.0.5

connect internal will not ask for a password if you are logged in to unix as a user who is a member of the group 'dba'.

'operating system authentication' is not required (that is a different story)
Wodisch_1
Honored Contributor

Re: Password for "connect internal" on Oracle8.0.5

Hi,
check for group memberships of your account:
id
the oracle admin group must be shown, if not,
add your account to that group ("dba") and
re-login.
Test for existance of the Oracle password
file "$ORACLE_HOME/dbs/pwd$ORACLE_SID.ora"
(or similiar, it contains "pwd" and "ora"
and your SID). If you have one, rename it,
or create a new one with
cd $ORACLE_HOME/dbs
orapwd -f pwd$ORACLE_SID.ora -e 2 SECRET
(do not use "SECRET", insert your own word).
Now try again.
HTH,
Wodisch
P V Patel
Advisor

Re: Password for "connect internal" on Oracle8.0.5

HI,
You must connect to UNIX system as oracle (owner of oracle database) user. After that you have to run svrmgrl.In this case , you will not find any problem with connect internal.
If you didn't connect system as oracle user, system will ask passwrd for connect internal.

P V Patel
Punjabhai