change sys user password

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

change sys user password

Arsala
Sir

I have problem how to change password of sys user
I used like ( alter user sys identified by XXXX;  

but when I connect like

sys as sysdba     --when I press deuble enter it does not required passward without password we can enter to database.

please guide me the sys user should enter valid password without password it can not enter to db.
Reply | Threaded
Open this post in threaded view
|

Re: change sys user password

ErmanArslansOracleBlog
Administrator
It is not sqlplus as sysdba

It should be sqlplus / as sysdba

--there should be a "/" there.
Reply | Threaded
Open this post in threaded view
|

Re: change sys user password

Arsala

Sir

I want to enter to Database
as sys user but it must take password from me

example

connect sys as sysdba while we double press enter it not take password from me

so I must give valid password of sys user without it we should not enter to DB.
Reply | Threaded
Open this post in threaded view
|

Re: change sys user password

ErmanArslansOracleBlog
Administrator
then , use "sqlplus sys as sysdba"
Reply | Threaded
Open this post in threaded view
|

Re: change sys user password

Arsala


OK THANKS