Oracle

Archivelog mod değiştirme

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 …

Read More »

How To Create A Database Manually and How to Create a Database Using DBCA Silent Mode in Oracle

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

Read More »

Bulk and Individual Password Reset For Oracle E-Business ( EBS ) Users

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 …

Read More »

Automatic Diagnostic Repository Command Interpreter (ADRCI)

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 …

Read More »

configure disk devices using Oracle ASMLIB

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 …

Read More »

How do you connect to an oracle database with os authentication linux

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$ …

Read More »

Oracle Database 19c New Initialization Parameters

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 …

Read More »