All geek questions in one place

No HR username in Oracle 12c

I installed oracle 12c on my ubuntu. I am using oracle through sqldeveloper and I can successfully connect to the user syswith my password. I want to use all databases provided by oracle by default. When I try to connect to the username hrwith the same password as in sys, I get the username no error was found.

select * from all_usersdoes not list the user hr. Therefore, I assume that the user is not created at all.

  • If it was not available by default, hr user?
  • How can I configure one to access all of the `hr` databases?
+5
source share
4 answers

I installed oracle 12c on my ubuntu. I assume that the user is not created at all.

You created a 12c database as a container. Now you can connect to the container database , while sample schemes are in the pluggable database .

Oracle 12c has implemented a multi-tenant architecture . There are some required steps after installation. Please read Oracle 12c Mandatory Steps After Installation .

The most common misunderstanding concerns the use of < SQLPLUS / AS SYSDBA.

CDB, "SQLPLUS / AS SYSDBA" CDB. "SCOTT/HR" SYSDBA. :

"SCOTT, HR" PDB, CDB. , SYSDBA PDB.

,

sqlplus SYS/password@PDBORCL AS SYSDBA

SQL> ALTER USER scott ACCOUNT UNLOCK IDENTIFIED BY tiger;

sqlplus scott/tiger@pdborcl

SQL> show user;
USER is "SCOTT"

UDPATE , OP . DBCA.

hr_main.sql script. , Human Resource (HR), in $ORACLE_HOME/demo/schema/human_resources.

,

HR

, Human Resource (HR) $ORACLE_HOME/demo/schema/human_resources.

script, hr_main.sql,

hr_main.sql :

  • HR
  • HR
  • HR
  • ,
+4

HR, SQL

ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY password;

+2

To install sample schemas, you need to follow the instructions from https://github.com/oracle/db-sample-schemas .

Everything from the source demo folder of Oracle Database 12.1.0.2 does not work correctly.

+2
source

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

More articles:


All Articles