oraclecdb.md

oraclecdb.md

• Web sitesinde login olup checkout yapılmasi gerekmektedir. https://hub.docker.com/_/oracle-database-enterprise-edition

docker login 

docker pull store/oracle/database-enterprise:12.2.0.1

docker run -d --name oracle -h oracle -P store/oracle/database-enterprise:12.2.0.1

alias orc='docker exec -it --user oracle oracle bash -c "cd ~; bash"'

# sys/Oradoc_db1
# system/Oradoc_db1 
# servicename / sid : ORCLPDB1.localdomain
#

• Alias da tanımlandığına göre interaktif login olunup tüm sqlplus komutları çalıştırılabilir.

kullan@KUHEYLAN:~/docker$ orc

[oracle@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 6 12:30:15 2022
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       READ WRITE NO
SQL> alter session set container=orclpdb1;

Session altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 ORCLPDB1                       READ WRITE NO
SQL> show con_name

CON_NAME
------------------------------
ORCLPDB1
SQL>

• YENI database açmak için

SQL> create pluggable database msrs admin user msrs identified by parola file_name_convert = ('pdbseed','msrs');
Pluggable database created.

SQL> alter pluggable database msrs open;
Pluggable database altered.

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       READ WRITE NO
         4 MSRS                           READ WRITE NO

sqlplus msrs/parola@msrs komudu ile yeni açılan puggable veritabanına bağlanılabilr. yada

SQL> alter session set container=msrs;
Session altered.

SQL> show con_name;
CON_NAME
------------------------------
MSRS

• select username, account_status from dba_users

---

• diger komutlar...

 show parameters;
 show sga
 set line 300
 select username,account_status from dba_users;
 
alter session set container=msrs;


###  close etmeden drop edilemez. 
alter pluggable database msrs open;
alter pluggable database msrs close;
drop pluggable database msrs including datafiles;


connect sys as sysdba;
-- password  'Oradoc_db1'
alter session set "_ORACLE_SCRIPT"=true;
create user test identified by test;
GRANT CONNECT, RESOURCE, DBA TO test;

GRANT CREATE SESSION GRANT ANY PRIVILEGE TO test2;
GRANT UNLIMITED TABLESPACE TO test2;
GRANT
  SELECT,
  INSERT,
  UPDATE,
  DELETE
ON
  schema.books
TO
  test2;

• oracle pluggable database önerilmeyen kullanım örnekleri:

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       READ WRITE NO
SQL> create user msrs identified by parola;
create user msrs identified by parola
            *
ERROR at line 1:
ORA-65096: invalid common user or role name


SQL>  alter session set "_oracle_script"=true;

Session altered.

SQL> create user alparslan identified by parola;

User created.

SQL>

özet

show con_name;
show pdbs;
alter session set container = orclpdb1;
create user testuser identified by "parola";
grant connect to testuser container=current;
grant create session to testuser;
grant resource to testuser;
#ALTER USER testuser QUOTA 100M ON USERS;
#grant all privileges to testuser identified by parola;
#grant all privileges to testuser;

sqlplus / as sysdba
alter session set container=orclpdb1;
grant unlimited tablespace to testuser;

alter session set container = orclpdb1;
alter session set current_schema = testuser;
create table t1(c1 number(5));
insert into t1 values (1);
select  * from t1;


sqlplus testuser/parola@orclpdb1

URL:  jdbc:oracle:thin:@localhost:1521/ORCLPDB1?oracle.net.disableOob=true
URL2: jdbc:oracle:thin:@192.168.111.111:1521/orclpdb1