Oracle

The privileges to revoke.   REVOKE EXECUTE ANY PROCEDURE FROM BARANYILDIZ; REVOKE create ANY table  FROM BARANYILDIZ; REVOKE SYSDBA FROM BARANYILDIZ;    143 views last month,  3 views today

Sysdba kullanıcısı ile sqlplus girişi yapılır. [oracle@baranyildiz ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 12 22:02:41 2019 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to an idle instance. Veritabanımız nomount modda açılır. SQL>  startup nomount; ORACLE instance started. Total System Global Area 8589934592 …

ORA-00059: maximum number of DB_FILES exceeded   While adding a new datafile to tablespace, I got the ” ORA-00059: maximum no. of DB_FILES exceeded ” error, then I checked db_files parameter SQL> Select value from v$parameter where name = 'db_files' ; Elapsed: 00:00:00.02 I increased the db_files parameter 00:07:12 SQL> …

Hi, Sometimes you may need to install Oracle database silent or manually instead of GUI( Graphical User Interface ), or sometimes there is no GUI tool like VNC Server, so you need to install and create Oracle database Manually or in silent mode.  809 views last month,  2 views today

Author     : Cihan Gedik Email        : cihangedik@gmail.com Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/     Bulk and Individual Password Reset For Oracle E-Business ( EBS ) Users Compatible Versions Oracle EBS 12.1.x , 12.2.x Oracle Database 11.x or higher   Requirements Oracle EBS Clone Procedure Bulk Password …

To start ADRCI in the interactive mode, type adrci at the command line, as shown here: Invoke ADRCI. [oracle@srv1 ~]$ adrci ADRCI: Release 12.1.0.2.0 - Production on Wed Feb 12 22:37:21 2020 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> You can …

To determine the optimal value for the UNDO_RETENTION parameter, you must first calculate the actual amount of undo that the database is generating. Once you know approximately how much undo the database is generating, you can calculate a more precise value for the UNDO_RETENTIONparameter.   Use the following formula to …

Hi, When you add disks to the ASM Disk group, you can get ” ORA-15032 ORA-15031 ORA-15025 ORA-27041 ” errors.  499 views last month,  3 views today

To manage Oracle database’s storage, Oracle recommends The Automatic Storage Management (ASM) to be used regardless of database’s configuration: single-instance Oracle Database or Oracle Real Application Clusters configurations. It is really Oracle ASM is a storage management’s solution and used an alternative to conventional volume managers, file systems, and raw …

Hi, I will explain What is the Access Control List ( ACL ) and How to Create and Grant an ACL in Oracle Database in this article.  845 views last month,  6 views today

Hi, I will explain How to Move, Rename and Relocate Datafiles in Oracle database.  574 views last month,  2 views today

Hi, I will explain What is the Tablespace and How to Create Tablespace in Oracle in this post.  914 views last month,  3 views today

Hi, I will explain How to Export and Import Specific Table Partition and Where Condition in Oracle Datapump in this article.  1,024 views last month,  12 views today

Suppose that we have a table of 10 rows in which only the first 5 rows are used / required by the application team. As a DBA, we can decide to keep only the necessary and archive the unnecessary rows. With Oracle’s In-Database archive functionality, it is possible to archive table …

Install Swingbench 2.6 To install Swingbench release 2.6, all you need to do is ensure you have a Java 8 JVM available, to check java version use command, you must have Oracle client installed and should be able to access DB through TNS. java -version Download Swingbench 2.6 zip file …

Block change tracking (BCT) is an oracle feature that improves the performance of incremental backups. Suppose we have a level 0 backup and want to make a level 1 backup. During the level 1 backup, oracle will scan all the blocks from the last level 0 backup and identify those …

Let’s say we want to create a database user who logs in with their OS account. To do so, we will use the “external authentication” option offered by oracle. Check the value of the os_authent_prefix parameter SQL> show parameter os_authent_prefix NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ os_authent_prefix                    string      ops$ The ops$ …

The following initialization parameters are new in Oracle Database 19c: In Oracle 19c database Oracle introduced six parameters. We know that parameter plays very important role in database.   You can read the following article, if you don’t know how to install Oracle 19C…. https://ittutorial.org/oracle-database-19c-on-linux-7-6-step-by-step-installation-1/ DBAs should know the characteristics …

Hi, I will share with you Step by Step RMAN Backup, Restore and Recovery Tutorials For Beginners in the Oracle Database in this article.  5,476 views last month,  11 views today

Hi, I will explain What is the Optimizer Hints and How to Use Hints in Oracle in this article.  979 views last month

Hi, I will explain Oracle 20c New Features and Step by Step Installation Oracle Database 20c on Linux 7.6  in this article.  1,716 views last month,  9 views today

Hi, I will explain How to Create SQL Plan Baselines Using Enterprise Manager Cloud Control in this article.    757 views last month

  Oracle Database Versions Databases must be upgraded for oracle support. Oracle Support For Major Version: Oracle Support For Patch Status: Doc:Oracle  297 views last month,  1 views today