Oracle Database&EBS General
-
ORA-4036 PGA memory used by the instance exceeds
In Oracle 12c introduced new parameter PGA_AGGREGATE_LIMIT to allow database administrators to limit the aggregate PGA (Program Global Area) memory usage.By setting the above parameter you will enable a hard limit on PGA usage. If the pga_aggregate_limit value is exceeded, Oracle database will aborts or terminates the sessions or processes that are consuming the most Continue reading
-
How to add new disk at Oracle Linux?
You may need to add disk to your server. Adding a disk to Oracle Linux involves several steps, including identifying the disk, partitioning it if necessary, formatting it with a filesystem, and then mounting it to make it accessible to the operating system. Here’s a general outline of the process: [root@oraclevm ~]# fdisk -l Disk Continue reading
-
Which one i have to use for my Oracle database? Oracle Enterprise Linux (OEL) or Red Hat Enterprise Linux (RHEL)
OEL and RHEL are 2 certfied operating system for oracle databases. Many times you may face with that question from your unix team: ” you want to use OEL or RHEL” For me answer is simple.. I always prefer to use Using Oracle Enterprise Linux (OEL) because it offers several advantages, particularly in environments where Continue reading
-
How to recreate a control file in Oracle Database
How to recreate a control file in Oracle Database An Oracle control file is a small binary file that serves as a critical component of an Oracle database. It’s responsible for maintaining metadata about the physical structure of the database, such as datafile and redo log file locations, database name, timestamp of database creation, and Continue reading
-
ORA-28040: No matching authentication protocol exception
This issue is caused by the default setting for allowed logon version in the 12 database.Note that the SQLNET.ALLOWED_LOGON_VERSION parameter has been deprecated in 12c. That parameter has been replaced by these: SQLNET.ALLOWED_LOGON_VERSION_SERVER=nSQLNET.ALLOWED_LOGON_VERSION_CLIENT=n Note that SQLNET.ALLOWED_LOGON_VERSION_CLIENT would be necessary on the server when the database is ‘acting’ as a client. Such as the case of a Continue reading
-
Define Database Services in a Single Instance Database
I need to create service if we made switchover database prosedure. Many application admin is want to use single SID or they can not use tns entery which has primary&standby server information. So, We create a new service using the CREATE_SERVICE procedure. The only mandatory parameters are the the SERVICE_NAME and the NETWORK_NAME, which represent Continue reading
-
EXPDP with multiple dump file on multiple directories
Sometimes we may need to take export to multiple Filesystem as one Filesystem donot have that much space on our server In such point we can use the multiple directories feature of EXPDP utility. Using this feature we can create dumpfile in multiple directories and distribute our logical export job to different directories on server Continue reading
-
Expdp-Export data with query
Your table can have huge size or you may need to little piece of data from that huge table size. In that point you can use dblink or you can use export table data with query options. Here are the some quick steps. For exporting table data with query condition expdp “‘/ as sysdba’” Directory=xxxx Continue reading
-
Usefull Oracle RAC Database management commands
Usefull Oracle RAC Database management commands In this post i want to share Usefull quick note for can manage RAC database Let start. First is first .. Shutdown and Start sequence of Oracle RAC -STOP ORACLE RAC Components sequence -START ORACLE RAC Components -To start and stop oracle clusterware (run as the superuser) : [root@node1 Continue reading
-
How to delete archivelog if disk become full?
As you know if db has lots of redo switch from other days, your archivelog disk can be full. In that point you have 3 options Always exercise caution when deleting archive logs, especially in a production environment, and ensure you have a proper backup strategy in place. Do not forget Deleting archive logs is Continue reading
HELIOS BLOG 