[oracle@centos7 ~]$ docker exec --interactive --tty --user root --workdir / orcl_12cr2 bash
bash-4.2# yum list installed | grep sudo
bash-4.2# yum install -y sudo
Loaded plugins: ovl
Resolving Dependencies
--> Running transaction check
---> Package sudo.x86_64 0:1.8.23-3.el7 will be installed
--> Processing Dependency: /usr/bin/vi for package: sudo-1.8.23-3.el7.x86_64
--> Running transaction check
---> Package vim-minimal.x86_64 2:7.4.160-5.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
======================================================================================================================================================
Package Arch Version Repository Size
======================================================================================================================================================
Installing:
sudo x86_64 1.8.23-3.el7 ol7_latest 841 k
Installing for dependencies:
vim-minimal x86_64 2:7.4.160-5.el7 ol7_latest 436 k
Transaction Summary
======================================================================================================================================================
Install 1 Package (+1 Dependent package)
Total download size: 1.2 M
Installed size: 3.9 M
Downloading packages:
(1/2): vim-minimal-7.4.160-5.el7.x86_64.rpm | 436 kB 00:00:04
(2/2): sudo-1.8.23-3.el7.x86_64.rpm | 841 kB 00:00:04
------------------------------------------------------------------------------------------------------------------------------------------------------
Total 283 kB/s | 1.2 MB 00:00:04
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : 2:vim-minimal-7.4.160-5.el7.x86_64 1/2
Installing : sudo-1.8.23-3.el7.x86_64 2/2
Verifying : 2:vim-minimal-7.4.160-5.el7.x86_64 1/2
Verifying : sudo-1.8.23-3.el7.x86_64 2/2
Installed:
sudo.x86_64 0:1.8.23-3.el7
Dependency Installed:
vim-minimal.x86_64 2:7.4.160-5.el7
Complete!
bash-4.2# yum list installed | grep sudo
sudo.x86_64 1.8.23-3.el7 @ol7_latest
bash-4.2#
Author: ukijumotahaneniarukenia
osquery install docker
https://osquery.io/docs/tables/
[oracle@centos7 ~]$ docker exec --interactive --tty --user root --workdir / orcl_12cr2 bash
bash-4.2# whoami
root
bash-4.2# yum -y install https://osquery-packages.s3.amazonaws.com/centos7/noarch/osquery-s3-centos7-repo-1-0.0.noarch.rpm
Loaded plugins: ovl
osquery-s3-centos7-repo-1-0.0.noarch.rpm | 5.7 kB 00:00:00
Examining /var/tmp/yum-root-e42ejR/osquery-s3-centos7-repo-1-0.0.noarch.rpm: osquery-s3-centos7-repo-1-0.0.noarch
Marking /var/tmp/yum-root-e42ejR/osquery-s3-centos7-repo-1-0.0.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package osquery-s3-centos7-repo.noarch 0:1-0.0 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
======================================================================================================================================================
Package Arch Version Repository Size
======================================================================================================================================================
Installing:
osquery-s3-centos7-repo noarch 1-0.0 /osquery-s3-centos7-repo-1-0.0.noarch 3.2 k
Transaction Summary
======================================================================================================================================================
Install 1 Package
Total size: 3.2 k
Installed size: 3.2 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : osquery-s3-centos7-repo-1-0.0.noarch 1/1
Verifying : osquery-s3-centos7-repo-1-0.0.noarch 1/1
Installed:
osquery-s3-centos7-repo.noarch 0:1-0.0
Complete!
bash-4.2# yum -y install osquery
Loaded plugins: ovl
ol7_UEKR4 | 1.2 kB 00:00:00
ol7_latest | 1.4 kB 00:00:00
osquery-s3-centos7-repo | 951 B 00:00:00
osquery-s3-centos7-repo/x86_64/primary | 6.7 kB 00:00:01
osquery-s3-centos7-repo 69/69
Resolving Dependencies
--> Running transaction check
---> Package osquery.x86_64 0:3.2.6-1.linux will be installed
--> Finished Dependency Resolution
Dependencies Resolved
======================================================================================================================================================
Package Arch Version Repository Size
======================================================================================================================================================
Installing:
osquery x86_64 3.2.6-1.linux osquery-s3-centos7-repo 8.0 M
Transaction Summary
======================================================================================================================================================
Install 1 Package
Total download size: 8.0 M
Installed size: 23 M
Downloading packages:
warning: /var/cache/yum/x86_64/7Server/osquery-s3-centos7-repo/packages/osquery-3.2.6-1.linux.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID c9d8b80b: NOKEY
Public key for osquery-3.2.6-1.linux.x86_64.rpm is not installed
osquery-3.2.6-1.linux.x86_64.rpm | 8.0 MB 00:00:21
Retrieving key from file:///etc/pki/rpm-gpg/OSQUERY-S3-RPM-REPO-GPGKEY
Importing GPG key 0xC9D8B80B:
Userid : "osquery (osquery) "
Fingerprint: 1484 120a c4e9 f8a1 a577 aeee 97a8 0c63 c9d8 b80b
Package : osquery-s3-centos7-repo-1-0.0.noarch (installed)
From : /etc/pki/rpm-gpg/OSQUERY-S3-RPM-REPO-GPGKEY
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : osquery-3.2.6-1.linux.x86_64 1/1
Verifying : osquery-3.2.6-1.linux.x86_64 1/1
Installed:
osquery.x86_64 0:3.2.6-1.linux
Complete!
bash-4.2#
bash-4.2# osqueryi
Using a virtual database. Need help, type '.help'
osquery> .help
Welcome to the osquery shell. Please explore your OS!
You are connected to a transient 'in-memory' virtual database.
.all [TABLE] Select all from a table
.bail ON|OFF Stop after hitting an error
.echo ON|OFF Turn command echo on or off
.exit Exit this program
.features List osquery's features and their statuses
.headers ON|OFF Turn display of headers on or off
.help Show this message
.mode MODE Set output mode where MODE is one of:
csv Comma-separated values
column Left-aligned columns see .width
line One value per line
list Values delimited by .separator string
pretty Pretty printed SQL results (default)
.nullvalue STR Use STRING in place of NULL values
.print STR... Print literal STRING
.quit Exit this program
.schema [TABLE] Show the CREATE statements
.separator STR Change separator used by output mode
.socket Show the osquery extensions socket path
.show Show the current values for various settings
.summary Alias for the show meta command
.tables [TABLE] List names of tables
.width [NUM1]+ Set column widths for "column" mode
.timer ON|OFF Turn the CPU timer measurement on or off
osquery>
osquery> select name,version from os_version;
+---------------------------------+-----------------------------------------------------+
| name | version |
+---------------------------------+-----------------------------------------------------+
| Red Hat Enterprise Linux Server | Red Hat Enterprise Linux Server release 7.6 (Maipo) |
+---------------------------------+-----------------------------------------------------+
osquery>
osquery> select hostname, cpu_brand, hardware_vendor, hardware_model from system_info;
+--------------+----------------------------------------+-----------------+----------------+
| hostname | cpu_brand | hardware_vendor | hardware_model |
+--------------+----------------------------------------+-----------------+----------------+
| 609a69bc0b21 | Intel(R) Celeron(R) CPU B800 @ 1.50GHz | | |
+--------------+----------------------------------------+-----------------+----------------+
osquery>
osquery> select * from users;
+-------+-------+------------+------------+-----------------+----------------------------+------------------+----------------+------+
| uid | gid | uid_signed | gid_signed | username | description | directory | shell | uuid |
+-------+-------+------------+------------+-----------------+----------------------------+------------------+----------------+------+
| 0 | 0 | 0 | 0 | root | root | /root | /bin/bash | |
| 1 | 1 | 1 | 1 | bin | bin | /bin | /sbin/nologin | |
| 2 | 2 | 2 | 2 | daemon | daemon | /sbin | /sbin/nologin | |
| 3 | 4 | 3 | 4 | adm | adm | /var/adm | /sbin/nologin | |
| 4 | 7 | 4 | 7 | lp | lp | /var/spool/lpd | /sbin/nologin | |
| 5 | 0 | 5 | 0 | sync | sync | /sbin | /bin/sync | |
| 6 | 0 | 6 | 0 | shutdown | shutdown | /sbin | /sbin/shutdown | |
| 7 | 0 | 7 | 0 | halt | halt | /sbin | /sbin/halt | |
| 8 | 12 | 8 | 12 | mail | mail | /var/spool/mail | /sbin/nologin | |
| 11 | 0 | 11 | 0 | operator | operator | /root | /sbin/nologin | |
| 12 | 100 | 12 | 100 | games | games | /usr/games | /sbin/nologin | |
| 14 | 50 | 14 | 50 | ftp | FTP User | /var/ftp | /sbin/nologin | |
| 99 | 99 | 99 | 99 | nobody | Nobody | / | /sbin/nologin | |
| 192 | 192 | 192 | 192 | systemd-network | systemd Network Management | / | /sbin/nologin | |
| 81 | 81 | 81 | 81 | dbus | System message bus | / | /sbin/nologin | |
| 32 | 32 | 32 | 32 | rpc | Rpcbind Daemon | /var/lib/rpcbind | /sbin/nologin | |
| 29 | 29 | 29 | 29 | rpcuser | RPC Service User | /var/lib/nfs | /sbin/nologin | |
| 65534 | 65534 | 65534 | 65534 | nfsnobody | Anonymous NFS User | /var/lib/nfs | /sbin/nologin | |
| 54321 | 54321 | 54321 | 54321 | oracle | | /home/oracle | /bin/bash | |
+-------+-------+------------+------------+-----------------+----------------------------+------------------+----------------+------+
osquery>
osquery> select * from cpu_time;
+------+---------+-------+---------+----------+--------+-----+---------+-------+-------+------------+
| core | user | nice | system | idle | iowait | irq | softirq | steal | guest | guest_nice |
+------+---------+-------+---------+----------+--------+-----+---------+-------+-------+------------+
| 0 | 1579161 | 10306 | 1155039 | 17294224 | 20470 | 0 | 8705 | 0 | 0 | 0 |
| 1 | 1628500 | 23079 | 1157443 | 52210 | 248 | 0 | 5020 | 0 | 0 | 0 |
+------+---------+-------+---------+----------+--------+-----+---------+-------+-------+------------+
osquery>
osquery> select * from crontab;
+-------+--------+------+--------------+-------+-------------+---------------------------------+---------------------+
| event | minute | hour | day_of_month | month | day_of_week | command | path |
+-------+--------+------+--------------+-------+-------------+---------------------------------+---------------------+
| | 01 | * | * | * | * | root run-parts /etc/cron.hourly | /etc/cron.d/0hourly |
| | */10 | * | * | * | * | root /usr/lib64/sa/sa1 1 1 | /etc/cron.d/sysstat |
| | 53 | 23 | * | * | * | root /usr/lib64/sa/sa2 -A | /etc/cron.d/sysstat |
+-------+--------+------+--------------+-------+-------------+---------------------------------+---------------------+
osquery>
osquery> select * from process_events;
W1226 11:58:28.851143 28937 virtual_table.cpp:565] Table process_events is event-based but events are disabled
W1226 11:58:28.851416 28937 virtual_table.cpp:572] Please see the table documentation: https://osquery.io/schema/#process_events
osquery> select * from routes;
+-----------------+---------+------------+------------+-------+-----------+-----+--------+-----------+
| destination | netmask | gateway | source | flags | interface | mtu | metric | type |
+-----------------+---------+------------+------------+-------+-----------+-----+--------+-----------+
| 0.0.0.0 | 0 | 172.17.0.1 | | 0 | eth0 | 0 | 0 | gateway |
| 172.17.0.0 | 16 | | 172.17.0.2 | 0 | eth0 | 0 | 0 | gateway |
| 127.0.0.0 | 0 | | 127.0.0.1 | 0 | lo | 0 | 0 | broadcast |
| 127.0.0.0 | 8 | | 127.0.0.1 | 0 | lo | 0 | 0 | local |
| 127.0.0.1 | 0 | | 127.0.0.1 | 0 | lo | 0 | 0 | local |
| 127.255.255.255 | 0 | | 127.0.0.1 | 0 | lo | 0 | 0 | broadcast |
| 172.17.0.0 | 0 | | 172.17.0.2 | 0 | eth0 | 0 | 0 | broadcast |
| 172.17.0.2 | 0 | | 172.17.0.2 | 0 | eth0 | 0 | 0 | local |
| 172.17.255.255 | 0 | | 172.17.0.2 | 0 | eth0 | 0 | 0 | broadcast |
| 0.0.0.0 | 0 | | | 0 | lo | 0 | -1 | other |
| 0.0.0.0 | 0 | | | 0 | lo | 0 | -1 | other |
+-----------------+---------+------------+------------+-------+-----------+-----+--------+-----------+
osquery>
osquery> select * from processes;
+-------+---------------+-------------------+---------------------------------------------------------------------+-------+-----+------+-------+-------+-------+-------+-------+-------+---------+------------+---------------+------------+-----------+-------------+-----------------+--------------------+------------+--------+--------+---------+------+------------------+---------------+---------------+---------------+---------------+----------------+---------------+
| pid | name | path | cmdline | state | cwd | root | uid | gid | euid | egid | suid | sgid | on_disk | wired_size | resident_size | total_size | user_time | system_time | disk_bytes_read | disk_bytes_written | start_time | parent | pgroup | threads | nice | cgroup_namespace | ipc_namespace | mnt_namespace | net_namespace | pid_namespace | user_namespace | uts_namespace |
+-------+---------------+-------------------+---------------------------------------------------------------------+-------+-----+------+-------+-------+-------+-------+-------+-------+---------+------------+---------------+------------+-----------+-------------+-----------------+--------------------+------------+--------+--------+---------+------+------------------+---------------+---------------+---------------+---------------+----------------+---------------+
| 1 | runOracle.sh | | /bin/bash /opt/oracle/runOracle.sh | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 624000 | 11688000 | 26 | 179 | | 0 | 23181 | 0 | 1 | 1 | 0 | | | | | | | |
| 2491 | ora_pmon_orcl | | ora_pmon_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 17108000 | 2007792000 | 563 | 1683 | | 0 | 24198 | 1 | 2491 | 1 | 0 | | | | | | | |
| 2493 | ora_clmn_orcl | | ora_clmn_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 14272000 | 2007796000 | 229 | 547 | | 0 | 24198 | 1 | 2493 | 1 | 0 | | | | | | | |
| 2495 | ora_psp0_orcl | | ora_psp0_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 14240000 | 2007792000 | 1071 | 5086 | | 0 | 24198 | 1 | 2495 | 1 | 0 | | | | | | | |
| 2497 | ora_vktm_orcl | | ora_vktm_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 13708000 | 2007796000 | 2514 | 4127 | | 0 | 24199 | 1 | 2497 | 1 | 0 | | | | | | | |
| 2501 | ora_gen0_orcl | | ora_gen0_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 47668000 | 2009652000 | 1551 | 1791 | | 0 | 24200 | 1 | 2501 | 1 | 0 | | | | | | | |
| 2503 | ora_mman_orcl | | ora_mman_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 450452000 | 2007792000 | 394 | 519 | | 0 | 24200 | 1 | 2503 | 1 | 0 | | | | | | | |
| 2507 | ora_scmn_orcl | | ora_gen1_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 31160000 | 2228732000 | 6520 | 5162 | | 0 | 24200 | 1 | 2507 | 3 | 0 | | | | | | | |
| 2511 | ora_diag_orcl | | ora_diag_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 17800000 | 2007888000 | 997 | 720 | | 0 | 24200 | 1 | 2511 | 1 | 0 | | | | | | | |
| 2513 | ora_scmn_orcl | | ora_ofsd_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 15924000 | 2228728000 | 304 | 444 | | 0 | 24200 | 1 | 2513 | 3 | 0 | | | | | | | |
| 2517 | ora_dbrm_orcl | | ora_dbrm_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 152736000 | 2024748000 | 11850 | 11669 | | 0 | 24200 | 1 | 2517 | 1 | 0 | | | | | | | |
| 2519 | ora_vkrm_orcl | | ora_vkrm_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 17064000 | 2007796000 | 3890 | 3349 | | 0 | 24200 | 1 | 2519 | 1 | 0 | | | | | | | |
| 2521 | ora_svcb_orcl | | ora_svcb_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 13812000 | 2008304000 | 652 | 1036 | | 0 | 24200 | 1 | 2521 | 1 | 0 | | | | | | | |
| 2523 | ora_pman_orcl | | ora_pman_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 14236000 | 2007796000 | 3417 | 1872 | | 0 | 24200 | 1 | 2523 | 1 | 0 | | | | | | | |
| 2525 | ora_dia0_orcl | | ora_dia0_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 24396000 | 2010936000 | 22581 | 65 | | 0 | 24200 | 1 | 2525 | 1 | 0 | | | | | | | |
| 2527 | ora_dbw0_orcl | | ora_dbw0_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 292272000 | 2019436000 | 1481 | 1061 | | 0 | 24200 | 1 | 2527 | 1 | 0 | | | | | | | |
| 2529 | ora_lgwr_orcl | | ora_lgwr_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 23624000 | 2008316000 | 1322 | 2007 | | 0 | 24200 | 1 | 2529 | 1 | 0 | | | | | | | |
| 2531 | ora_ckpt_orcl | | ora_ckpt_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 40204000 | 2008316000 | 3984 | 3215 | | 0 | 24200 | 1 | 2531 | 1 | 0 | | | | | | | |
| 2533 | ora_lg00_orcl | | ora_lg00_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 21800000 | 2007800000 | 361 | 799 | | 0 | 24200 | 1 | 2533 | 1 | 0 | | | | | | | |
| 2535 | ora_smon_orcl | | ora_smon_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 57756000 | 2010724000 | 701 | 71 | | 0 | 24200 | 1 | 2535 | 1 | 0 | | | | | | | |
| 2537 | ora_lg01_orcl | | ora_lg01_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 18636000 | 2007800000 | 159 | 296 | | 0 | 24201 | 1 | 2537 | 1 | 0 | | | | | | | |
| 2539 | ora_smco_orcl | | ora_smco_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 15388000 | 2007800000 | 1157 | 1071 | | 0 | 24201 | 1 | 2539 | 1 | 0 | | | | | | | |
| 2541 | ora_reco_orcl | | ora_reco_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 35844000 | 2009624000 | 242 | 114 | | 0 | 24201 | 1 | 2541 | 1 | 0 | | | | | | | |
| 25441 | ora_w002_orcl | | ora_w002_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 56816000 | 2010364000 | 21 | 12 | | 0 | 197432 | 1 | 25441 | 1 | 0 | | | | | | | |
| 2545 | ora_lreg_orcl | | ora_lreg_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 23716000 | 2013516000 | 897 | 487 | | 0 | 24201 | 1 | 2545 | 1 | 0 | | | | | | | |
| 2549 | ora_pxmn_orcl | | ora_pxmn_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 14572000 | 2007792000 | 249 | 457 | | 0 | 24201 | 1 | 2549 | 1 | 0 | | | | | | | |
| 2553 | ora_mmon_orcl | | ora_mmon_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 183800000 | 2032004000 | 54770 | 5823 | | 0 | 24201 | 1 | 2553 | 1 | 0 | | | | | | | |
| 2555 | ora_mmnl_orcl | | ora_mmnl_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 33552000 | 2008604000 | 6256 | 854 | | 0 | 24201 | 1 | 2555 | 1 | 0 | | | | | | | |
| 2557 | ora_d000_orcl | | ora_d000_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 12636000 | 2010596000 | 216 | 207 | | 0 | 24201 | 1 | 2557 | 1 | 0 | | | | | | | |
| 2559 | ora_s000_orcl | | ora_s000_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 12468000 | 2009892000 | 178 | 186 | | 0 | 24201 | 1 | 2559 | 1 | 0 | | | | | | | |
| 2561 | ora_tmon_orcl | | ora_tmon_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 14528000 | 2007796000 | 127 | 314 | | 0 | 24201 | 1 | 2561 | 1 | 0 | | | | | | | |
| 2571 | ora_tt00_orcl | | ora_tt00_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 22740000 | 2030972000 | 66 | 377 | | 0 | 24206 | 1 | 2571 | 1 | 0 | | | | | | | |
| 2573 | ora_tt01_orcl | | ora_tt01_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 13748000 | 2007792000 | 131 | 204 | | 0 | 24206 | 1 | 2573 | 1 | 0 | | | | | | | |
| 2575 | ora_tt02_orcl | | ora_tt02_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 14064000 | 2007792000 | 628 | 561 | | 0 | 24206 | 1 | 2575 | 1 | 0 | | | | | | | |
| 2577 | ora_aqpc_orcl | | ora_aqpc_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 24408000 | 2009620000 | 147 | 247 | | 0 | 24208 | 1 | 2577 | 1 | 0 | | | | | | | |
| 2581 | ora_p000_orcl | | ora_p000_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 320548000 | 2017456000 | 13959 | 1685 | | 0 | 24210 | 1 | 2581 | 1 | 0 | | | | | | | |
| 2583 | ora_p001_orcl | | ora_p001_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 480856000 | 2017460000 | 13912 | 1773 | | 0 | 24210 | 1 | 2583 | 1 | 0 | | | | | | | |
| 2585 | ora_p002_orcl | | ora_p002_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 236996000 | 2013472000 | 11400 | 2277 | | 0 | 24210 | 1 | 2585 | 1 | 0 | | | | | | | |
| 2587 | ora_p003_orcl | | ora_p003_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 241076000 | 2012904000 | 10077 | 1944 | | 0 | 24210 | 1 | 2587 | 1 | 0 | | | | | | | |
| 2589 | ora_p004_orcl | | ora_p004_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 87560000 | 2010716000 | 1681 | 363 | | 0 | 24210 | 1 | 2589 | 1 | 0 | | | | | | | |
| 2591 | ora_p005_orcl | | ora_p005_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 109820000 | 2012892000 | 1721 | 357 | | 0 | 24210 | 1 | 2591 | 1 | 0 | | | | | | | |
| 2593 | ora_p006_orcl | | ora_p006_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 96940000 | 2010680000 | 1791 | 302 | | 0 | 24210 | 1 | 2593 | 1 | 0 | | | | | | | |
| 2595 | ora_p007_orcl | | ora_p007_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 98428000 | 2010680000 | 1802 | 266 | | 0 | 24210 | 1 | 2595 | 1 | 0 | | | | | | | |
| 26 | tnslsnr | | /opt/oracle/product/12.2.0.1/dbhome_1/bin/tnslsnr LISTENER -inherit | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 5120000 | 215568000 | 169 | 817 | | 0 | 23182 | 1 | 26 | 2 | 0 | | | | | | | |
| 2648 | ora_cjq0_orcl | | ora_cjq0_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 197876000 | 2019032000 | 38740 | 20810 | | 0 | 24212 | 1 | 2648 | 1 | 0 | | | | | | | |
| 2753 | ora_qm02_orcl | | ora_qm02_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 18016000 | 2007792000 | 165 | 312 | | 0 | 24219 | 1 | 2753 | 1 | 0 | | | | | | | |
| 2770 | ora_q003_orcl | | ora_q003_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 19396000 | 2008308000 | 169 | 220 | | 0 | 24221 | 1 | 2770 | 1 | 0 | | | | | | | |
| 28502 | ora_q005_orcl | | ora_q005_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 22464000 | 2007792000 | 2 | 4 | | 0 | 276912 | 1 | 28502 | 1 | 0 | | | | | | | |
| 28661 | bash | | bash | S | | | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 1748000 | 11820000 | 6 | 1 | | 0 | 277073 | 0 | 28661 | 1 | 0 | | | | | | | |
| 28802 | ora_w007_orcl | | ora_w007_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 24632000 | 2007804000 | 1 | 2 | | 0 | 277196 | 1 | 28802 | 1 | 0 | | | | | | | |
| 28804 | ora_w001_orcl | | ora_w001_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 27044000 | 2008308000 | 2 | 3 | | 0 | 277199 | 1 | 28804 | 1 | 0 | | | | | | | |
| 28814 | ora_w005_orcl | | ora_w005_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 27636000 | 2009332000 | 2 | 2 | | 0 | 277223 | 1 | 28814 | 1 | 0 | | | | | | | |
| 28816 | ora_w000_orcl | | ora_w000_ORCL | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 27764000 | 2009328000 | 2 | 2 | | 0 | 277226 | 1 | 28816 | 1 | 0 | | | | | | | |
| 28937 | osqueryi | /usr/bin/osqueryd | osqueryi | R | / | / | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 10880000 | 200624000 | 10 | 7 | 2433024 | 24576 | 277409 | 28661 | 28937 | 4 | 0 | | 4026532482 | 4026532480 | 4026532485 | 4026532483 | 4026531837 | 4026532481 |
| 2913 | tail | | tail -f /opt/oracle/diag/rdbms/orcl/ORCL/trace/alert_ORCL.log | S | | | 54321 | 54321 | 54321 | 54321 | 54321 | 54321 | -1 | 0 | 116000 | 4400000 | 223 | 683 | | 0 | 24252 | 1 | 1 | 1 | 0 | | | | | | | |
+-------+---------------+-------------------+---------------------------------------------------------------------+-------+-----+------+-------+-------+-------+-------+-------+-------+---------+------------+---------------+------------+-----------+-------------+-----------------+--------------------+------------+--------+--------+---------+------+------------------+---------------+---------------+---------------+---------------+----------------+---------------+
osquery>
osquery> select * from listening_ports;
+-------+-------+----------+--------+-----------+----+----------+----------------------------+---------------+
| pid | port | protocol | family | address | fd | socket | path | net_namespace |
+-------+-------+----------+--------+-----------+----+----------+----------------------------+---------------+
| -1 | 1521 | 6 | 2 | 0.0.0.0 | -1 | 352599 | | 0 |
| -1 | 33371 | 6 | 2 | 0.0.0.0 | -1 | 383090 | | 0 |
| -1 | 5500 | 6 | 2 | 0.0.0.0 | -1 | 384079 | | 0 |
| -1 | 38365 | 17 | 2 | 0.0.0.0 | -1 | 384521 | | 0 |
| -1 | 46666 | 17 | 2 | 127.0.0.1 | -1 | 383085 | | 0 |
| -1 | 42601 | 17 | 2 | 0.0.0.0 | -1 | 25442397 | | 0 |
| -1 | 34923 | 17 | 2 | 127.0.0.1 | -1 | 383100 | | 0 |
| -1 | 55504 | 17 | 2 | 127.0.0.1 | -1 | 382554 | | 0 |
| -1 | 37303 | 17 | 2 | 0.0.0.0 | -1 | 25443523 | | 0 |
| -1 | 0 | 0 | 1 | | -1 | 0 | /var/tmp/.oracle/sEXTPROC1 | 0 |
| -1 | 0 | 0 | 1 | | -1 | 0 | /var/tmp/.oracle/s#26.1 | 0 |
| -1 | 0 | 0 | 1 | | -1 | 0 | /var/tmp/.oracle/s#26.2 | 0 |
| 28937 | 0 | 0 | 1 | | 7 | 0 | /root/.osquery/shell.em | 0 |
| -1 | 1521 | 6 | 2 | 0.0.0.0 | -1 | 352599 | | 4026532485 |
| -1 | 33371 | 6 | 2 | 0.0.0.0 | -1 | 383090 | | 4026532485 |
| -1 | 5500 | 6 | 2 | 0.0.0.0 | -1 | 384079 | | 4026532485 |
| -1 | 38365 | 17 | 2 | 0.0.0.0 | -1 | 384521 | | 4026532485 |
| -1 | 46666 | 17 | 2 | 127.0.0.1 | -1 | 383085 | | 4026532485 |
| -1 | 42601 | 17 | 2 | 0.0.0.0 | -1 | 25442397 | | 4026532485 |
| -1 | 34923 | 17 | 2 | 127.0.0.1 | -1 | 383100 | | 4026532485 |
| -1 | 55504 | 17 | 2 | 127.0.0.1 | -1 | 382554 | | 4026532485 |
| -1 | 37303 | 17 | 2 | 0.0.0.0 | -1 | 25443523 | | 4026532485 |
| -1 | 0 | 0 | 1 | | -1 | 0 | /var/tmp/.oracle/sEXTPROC1 | 4026532485 |
| -1 | 0 | 0 | 1 | | -1 | 0 | /var/tmp/.oracle/s#26.1 | 4026532485 |
| -1 | 0 | 0 | 1 | | -1 | 0 | /var/tmp/.oracle/s#26.2 | 4026532485 |
| 28937 | 0 | 0 | 1 | | 7 | 0 | /root/.osquery/shell.em | 4026532485 |
+-------+-------+----------+--------+-----------+----+----------+----------------------------+---------------+
osquery>
sql oracle clone pluggable database
[oracle@609a69bc0b21 ~]$ cd $ORACLE_BASE
[oracle@609a69bc0b21 oracle]$ ll
total 40
drwxr-x---. 3 oracle oinstall 18 Dec 23 13:11 admin
drwxr-x---. 2 oracle oinstall 6 Dec 23 13:11 audit
drwxr-x---. 4 oracle oinstall 34 Dec 23 13:22 cfgtoollogs
-rwxrwxrwx. 1 oracle dba 1148 Dec 8 00:58 checkDBStatus.sh
drwxr-xr-x. 2 oracle dba 6 Dec 23 08:52 checkpoints
-rwxrwxrwx. 1 oracle dba 2953 Dec 8 00:58 createDB.sh
-rwxrwxrwx. 1 oracle dba 9204 Dec 8 00:58 dbca.rsp.tmpl
drwxrwxr-x. 1 oracle dba 34 Dec 23 08:52 diag
drwxrwx---. 1 oracle dba 89 Dec 23 08:52 oraInventory
drwxr-xr-x. 4 oracle dba 34 Dec 23 13:29 oradata
drwxr-xr-x. 1 oracle dba 22 Dec 23 08:20 product
-rwxrwxrwx. 1 oracle dba 6526 Dec 8 00:58 runOracle.sh
-rwxrwxrwx. 1 oracle dba 1015 Dec 8 00:58 runUserScripts.sh
drwxr-xr-x. 1 oracle dba 34 Dec 23 08:20 scripts
-rwxrwxrwx. 1 oracle dba 758 Dec 8 00:58 setPassword.sh
-rwxrwxrwx. 1 oracle dba 678 Dec 8 00:58 startDB.sh
[oracle@609a69bc0b21 oracle]$ cd oradata
[oracle@609a69bc0b21 oradata]$ ll
total 0
drwxr-x---. 5 oracle oinstall 239 Dec 25 12:14 ORCL
drwxr-xr-x. 3 oracle oinstall 18 Dec 23 13:29 dbconfig
[oracle@609a69bc0b21 oradata]$ cd ORCL
[oracle@609a69bc0b21 ORCL]$ ll
total 2263508
drwxr-x---. 2 oracle oinstall 104 Dec 23 13:29 PDB1
drwxr-x---. 2 oracle oinstall 104 Dec 25 12:14 PDB2
-rw-r-----. 1 oracle oinstall 18726912 Dec 25 14:29 control01.ctl
-rw-r-----. 1 oracle oinstall 18726912 Dec 25 14:29 control02.ctl
drwxr-x---. 2 oracle oinstall 111 Dec 23 13:18 pdbseed
-rw-r-----. 1 oracle oinstall 209715712 Dec 25 00:05 redo01.log
-rw-r-----. 1 oracle oinstall 209715712 Dec 25 14:28 redo02.log
-rw-r-----. 1 oracle oinstall 209715712 Dec 24 22:06 redo03.log
-rw-r-----. 1 oracle oinstall 597696512 Dec 25 14:25 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 849354752 Dec 25 14:27 system01.dbf
-rw-r-----. 1 oracle oinstall 137371648 Dec 25 00:45 temp01.dbf
-rw-r-----. 1 oracle oinstall 73408512 Dec 25 14:27 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 5251072 Dec 25 00:10 users01.dbf
[oracle@609a69bc0b21 ORCL]$ pwd
/opt/oracle/oradata/ORCL
[oracle@609a69bc0b21 ORCL]$ sqlplus sys/ORACLE_PWD as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 14:30:43 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SYS@ORCL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SYS@ORCL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
------------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
SYS@ORCL> create pluggable database PDB3 from PDB1 FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCL/PDB1','/opt/oracle/oradata/ORCL/PDB3');
Pluggable database created.
Elapsed: 00:00:09.26
SYS@ORCL> create pluggable database PDB4 from PDB1 FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCL/PDB1','/opt/oracle/oradata/ORCL/PDB4');
Pluggable database created.
Elapsed: 00:00:10.38
SYS@ORCL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
------------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 MOUNTED
6 PDB4 MOUNTED
SYS@ORCL> alter pluggable database all open;
Pluggable database altered.
Elapsed: 00:00:25.74
SYS@ORCL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
------------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
6 PDB4 READ WRITE NO
SYS@ORCL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@609a69bc0b21 ORCL]$ sqlplus sys/ORACLE_PWD@pdb3 as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 14:37:14 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: [oracle@609a69bc0b21 ORCL]$
[oracle@609a69bc0b21 ORCL]$ find / -name tnsnames.ora -type f 2>/dev/null
/opt/oracle/product/12.2.0.1/dbhome_1/network/admin/samples/tnsnames.ora
/opt/oracle/oradata/dbconfig/ORCL/tnsnames.ora
[oracle@609a69bc0b21 ORCL]$ vim /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora
ORCL=localhost:1521/ORCL
PDB1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDB1)
)
)
PDB2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDB2)
)
)
PDB3=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDB3)
)
)
PDB4=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDB4)
)
)
[oracle@609a69bc0b21 ORCL]$ sqlplus sys/ORACLE_PWD@pdb3 as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 14:40:02 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SYS@pdb3> show con_name
CON_NAME
------------------------------
PDB3
SYS@pdb3> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@609a69bc0b21 ORCL]$ sqlplus sys/ORACLE_PWD@pdb4 as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 14:40:30 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SYS@pdb4> show con_name
CON_NAME
------------------------------
PDB4
SYS@pdb4> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@609a69bc0b21 ORCL]$ sqlplus aine/ORACLE_PWD@pdb3
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 14:41:10 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Tue Dec 25 2018 11:50:03 +00:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
AINE@pdb3> select * from warehouse_mst;
WAREHOUSE_CODE SHIPPING_PERMISSION_OVER_DAYS
------------------------ -----------------------------
w_BS98 25
w_DIX4 28
w_C5MN 29
3 rows selected.
Elapsed: 00:00:00.07
AINE@pdb3> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@609a69bc0b21 ORCL]$ sqlplus aine/ORACLE_PWD@pdb4
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 14:41:38 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Tue Dec 25 2018 11:50:03 +00:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
AINE@pdb4> select * from warehouse_mst;
WAREHOUSE_CODE SHIPPING_PERMISSION_OVER_DAYS
------------------------ -----------------------------
w_BS98 25
w_DIX4 28
w_C5MN 29
3 rows selected.
Elapsed: 00:00:00.06
AINE@pdb4> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@609a69bc0b21 ORCL]$ ll
total 2263564
drwxr-x---. 2 oracle oinstall 104 Dec 23 13:29 PDB1
drwxr-x---. 2 oracle oinstall 104 Dec 25 12:14 PDB2
drwxr-x---. 2 oracle oinstall 104 Dec 25 14:33 PDB3
drwxr-x---. 2 oracle oinstall 104 Dec 25 14:33 PDB4
-rw-r-----. 1 oracle oinstall 18726912 Dec 25 14:41 control01.ctl
-rw-r-----. 1 oracle oinstall 18726912 Dec 25 14:41 control02.ctl
drwxr-x---. 2 oracle oinstall 111 Dec 23 13:18 pdbseed
-rw-r-----. 1 oracle oinstall 209715712 Dec 25 00:05 redo01.log
-rw-r-----. 1 oracle oinstall 209715712 Dec 25 14:41 redo02.log
-rw-r-----. 1 oracle oinstall 209715712 Dec 24 22:06 redo03.log
-rw-r-----. 1 oracle oinstall 597696512 Dec 25 14:41 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 849354752 Dec 25 14:41 system01.dbf
-rw-r-----. 1 oracle oinstall 137371648 Dec 25 14:36 temp01.dbf
-rw-r-----. 1 oracle oinstall 73408512 Dec 25 14:41 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 5251072 Dec 25 00:10 users01.dbf
[oracle@609a69bc0b21 ORCL]$
sql oracle 12cr2 dblink
[oracle@b51cf2f967ec ~]$ find / -name tnsnames.ora -type f 2>/dev/null
/opt/oracle/product/12.2.0.1/dbhome_1/network/admin/samples/tnsnames.ora
/opt/oracle/oradata/dbconfig/ORCL/tnsnames.ora
[oracle@b51cf2f967ec ~]$ cd /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/
[oracle@b51cf2f967ec admin]$ pwd
/opt/oracle/product/12.2.0.1/dbhome_1/network/admin
[oracle@b51cf2f967ec admin]$ ll
total 4
lrwxrwxrwx. 1 oracle oinstall 46 Dec 24 14:00 listener.ora -> /opt/oracle/oradata/dbconfig/ORCL/listener.ora
drwxr-xr-x. 1 oracle dba 6 Dec 25 20:21 samples
-rw-r--r--. 1 oracle dba 1441 Aug 28 2015 shrept.lst
lrwxrwxrwx. 1 oracle oinstall 44 Dec 24 14:00 sqlnet.ora -> /opt/oracle/oradata/dbconfig/ORCL/sqlnet.ora
lrwxrwxrwx. 1 oracle oinstall 46 Dec 24 14:00 tnsnames.ora -> /opt/oracle/oradata/dbconfig/ORCL/tnsnames.ora
[oracle@b51cf2f967ec admin]$ vim tnsnames.ora
ORCL=localhost:1521/ORCL
PDB1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDB1)
)
)
RMTPDB2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.108)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PDB2)
)
)
[oracle@b51cf2f967ec admin]$ sqlplus sys/ORACLE_PWD@pdb1 as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 23:18:50 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SYS@pdb1> grant create database link to aine;
Grant succeeded.
Elapsed: 00:00:00.05
SYS@pdb1> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@b51cf2f967ec admin]$ sqlplus aine/ORACLE_PWD@pdb1
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 25 23:19:35 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Tue Dec 25 2018 22:39:49 +09:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
AINE@pdb1> CREATE DATABASE LINK testlink CONNECT TO aine IDENTIFIED BY ORACLE_PWD USING 'RMTPDB2';
CREATE DATABASE LINK testlink CONNECT TO aine IDENTIFIED BY ORACLE_PWD USING 'RMTPDB2'
*
ERROR at line 1:
ORA-02011: duplicate database link name
Elapsed: 00:00:00.01
AINE@pdb1> drop database link testlink;
Database link dropped.
Elapsed: 00:00:00.01
AINE@pdb1> CREATE DATABASE LINK testlink CONNECT TO aine IDENTIFIED BY ORACLE_PWD USING 'RMTPDB2';
Database link created.
Elapsed: 00:00:00.01
AINE@pdb1> select * from warehouse_mst@testlink;
WAREHOUSE_CODE SHIPPING_PERMISSION_OVER_DAYS
------------------------ -----------------------------
w_BS98 25
w_DIX4 28
w_C5MN 29
w_9999 25
4 rows selected.
Elapsed: 00:00:00.35
AINE@pdb1>
docker run timezone TZ=Asia/Tokyo
docker run -v /home/oracle/doclan:/mnt -v /home/oracle/doclan/12cr2/init:/docker-entrypoint-initdb.d/startup -d --name orcl_12cr2 --shm-size=4g -p 1521:1521 -p 5500:5500 -e TZ=Asia/Tokyo -e ORACLE_PWD=ORACLE_PWD -e ORACLE_SID=ORCL -e ORACLE_PDB=pdb1 oracle/database:12.2.0.1-ee
oracle 12cr2 plugable database glogin.sql
参考文献
http://discus-hamburg.cocolog-nifty.com/mac_de_oracle/2013/07/oracle-database.html
COLUMN OTHER_PLUS_EXP FORMAT A200
COLUMN PLAN_PLUS_EXP FORMAT A200
SET NUMWIDTH 13
SET LINESIZE 1000
SET LONG 40000
SET LONGCHUNKSIZE 40000
SET PAGESIZE 50000
SET SERVEROUTPUT ON
SET TAB OFF
SET TRIMSPOOL ON
set feed on
--set autotrace traceonly
set timing on
--set hist on
DEFINE_EDITOR=nano
set sqlp "_USER'@'_CONNECT_IDENTIFIER> "
[oracle@centos7 ~]$ docker exec -it orcl_12cr2 /bin/bash
[oracle@609a69bc0b21 ~]$ vim
[oracle@609a69bc0b21 ~]$ find / -name *login*.sql -type f 2>/dev/null
/mnt/11gr2/share/login/glogin.sql
/opt/oracle/product/12.2.0.1/dbhome_1/sqlplus/admin/glogin.sql
[oracle@609a69bc0b21 ~]$ vim /opt/oracle/product/12.2.0.1/dbhome_1/sqlplus/admin/glogin.sql
[oracle@609a69bc0b21 ~]$ sqlplus sys/ORACLE_PWD as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 23 14:49:53 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SYS@ORCL>
SYS@ORCL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@609a69bc0b21 ~]$ sqlplus sys/ORACLE_PWD@pdb1 as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 23 14:50:22 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SYS@pdb1> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
docker root login
[oracle@centos7 ~]$ docker exec --interactive --tty --user root --workdir / orcl_12cr2 bash
bash-4.2# whoami
root
bash-4.2# yum install -y vim
Complete!
bash-4.2# vim
bash-4.2# exit
[oracle@centos7 ~]$sql oracle test
SELECT
*
FROM
(SELECT LEVEL AS rn FROM dual CONNECT BY LEVEL <=10)
MODEL
DIMENSION BY (rn)
MEASURES(
1 AS val_asc
,CAST(NULL AS VARCHAR2(4000)) AS ope_asc
,row_number () OVER (ORDER BY rn DESC) AS rnn
,MAX(rn) OVER () AS val_desc
,CAST(NULL AS VARCHAR(4000)) AS ope_desc
)
RULES(
val_asc[rn] ORDER BY rn ASC = nvl(val_asc[cv() - 1],1) * cv(rn)
,ope_asc[rn] ORDER BY rn ASC = to_char(nvl(ope_asc[cv() - 1],NULL)) || CASE WHEN to_char(nvl(ope_asc[cv() - 1],NULL)) IS NULL THEN NULL ELSE ' * ' END || to_char(cv(rn))
,val_desc[rn] ORDER BY rnn DESC = nvl(val_desc[cv() - 1],1) * rnn[cv()]
,ope_desc[rn] ORDER BY rnn DESC = to_char(nvl(ope_desc[cv() - 1],NULL)) || CASE WHEN to_char(nvl(ope_desc[cv() - 1],NULL)) IS NULL THEN NULL ELSE ' * ' END || to_char(rnn[cv()])
)
ORDER BY rn
;