| sys passwd [message #124655] |
Mon, 20 June 2005 15:58  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
database-->oracle 9i
os-->linux
our sys passwd has been changed and not getting up.we have recreated the passwd file again but still in vain...
our system login is working fine...we have also checked with system's passwd but all in vain.what to do..?help out plz..
bala
[Updated on: Mon, 20 June 2005 16:01] Report message to a moderator |
|
|
|
| Re: sys passwd [message #124735 is a reply to message #124655] |
Tue, 21 June 2005 03:09  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
If your user belongs to the "dba" group you do not need a password to connect:
$ id
uid=100(oracle) gid=100(dba)
$ sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Tue Jun 21 09:04:22 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> alter user sys identified by oracle;
User altered.
Best regards.
Frank
|
|
|
|
|
|
| Re: sys passwd [message #124816 is a reply to message #124800] |
Tue, 21 June 2005 11:55 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
In that case you need to create a dba group and assign it to a user. Ask you OS Support person for assistance.
Best regards.
Frank
|
|
|
|
| Re: sys passwd [message #125541 is a reply to message #124655] |
Mon, 27 June 2005 06:16 |
EdVonk
Messages: 4
Registered: June 2005
Location: The Netherlands
|
Junior Member |
|
|
type "id" when logged on. Or "lsuser oracle" (don't know if that works under linux). Maybe oracle's primary group is just oinstall and oracle is also member of the dba group.
If not the case. And the dba group does not exist (type "more /etc/group | grep dba" to check this) follow Frank's instructions.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
