Users missing create job priv

Seeing this in 19c for a lot of new users that we are building out.

It seems that users are missing the create job priv, needs to be added.

From Oracle Metalink.

In 19c Database "ORA-27486: insufficient privileges" Error Encountered. 

(Doc ID 2608325.1)

ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 9387
ORA-06512: at "SYS.DBMS_ISCHED", line 9376
ORA-06512: at "SYS.DBMS_ISCHED", line 175
ORA-06512: at "SYS.DBMS_ISCHED", line 9302
ORA-06512: at "SYS.DBMS_IJOB", line 196
ORA-06512: at "SYS.DBMS_JOB", line 168
ORA-06512: at line 3

CAUSE

....... user does not have create job privilege.
It is a known issue and an enhancement bug is already there to fix this privilege issue.

SOLUTION

Please grant the following to ...... user and the script works fine after that:

SQL> grant create job to .......;

Oracle Metalink down....

Database issue ? Not impressed.

I was wanting to access a document and can't.

Come on Oracle.

Oracle Install - quick notes

Quick notes - will format etc later. This for 12.2 but will amend for 19c


sudo su -

yum install oracle-database-server-12cR2-preinstall

yum install oracle-database-preinstall-19c

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index_src.html

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

https://oracle-base.com/articles/12c/oracle-db-12cr1-installation-on-oracle-linux-7

yum install xorg-x11-xauth xorg-x11-fonts-* xorg-x11-font-utils xorg-x11-fonts-Type1

yum install xclock


groupadd -g 54327 asmdba

groupadd -g 54328 asmoper

groupadd -g 54329 asmadmin

useradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper,racdba,dba grid

mkdir --parents /u01/app/12.2.0/gridhome

chown --recursive grid:oinstall /u01

usermod -a -G asmdba oracle

mkdir --parents /u01/app/oracle/product/12.2.0/dbhome_1

passwd oracle

mkdir --parents /u99/media/software/cubic

chown --recursive oracle:oinstall /u99/media

cd /u99/media/software

mkdir database

chown oracle:oinstall database

cd /backup

mkdir --parents /oracle/archlogs

cd /oracle

mkdir database_backups

cd archlogs

mkdir ngtapp

mkdir ngtods

cd ../database_backups

mkdir ngtapp

mkdir ngtods

cd ngtapp

mkdir logs

chown --recursive oracle:oinstall /backup

COPY THE SOURCE FILES ACROSS

INSTALL ASM

cd /u01/app/12.2.0/gridhome
cp /u99/media/software/database/linuxx64_12201_grid_home.zip .

unzip linuxx64_12201_grid_home.zip

chown -R grid:oinstall /u01/app/12.2.0/gridhome

df -h | grep tmp

/dev/mapper/VGroot-LVtmp 9.8G 37M 9.2G 1% /tmp

cat /proc/meminfo check for 16GB of swap space

/etc/hostname
This will return the hostname of the server

cat /etc/sysconfig/selinux need to grep for SELINUX=enforcing and SELINUXTYPE=targeted and stop of not correct

vi /etc/security/limits.conf

append to bottom of file

grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240

systemctl disable firewalld

cat /sys/kernel/mm/transparent_hugepage/enabled should be always madvise [never]
cat /etc/default/grub look for transparent_hugepage=never

su - root
cd /u01/app/12.2.0/gridhome/cv/rpm/
rpm -qi cvuqdisk

export CVUQDISK_GRP=oinstall
rpm -iv cvuqdisk-1.0.10-1.rpm


Prior to installing grid software

exit
sudo su - grid

cd /u01/app/12.2.0/gridhome
./runcluvfy.sh stage -pre crsinst -n auzaetngtods01

INSTALL GRID

as root
passwd grid

Create Mobaxterm session logging in directly as grid
export LC_ALL=C
xclock

sudo su - grid
cd /u01/app/12.2.0/gridhome/
./gridSetup.sh

'Configure Oracle grid infrastructure for standalone server (Oracle restart)'

Install Oracle software

su - oracle
mkdir /u99/media/software/database/DATABASE
cp /u99/media/software/database/linuxx64_12201_database.zip /u99/media/software/database/DATABASE
cd /u99/media/software/database/DATABASE
unzip linuxx64_12201_database.zip

export LC_ALL=C
cd database
./runInstaller

'install database software only'

'single instance database installation'

Enterprise edition

Change software location back to '/u01/app/oracle/product/12.2.0/dbhome_1'