About of Database Systems and Information Technologies
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
Oracle database is most used rdbms database system. I will mention how install oracle database 19c version on Oracle Linux 8 operating system. Also, I will apply Oracle 19.22 release update patch after 19c installation. I am using VMware virtualization to infrastructure. Operating system is Oracle Linux 8.9. First Step : Configure Operation System For…
You can take export backup of Oracle, PostgreSQL and MySQL databases with one backup script. There are 3 files (config.py, functions.py, dbbackup.py) for backup operation. You can edit config file regarding to your system. You can download python scripts by clicking : dbbackup config.py ####################### # # # Config File # # # ####################### #########################…
While runnig duplicate database, oracle can give ORA-17627, ORA-12154, ORA-17629 errors. Error [oracle@oracle19cdg2 admin]$ rman target sys@ORA19C auxiliary sys@DG2 Recovery Manager: Release 19.0.0.0.0 – Production on Sat Jul 6 14:21:44 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: ORA19C (DBID=1219995577) auxiliary database…
Firstly, OPatch directory has to be actual. You can download actual OPatch files from https://updates.oracle.com/download/6880880.html according to you database and operating system version. OPatch directory is in the grid home and oracle home directory. You have to change it with actual OPatch files. You can backup orjinal OPatch files before changing. Check Current Patches My…
If you take “Maximum of 148 enabled roles exceeded for user SYS. Not loading all the roles” error, ıt means of your SYS user’s roles are exceed 148. Solution You can connect with sys user and revoke unnessesary roles. This will resolve your problem.
Oracle Real Application Clusters (RAC) provides high availability (HA) and scalability to the Oracle Database without requiring any application changes. Oracle RAC allows multiple instances running on different servers to access the same physical database stored on shared storage. Database spans multiple hardware systems and yet appears as a single unified database to the application….
Problem ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘//dbs/init.ora’ Solution cd $GRID_HOME/bin chmod 6751 oracle
Using order by in column that contains special Turkish characters like ç,ğ,ö,ş,ü can be problem. All special Turkish characters can be listed at the end of the list. You can resolve this problem with NLSSORT. select * from tablename order by NLSSORT(columnname,’NLS_SORT=TURKISH’)