Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39

  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

    Database Administrators

Archive for November, 2022

Learn the basic Oracle ASM Command in Oracle Database

Posted by Mir Sayeed Hassan on 16th November 2022

Learn the basic command of Oracle ASM in Oracle Database Login to the Oracle ASM Instance [oracle@ractest1 ~]$ . oraenv ORACLE_SID = [+ASM1] ? +ASM1 The Oracle base remains unchanged with value /u02/app/oracle ls – It displays the list of disk associated to single instance. ASMCMD> ls DATA/ ls -g – It… Read more..

Posted in ASM | Comments Off on Learn the basic Oracle ASM Command in Oracle Database

How to Prevent an OS Authenticated Oracle User To Connect via sqlplus / as sysdba

Posted by Mir Sayeed Hassan on 5th November 2022

How to Prevent an OS Authenticated Oracle User To Connect via SQLPLUS / AS SYSDBA Login to the server [oracle@testdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Sat Nov 5 03:24:11 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database… Read more..

Posted in Oracle 12C & 18C | Comments Off on How to Prevent an OS Authenticated Oracle User To Connect via sqlplus / as sysdba