Какой пароль sql plus system as sysdba
Previous Next JavaScript must be enabled to correctly display this content
- Database Installation Guide
- Getting Started with Oracle Database
- Reviewing User Accounts and Passwords
- Using SQL*Plus to Unlock and Change Passwords
Using SQL*Plus to Unlock and Change Passwords
Use this SQL*Plus procedure to unlock and reset user account passwords.
To change a password after installation:
- Start SQL*Plus:
C:\> sqlplus /nolog
SQL> CONNECT SYS AS SYSDBA Enter password: SYS_password
SQL> ALTER USERaccountIDENTIFIED BYpasswordACCOUNT UNLOCK;
- Oracle Database Security Guide
- Oracle Database SQL Language Reference
- Oracle Database Administrator’s Guide
Какой пароль sql plus system as sysdba
Подскажите пожалуйста, как использую sql plus можно приконнектиться «as sysdba».
То есть, при запуске sql plus появляется стандартное окошко с тремя полями: user, password и строка связи.
Пробовал в поле user ввести sys as sysdba, но этот вариант не работает.
А как правильно ?
Re: [Oracle] SQL Plus — Connect as sysdba
| От: | Аноним | |
| Дата: | 27.06.05 06:33 | |
| Оценка: | 4 (1) | |
Здравствуйте, DemAS, Вы писали:
DAS>Добрый день.
DAS> Подскажите пожалуйста, как использую sql plus можно приконнектиться «as sysdba».
DAS> То есть, при запуске sql plus появляется стандартное окошко с тремя полями: user, password и строка связи.
DAS> Пробовал в поле user ввести sys as sysdba, но этот вариант не работает.
DAS> А как правильно ?
DAS> Заранее спасибо.
Попробуй в командной строке sqlplus/nolog
а дальше connect sys/password@sid as sysdba
или в шорткате sqlplusw.exe /nolog
Re: [Oracle] SQL Plus — Connect as sysdba
| От: | Аноним | |
| Дата: | 27.06.05 14:13 | |
| Оценка: | 4 (1) | |
DAS> Подскажите пожалуйста, как использую sql plus можно приконнектиться «as sysdba».
DAS> То есть, при запуске sql plus появляется стандартное окошко с тремя полями: user, password и строка связи.
DAS> Пробовал в поле user ввести sys as sysdba, но этот вариант не работает.
DAS> А как правильно ?
Также можно в поле ввода пароля, после пароля писать as sysdba, не знаю почему, но иногда работает.
а иногда нет.
How to set Password for sqlplus /as sysdba
I am new to Oracle. I would like to know how to set login password for sqlplus / as sysdba in oracle 11g. I want to set the password for my next login, i dont want to login as sqlplus / as sysdba since anyone can log in using sqlplus / as sysdba and can easily access the data or change password for the existing user.I need to restrict the login.
22.6k 28 28 gold badges 79 79 silver badges 90 90 bronze badges
asked Feb 12, 2013 at 9:18
user2064110 user2064110
115 1 1 gold badge 2 2 silver badges 5 5 bronze badges
3 Answers 3
To set a new password you should (after connecting to the DB):
alter user SYS identified by "newpassword"; But if you want to prevent connecting without a password — sqlplus / as sysdba , then you need to add this:
SQLNET.AUTHENTICATION_SERVICES=none answered Feb 12, 2013 at 12:30
16.8k 1 1 gold badge 37 37 silver badges 53 53 bronze badges
But if you want to prevent connecting without a password — sqlplus / as sysdba, then you need to add this: SQLNET.AUTHENTICATION_SERVICES=none in sqlnet.ora The same thing can be manually edited by some one and they can again change back to SQLNET.AUTHENTICATION_SERVICES=NTS so that they can login again -sqlplus / as sysdba
Feb 13, 2013 at 5:17
@user2064110, True, but the user that has write privileges to this file shouldn’t be just «anyuser» (the same as connecting as sysdba can’t be done by «anyuser»). If someone can get the admins password it’s the same like getting SYS’s password to the DB
Feb 13, 2013 at 5:44
Why i am asking is since say in a company 5 peoples are working and they are accessing the server with Admin userid and password and if some one changes some modifications in the server using sqlplus / as sysdba it will affect the rest of the peoples right so in-order to avoid we need to restrict the login by setting password.
SYSDBA password in Oracle DB
What is the default password for the sysdba user? I tried in net and found out the default password is change_on_install but it is not working for me. Does Oracle DB maintain some file or DB table where it stores the passwords?
24.7k 13 13 gold badges 51 51 silver badges 95 95 bronze badges
asked Mar 27, 2013 at 14:41
user2065083 user2065083
211 1 1 gold badge 2 2 silver badges 5 5 bronze badges
SYSDBA isn’t a username, it’s a connection option. Normally, you connect to SQL*Plus using sqlplus user/password or sqlplus sys/sys_password as sysdba . If you’re logged into the machine running Oracle, and the user you’re logged in has suitable privileges on the machine (normally membership of a certain group), you can log in without a username and password, by writing sqlplus / as sysdba . This logs you in as the user SYS .
– Luke Woodward
Mar 27, 2013 at 14:58
Mar 27, 2013 at 23:16
Just a friendly tip: if you’re not sure you know what you’re doing, connecting as SYS (which is analogous to a «root»-type account in a unix system) is a recipe for disaster. The best thing you can do is create a lower-privileged user, then login as that user.
Mar 28, 2013 at 5:39
4 Answers 4
SYSDBA is not a user, it is a system privilege. When you connect as / you are connecting to the SYS user. You don’t need a password when you connect as you are — as long as it’s a local connection from an OS account in the DBA group.
You haven’t said what happens when you try to connect, or why you think you need a password; possibly that is that failing (in which case giving the error message would be helpful) and giving you a SQL*Plus login prompt, maybe indicating you aren’t in that group.
Passwords are stored within the DB, the exact location depends on version; but they’re stored hashed (of course) so you’re not going to be able to get the actual passwords in plaintext (without a lot of time and effort anyway).
82.7k 28 28 gold badges 400 400 silver badges 629 629 bronze badges
answered Mar 27, 2013 at 15:00
Alex Poole Alex Poole
2,565 1 1 gold badge 18 18 silver badges 23 23 bronze badges
Oracle stores password for SYS and internal user’s password in PWD###.ora file, where ### is your DB service Name/SID. I found a nice tutorial on orapwd utility to change password for SYS :
82.7k 28 28 gold badges 400 400 silver badges 629 629 bronze badges
answered Sep 24, 2016 at 5:40
Saurabh Srivastava Saurabh Srivastava
31 1 1 bronze badge
This is an old entry and it should be updated. Password complexity is a concern when changing the SYS/SYSTEM passwords on 19C and above. Oracle 19C has a more complex password complexity requirement and when changing the SYS/SYSTEM password on an upgraded database, you should follow the 19C complexity requirements. This is especially important for AWS RDS, Oracle on-prem cloud and Oracle public cloud (OCI) implementations where the database service is used. You could conceivable continue to use password complexity that is less than what 19C and above call for, however there are numerous consequences. The most obvious consequence is that doing things like setting up a DataGuard instance will fail, since some of the cloud SDKs test for 19C complexity requirements prior to passing the PUT call to the REST API service (aka you get a beautiful python error — or something to that effect).
I make this post since I ran into this issue last week when attempting to provision a DataGuard instance from a 19.6.0.0 database that had been upgraded from 12.x. Long story short, the provisioning failed, and after a long chase it was determined when working with Oracle Support that I had to address the client’s not having touched the SYS/SYSTEM password after upgrading from 12.x.
answered Jun 10, 2021 at 18:12
Hank Wojteczko Hank Wojteczko
21 1 1 bronze badge
This is useful information, but I don’t see how it answers the original question. You may want to consider posting a separate question/answer pair addressing the issue you are referring to — it will make it easier to find for those experiencing such problems.