Oracle Database installation completed with errors solve | Sqldeveloper DB Query | User Permission
Oracle all Database installation completed with errors solve | Sqldeveloper client tool | DB Query | User Permission for remote access and importants docs:-
Oracle 19c download (or download according to your version):-
https://www.oracle.com/in/database/te...
Oracle sqldeveloper client (download other option if require for linux or use according to OS):-
https://www.oracle.com/database/sqlde...
curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLin...
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
for dependency issue solve:-
https://gist.github.com/kofemann/acd5...
vim ~/.bashrc
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3/db_home
export ORACLE_SID=CDB
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
#export NLS_LANG=american_america.al32utf8
export NLS_DATE_FORMAT="yyyy-mm-dd:hh24:mi:ss"
PATH=$PATH:$HOME/.local/bin:$ORACLE_HOME/bin
export PATH
export CV_ASSUME_DISTID=OEL7.8
export PDB_NAME=pdb
export ORA_INVENTORY=/u01/app/oraInventory
export DATA_DIR=/u02/oradata
install in silent========
./runInstaller -ignorePrereq -waitforcompletion -silent \
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp \
oracle.install.option=INSTALL_DB_SWONLY \
ORACLE_HOSTNAME=${ORACLE_HOSTNAME} \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=${ORA_INVENTORY} \
SELECTED_LANGUAGES=en,en_GB \
ORACLE_HOME=${ORACLE_HOME} \
ORACLE_BASE=${ORACLE_BASE} \
oracle.install.db.InstallEdition=EE \
oracle.install.db.OSDBA_GROUP=dba \
oracle.install.db.OSBACKUPDBA_GROUP=dba \
oracle.install.db.OSDGDBA_GROUP=dba \
oracle.install.db.OSKMDBA_GROUP=dba \
oracle.install.db.OSRACDBA_GROUP=dba \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true
FS is normal database, PDB, SID must be define in bashrc:-
$ dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname ${ORACLE_SID} -sid ${ORACLE_SID} -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword yourpassword \
-systemPassword yourpassword \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName ${PDB_NAME} \
-pdbAdminPassword yourpassword \
-databaseType MULTIPURPOSE \
-memoryMgmtType auto_sga \
-totalMemory 2000 \
-storageType FS \
-datafileDestination "${DATA_DIR}" \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs
Watch video Oracle Database installation completed with errors solve | Sqldeveloper DB Query | User Permission online without registration, duration hours minute second in high quality. This video was added by user Mr. Duvi Tech 13 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 453 once and liked it 15 people.