This post describes how to identify Network Information Service (NIS) authenticated users. 1. To obtain a complete list of all NIS users, run the ypcat passwd command For example: [root@nisserver ~]# ypcat passwd test2:x:504:504::/home/test2:/bin/bash user1:x:501:501::/home/user1:/bin/bash user2:x:502:502::/home/user2:/bin/bash user3:x:503:503::/home/user3:/bin/bash 2. To identify whether a specific user is a NIS user, run the ypmatch [username] passwd command. – […]
Archives for May 2021
How to Clone a Pluggable Database from an RMAN Container Database Backup
The following steps will show you how to perform a backup of a container database (CDB), including only the pieces required to migrate a subset of pluggable databases (PDB) with no disruption of application activity to the source PDBs. The backup and all datafiles contained in it will be consistent to a single point in […]
Oracle 12c: Unplug/Plug PDB to new CDB using RMAN Active Database Duplication
This method takes advantage of a new feature of RMAN in 12c allowing you to clone database files and apply incrementals to those files from an active database without requiring staging areas. In addition, the source PDB application activity can continue while the cloning and incremental applies are being performed. To get the datafiles in […]
Oracle 12c: Migrate non-CDB and Convert to a PDB using 12c RMAN Active Database Duplication
This method takes advantage of a new feature of RMAN in 12c allowing you to clone database files and apply incrementals to those files from an active database without requiring staging areas. In addition, the source non-CDB application activity can continue while the cloning and incremental applies are being performed. When ready to perform the […]
How to move a Datafile to a different Location on a Physical Standby Database
Sometimes it is necessary to move a Datafile to another Location (eg. Mountpoint, ASM Diskgroup) due to Space issues, Hardware Replacement, or Performance Reasons. There are several Possibilities to perform this Task explained below: Physical Standby Database is mounted We can copy and rename the Datafile while Managed Recovery is stopped. If the Physical Standby […]
Oracle Data Guard Security Enhancement – SYSDG Administration Privilege
Starting with Oracle 12c you can grant the ‘SYSDG’ Administration Privilege to a User so they can perform Data Guard-related operations including using Data Guard Broker. It is no longer necessary to use SYS or SYSDBA for Data Guard Administration. Just grant this Privilege to a User in SQL*PLUS: SQL> grant sysdg to [USER]; Example: […]
Oracle Data Guard 12c – Creating a Physical Standby from Primary
For the purposes of this post, the following environment is used as an example to describe the procedure: Primary db_name and db_unique_name: BOSTON Standby db_name: BOSTON (same as primary db_name) Standby db_unique_name: CHICAGO Directory: /u01/app/oracle Note: We cannot create a physical standby at PDB(plugable Database) level. It should be at CDB(Container Database) level i.e entire […]
Oracle 12C Enhancements for Cascaded Standby Databases
This post explains the Enhancements for Cascaded Standby Databases in Oracle 12c. There are new Possibilities for cascading Standby Databases in Oracle 12c. The main Differents between Oracle 12c and the previous Releases are: Real-Time Cascading Far Sync Standby Database Data Guard Broker now supports cascaded Standby Database However, you can still only cascade a […]
How to determine the required archivelog files needed for a guaranteed restore point before running flashback database
Question: How can you determine the required archivelog files needed for a guaranteed restore point before running the flashback database? The following query should give this information: SELECT DISTINCT al.thread#, al.sequence#, al.resetlogs_change#, al.resetlogs_time FROM v$archived_log al, (select grsp.rspfscn from_scn, grsp.rspscn to_scn, dbinc.resetlogs_change# resetlogs_change#, dbinc.resetlogs_time resetlogs_time from x$kccrsp grsp, v$database_incarnation dbinc where grsp.rspincarn = dbinc.incarnation# and […]
How to install and configure VNC Server on CentOS/RHEL 8
Question: How to remotely access graphical environment on an CentOS/RHEL 8? The access will be used using a VNC server. Setup VNC Server 1. Install VNC Server and the graphical environment in the server: $ sudo dnf install tigervnc-server $ sudo dnf group install “Server with GUI” 2. Configure the users that will user VNC. […]