- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Password for "connect internal" on Oracle8.0.5
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-11-2000 02:54 PM
тАО09-11-2000 02:54 PM
Password for "connect internal" on Oracle8.0.5
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-11-2000 11:57 PM
тАО09-11-2000 11:57 PM
Re: Password for "connect internal" on Oracle8.0.5
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 12:19 AM
тАО09-12-2000 12:19 AM
Re: Password for "connect internal" on Oracle8.0.5
unset TWO_TASK
svrmgrl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 01:51 AM
тАО09-12-2000 01:51 AM
Re: Password for "connect internal" on Oracle8.0.5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 02:20 AM
тАО09-12-2000 02:20 AM
Re: Password for "connect internal" on Oracle8.0.5
Try using following:
typeset -x ORACLE_SID=sid
svrmgrl
connect internal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 04:24 AM
тАО09-12-2000 04:24 AM
Re: Password for "connect internal" on Oracle8.0.5
Richard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2000 01:18 AM
тАО09-13-2000 01:18 AM
Re: Password for "connect internal" on Oracle8.0.5
'operating system authentication' is not required (that is a different story)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2000 03:34 AM
тАО09-13-2000 03:34 AM
Re: Password for "connect internal" on Oracle8.0.5
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2000 10:19 AM
тАО09-13-2000 10:19 AM
Re: Password for "connect internal" on Oracle8.0.5
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