Wednesday, April 22, 2020

Oracle alter version control

create table fox_version
versionid number not null
version_date date default systimestamp

create unique index UK on fox_version ('1');

create user
grant view
grant unlimited tablespace
grant imp_full_dat    
grant connect
grant resource


Monday, January 6, 2020

Oracle 19c

Oracle 19c (12.2.0.3)

install

DISPLAY=localhost:0.0
export DISPLAY

global database name= orcl.cgi.com
SID=CUCSDB

ORACLE_BASE /ora/cucs/root

ORACLE_HOME=$ORACLE_BASE/19c/software

ORACLE_ROOT=/ora/c/root/cdb/19c

data=$ORACLE_ROOT/data

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/introduction-to-oracle-database.html#GUID-2B1BADE1-C36F-4555-9867-3B15B6CE858C


Container CDB
Pluggable PDB (multi tennant) in CDB

Remote Standby Database with Observer


A file system enables disk space to be allocated to many files. Each file has a name and is made to appear as a contiguous address space to applications such as Oracle Database. The database can create, read, write, resize, and delete files.
A file system is commonly built on top of a logical volume constructed by a software package called a logical volume manager (LVM). The LVM enables pieces of multiple physical disks to combine into a single contiguous address space that appears as one disk to higher layers of software.


/etc/oratab mounts db startup
/etc/fstab mount points

adrci > show alert

lsnrctl LISTNER

yum inst zip/unzip/xauth/vim
install xming modify XO.hosts
start xming :0.0
/etc/ssh/sshd_config
X11Fowarding yes
X11DisplayOffset 10
XAuthLocation /usr/bin/xauth
sudo systemctl restart sshd
puty ssh>x11>enable x11 forwarding
Xdisplay location localhost:0.0
./runInstaller

/ud1/oradata
/ue1/datapump
/uf1/fast_recovery_area
/us1/app/oracle/product/19/db_1/runInstaller
/us1/software - patches
/us1/tmp_install