Ubuntu 18.0.4 LTS and Oracle VirtualBox

Need Ubuntu 18.0.4 –

  • Ubuntu Server 18.04.2 LTS

https://www.ubuntu.com/download/server

  • Download VirtualBox

https://www.virtualbox.org/wiki/Downloads

Ubuntu is light weight, once installUbuntu: CTL+ALT+ T to create the terminal session

Make sure that the computer is connected to the internet for all updates, including VirtualBox

$sudo apt install virtualbox

$sudo apt install virtualbox-ext-pack (press <TAB> to highlight the <ok> option and install


Setting up VirtualBox

  • CPU 4,
  • memory: 4GB,
  • network Bridged and
  • filesize 50Gb
  • Virtual CD/DVD-ISO use the Oracle linux 7.5 ISO, it will boot the Oracle linux installation
    • Install with GUI option
    • select all tools option
    • reclaim all spaces
    • Internet enable

Steps to pre-install global settings for Oracle 11g.

How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6

https://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html

 


  1. As an authorized user (for example, root), retrieve the file that configures repository locations:
    # cd /etc/yum.repos.d
    
    # wget http://yum.oracle.com/public-yum-ol6.repo
    
    
  2. Using a text editor, modify the file, changing the field enabled=0 to enabled=1 to reflect repositories that correspond to the machine’s operating system release.Here is an excerpt of public-yum-old6.repo with the changed lines in boldface.
    [ol6_latest]
    
    name=Oracle Linux $releasever Latest ($basearch)
    
    baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/
    
    gpgkey=http://yum.oracle.com/RPM-GPG-KEY-oracle-ol6
    
    gpgcheck=1
    
    enabled=1
    
    
    
    
    
    [ol6_UEK_latest]
    
    name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)
    
    baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/
    
    gpgkey=http://yum.oracle.com/RPM-GPG-KEY-oracle-ol6
    
    gpgcheck=1
    
    enabled=1
    

    Because the target system is running Oracle Linux Release 6 Update 4 for x86_64, which installs the Oracle Unbreakable Enterprise Kernel by default, there are two repositories to enable, [ol6_latest] and [ol6_UEK_latest].

  3. Next, install the oracle-rdbms-server-11gR2-preinstall RPM using the yum install command. If you are using Oracle Database 12c, then you would type yum install.The output in Listing 1 shows how the installation checks dependencies and then downloads and installs the required packages.
    # yum install oracle-rdbms-server-11gR2-preinstall 
    # yum install oracle-rdbms-server-12cR2-preinstall

 

# groupadd dba
# groupadd oinstall
# useradd -m -g oinstall -G dba oracle

# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app
# chmod -R 775 /u01/app

 

sftp oracle 11 zipped files or USB

unzip files-01.zip
unzip files-02.zip

Moba Xterm

https://mobaxterm.mobatek.net/download-home-edition.html

https://download.mobatek.net/1112019010310554/MobaXterm_Portable_v11.1.zip

$ssh -XY oracle@

Refresh/restart icfonfig

#/etc/i,initd/network restart

#ifconfig

Root:
1. disable firewall
#vi /etc/selinux/config
SELINUX=disabled
#serice iptables stop
#service network restart

2. 11g.sh

export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=/usr/bin:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib64
export CLASSPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib

mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/11.2.0/db_1

#vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304

# /sbin/sysctl -p
# /sbin/sysctl -a

Posted in VirtualBox | Comments Off on Ubuntu 18.0.4 LTS and Oracle VirtualBox

win 10 – remove Oracle

  1. stop services
  2. rm appl, programfiles\oracle\inventory
  3. regedit  —  software — oracle, currentControlset\service — oracle
  4. Environment ORACLE_HOME, path adjust
Posted in Uncategorized | Comments Off on win 10 – remove Oracle

simh – openvms vax.ini

; Load CPU microcode
load -r /usr/local/vax/data/ka655.bin
;
; Attach non-volatile RAM to a file
attach nvr /usr/local/vax/data/nvram.bin
;
; This virtual machine has 64M memory
set cpu 64m
;
; Define disk drive types. RA92 is largest-supported VAX drive.
set rq0 ra92
set rq1 ra92
set rq2 ra92
set rq3 cdrom
;
; Attach defined drives to local files
attach rq0 /usr/local/vax/data/d0.dsk
attach rq1 /usr/local/vax/data/d1.dsk
attach rq2 /usr/local/vax/data/d2.dsk
;
; Attach the CD-ROM to its file (read-only)
attach -r rq3 /usr/local/vax/data/cd.iso
;
; Disable unused devices. It’s also possible to disable individual devices,
; using a construction like “set rq2 disable” if desired.
;
set rl disable
set ts disable
;
; Attach Ethernet to a network interface
set xq mac=08-00-2B-AA-BB-CC
attach xq eth0
;
; Now start the emulator
boot cpu

Posted in Uncategorized | Comments Off on simh – openvms vax.ini

simh – window

github.com/simh

Wincap 4.1.3

vax.ini

set cpu 64m
at nvr vax.nvr

set rq0 rauser=5000
at rq0 openvms_73.disk
set rq3 rrd40
at rq3 /0-Emulator/VAX/VAX73.iso
;at rq3 /0-Emulator/VAX/LICS.iso

set XQ MAC=10:60:4B:66:A9:C7
at XQ eth0

Posted in Uncategorized | Comments Off on simh – window

Make

sudo apt install make

sudo apt install make-guile

sudo apt install gcc

 

Posted in Uncategorized | Comments Off on Make

Oracle – change database character set

SELECT * FROM nls_database_parameters;

How to change:

ALTER DATABASE CHARACTER SET AL32UTF8; To change the database character set, perform the following steps: Shut down the database, using either a SHUTDOWN IMMEDIATE or a SHUTDOWN NORMAL statement.

STARTUP MOUNT; ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0; A
LTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET new_character_set;
SHUTDOWN IMMEDIATE; — or SHUTDOWN NORMAL; STARTUP

 

xxxxxxxxxxxx
1) SHUTDOWN IMMEDIATE;

2) STARTUP RESTRICT;

3) ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

4) ALTER SYSTEM DISABLE RESTRICTED SESSION;

5) select value from NLS_DATABASE_PARAMETERS where PARAMETER = ‘NLS_CHARACTERSET’;

5th step should return the value AL32UTF8

xxxxxxxxxxxx
select value
from nls_database_parameters
where parameter=’NLS_CHARACTERSET’;

3. Log into the database and do a clean shutdown of the database.

1
SHUTDOWN IMMEDIATE;
If for whatever reason, the database does not get shut down cleanly (via a shutdown immediate command), start it back up in restrict mode and shut it down again.

4. Mount the database.

1
STARTUP MOUNT;
5. Restrict logon to the database, disable job processes and queue processes.

1
2
3
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
6. Open the database.

1
ALTER DATABASE OPEN;
7. Change the character set (instead of &CHARSET use the proper character set, e.g. ‘EE8MSWIN1250’).

1
ALTER DATABASE CHARACTER SET INTERNAL_USE &CHARSET;
8. You can also change the national character set (instead of &NCHARSET use the proper character set, e.g. ‘AL16UTF16’)

1
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET;
9. Make a clean shutdown of the database.

1
SHUTDOWN IMMEDIATE;
10. Start it up.

1
STARTUP;

Posted in Uncategorized | Comments Off on Oracle – change database character set

Running VAX/VMS Under Linux Using SIMH

simh 2.104: https://osdn.net/projects/sfnet_simh/downloads/simh%20source%20code/Older%20versions/simhv210-4.zip/

 

https://www.wherry.com/gadgets/retrocomputing/vax-simh.html

win 10: https://github.com/simh/Win32-Development-Binaries

Posted in Uncategorized | Comments Off on Running VAX/VMS Under Linux Using SIMH

Using SET TERMINAL

https://flylib.com/books/en/2.312.1.90/1/

 

set term/width=132/page=80

Posted in Uncategorized | Comments Off on Using SET TERMINAL

Oracle pre-installation

https://docs.oracle.com/cd/E16338_01/install.112/e56668/pre_inst.htm#OIDBI1014

Posted in Uncategorized | Comments Off on Oracle pre-installation

Getting started with openVMS

https://flylib.com/books/en/2.312.1/

Posted in Uncategorized | Comments Off on Getting started with openVMS