Adding a datafile to an Oracle ASM (Automatic Storage Management) database involves several steps. ASM is a feature of Oracle Database that manages storage and simplifies database file management. Here’s a general outline of the steps to add a datafile to an ASM database. Before start to adding the datafile in ASM we need below 2 things Devamını oku: How to add Datafile in ASM? 1) Diskgroup Name which is necceseary for adding datafile 2) Tablespace Name which is neccesarry for adding datafile. We need to find out tablespace created on which diskgroup Here I have taken Diskgroup Name “+DAT ..read more

In Oracle Database, a Pluggable Database (PDB) is a self-contained unit of storage with its own data and metadata that can be plugged into and unplugged from a Container Database (CDB). To stop and start a Pluggable Database, you can follow these steps: Stopping a Pluggable Database: Connect to the Container Database (CDB): Open a command-line interface or a SQL client and connect to the CDB as a user with administrative privileges, typically a user with the SYSDBA role. # sqlplus sys as sysdba Ensure you are in the CDB context: Check if you are in the context of the CDB, not a specific PDB, b ..read more

You may hit this error during some process such as: dbca, restore or startup database. This error is meaning something wrong at your kernel settings. Check first your current settings by using below command # cat /etc/sysctl.conf | grep kernel | grep -v “#” — Those parameters are for 60Gb RAM. You can use those settings as reference kernel.shmall = 16039424 kernel.shmmax = 65697480704 kernel.shmmni = 4096 Then You can calculate what the kernel.shmall value should be with a formula as follows. kernel.shmall = kernel.shmmax / kernel.shmmni ..read more

Since the Redologs are created at container database level in 12c and forwards. Its notcreated at pluggable database level. Its not possible to Enabling archivelog at pluggable database level. You need to do it on CDB level. Let us see how we can enable archive log. Check archive log mode by below query, SQL> select name,open_mode,log_mode from v$database; NAME OPEN_MODE LOG_MODE CDB READ WRITE NOARCHIVELOG (OR) Enable the Archive-log mode — Stop DB first SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. — Start DB in mount state SQL> startu ..read more

That question is asking me many times. Which database is better, what is performance difference, should i go with open source database. Oracle Database and PostgreSQL are both powerful relational database management systems (RDBMS), but they have differences in terms of features, licensing, performance, community, and more. Here’s a comparison between Oracle and PostgreSQL based on common factors: Licensing: Oracle: Oracle Database is a commercial product and comes with various licensing options that can be expensive, especially for large enterprises. PostgreSQL: PostgreSQL is open-source and ..read more

I tried to install compat-libstdc++33 for our 19c installation on Rhel 7 Linux operating system. But yum installer is reporting no package sucha as compat-libstdc++33. We can check current repo by using below command(Ps: I will share some line from all current list) root@helios# yum repolist all oaded plugins: langpacks, product-id, search-disabled-repos, subscription- : manager repo id status rh-gluster-3-client-for-rhel-7-server-debug-rpms/7Server/x86_64 enabled: 6 rh-gluster-3-client-for-rhel-7-server-rpms/7Server/x86_64 disabled rh-gluster-3-client-for-rhel-7-server-source-rpms/7Server/x86 ..read more

The error message “ORA-28017: The password file is in the legacy format” is related to Oracle database security. It indicates that the password file being used for authentication is in the older legacy format, which is not supported by the current version of Oracle. Starting with Oracle Database 12c, Oracle introduced a new password file format called the “Oracle Database Vault”. This format provides enhanced security features and is the recommended format for password files. The legacy format refers to the older password file format used in earlier versions of Oracle. Let us see how we can so ..read more

If you are DBA you already know the topic. By the way you may see many SQL code example which show how statistic is important for Oracle Cost-based Optimizer (CBO) in performance topic. As I said, statistics play a crucial role in Oracle Database for query optimization and performance tuning. Let us see some reasons why statistics are important for us: Query Optimization: The Oracle optimizer uses statistics to determine the most efficient execution plan for a given SQL query. Statistics provide information about the distribution, density, and selectivity of data within tables and indexes. By ..read more

To delete table, index, or schema statistics in Oracle Database, you can use the following methods: Deleting Table Statistics: If you want to delete statistics for a specific table, you can use the DBMS_STATS.DELETE_TABLE_STATS procedure. Here’s an example: BEGIN DBMS_STATS.DELETE_TABLE_STATS(ownname => ‘SCHEMA_NAME’, tabname => ‘TABLE_NAME’); END; / Replace ‘SCHEMA_NAME’ with the name of the schema that owns the table and ‘TABLE_NAME’ with the name of the table for which you want to delete the statistics. Deleting Index Statistics: To delete statistics for an index, you can use the DBMS ..read more

We create jobs and can schedule it by using DBMS_SCHEDULER package. We can also use this package for to stop or drop the job. There are two separate procedure(stop_job and drop_job) exists in the package. In some cases you will have to use the force option to stop the job. Let start to example Devamını oku: How to Stop / Drop Scheduled / Running jobs in Oracle SQL> SELECT job_name, state FROM DBA_SCHEDULER_JOBS where job_name like ‘%HELIOS%’; JOB_NAME STATE ———————– ————— HELOS_TEST_JOBS RUNNING SQL> exec DBMS_SCHEDULER.stop_JOB (job_name => ‘DEMO.HELOS_TEST_JOBS’); BEGIN DBMS_S ..read more