All geek questions in one place

What username and password should I enter when connecting to SQL * Plus after installing Oracle 11g?

I installed Oracle 11g on Windows 7

When I started sqlplus, it will ask me to enter a username and password

Can someone tell me which username to insert, and when I try to enter some password, it does not allow me to enter one letter. Is there a reason why?

+6
source share
3 answers

If you forget the password for any user, you can reset to log in as SYS:

sqlplus / as sysdba

And then:

 alter user <username> identified by <password>;

If you forget which users you have, you can run:

 select username from all_users;

If you only recently created a database, it would be wise to limit CREATED, since the default database installation comes with dozens of custom schemas. For example, to find users added last week, follow these steps:

 select * from all_users where created > trunc(sysdate)-7;
+9
source

Enter SYSTEM as the username and password entered during the 11g installation works well for me!

+3
source

Username refers to the scheme to which you must connect. Typically, the hr scheme is an available sampling scheme. The password will be the same password that you set when installing Oracle.

0
source

Source: https://habr.com/ru/post/905049/

More articles:


All Articles