see also Oracle Database 19c Installation On Oracle Linux 7 (OL7)
ssh root@n0s0
sudo yum install oracle-database-preinstall-19c.x86_64
passwd oracle
reboot
DECLARE | |
-- This example shows the basic usage and behavior of the Nested List. | |
TYPE t_list IS table of integer; | |
v_list t_list; | |
v_max_size integer := 0; | |
PROCEDURE print_count_and_last IS |
// This script exports exports the current schema into files | |
// based on https://gist.github.com/krisrice/de6f694b5241682059968bd5beadbcf7 | |
// | |
// Usage: SQL> script export_ddl | |
(function(){ | |
var verbose = false; | |
var CopyOption = Java.type("java.nio.file.StandardCopyOption"); | |
var ddlPath = java.nio.file.FileSystems.getDefault().getPath('ddl'); |
/* FETCH Command for SQLcl | |
* FETCH is like EXEC but for functions instead of procedures. | |
* Usage: | |
* SQL> script fetch.js | |
* SQL> fetch SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') | |
* SYS_CONTEXT('USERENV','CURRENT_SCHEMA') | |
* --------------------------------------- | |
* CMU | |
*/ |
see also Oracle Database 19c Installation On Oracle Linux 7 (OL7)
ssh root@n0s0
sudo yum install oracle-database-preinstall-19c.x86_64
passwd oracle
reboot
# Move the root filesystem from single disk to a RAID 1 without downtime | |
root$ df -h | |
Filesystem Size Used Avail Use% Mounted on | |
devtmpfs 7.7G 0 7.7G 0% /dev | |
tmpfs 7.7G 0 7.7G 0% /dev/shm | |
tmpfs 7.7G 8.8M 7.7G 1% /run | |
tmpfs 7.7G 0 7.7G 0% /sys/fs/cgroup | |
/dev/mapper/vg-root 5.2G 1.4G 3.5G 29% / | |
/dev/sdb1 922M 143M 732M 17% /boot |
-- https://docs.oracle.com/en/database/oracle/oracle-database/18/adlob/using-DBFS.html#GUID-8735D535-2E13-4702-95F9-01F931F2BF46 | |
-- see: https://oracle-base.com/articles/12c/dbfs-enhancements-12cr1 | |
-- https://docs.oracle.com/database/121/ADLOB/adlob_client.htm#ADLOB46187 | |
-- AS SYSDBA | |
-- Create Tablespace | |
CREATE TABLESPACE dbfs_ts | |
DATAFILE '/opt/oracle/oradata/XE/XEPDB1/dbfs01.dbf' | |
SIZE 1M AUTOEXTEND ON NEXT 1M; | |
# /etc/bash_completion.d/disable | |
# Disables the new behaviorfor bash completion (>=4.2) | |
# | |
# $ ls $HOME/.bash<tab><tab> | |
# | |
# new behavior: | |
# $ ls \$HOME/.bash | |
# | |
# old behaivor: | |
# .bash_history .bash_logout .bash_profile .bashrc |
#!/usr/bin/env bash | |
# The following variables are used to describe this script in detail | |
description="$(basename $0): DESCRIPTION" | |
version="0.0.1-dev" | |
author="AUTHOR" | |
usage_info=" | |
Usage: $(basename $0) ARGS | |
Arguments: | |
... |
<project> | |
... | |
<properties> | |
<!-- Datbase --> | |
<db.host>oradev</db.host> | |
<db.port>1521</db.port> | |
<db.service>dev.loc</db.service> | |
<db.user.test>TEST</db.user.test> | |
<db.pw.test>test</db.pw.test> | |