Home » RDBMS Server » Security » sys passwd
sys passwd [message #124655] Mon, 20 June 2005 15:58 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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 #124800 is a reply to message #124735] Tue, 21 June 2005 10:29 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
frank,

thanks a lot..! but our oracle user belongs to oinstall group.how to change that or what else to do..?

bala
Re: sys passwd [message #124816 is a reply to message #124800] Tue, 21 June 2005 11:55 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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 Go to previous message
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.
Previous Topic: Batch only Log on to oracle DB
Next Topic: shocking problem.........!
Goto Forum:
  


Current Time: Fri Mar 29 08:40:50 CDT 2024