Upgrade and Migrate Oracle Database 11gR2 to 19c – Non CDB using TTS

Moving data using transportable tablespaces can be faster than performing either a full export/import or unload/load of the same data. Reason is the datafiles containing all of the actual data are just copied to the destination location, and use the datapump export/import utility to transfer only the metadata of the tablespace objects to the new …

Changing Oracle Database Character Set in Oracle Database 11203

[oracle@12cOCP backup]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 19 15:00:02 2024Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select VALUE from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';VALUEWE8MSWIN12521.. shutdown immediate;2.. alter system enable restricted session;3.. …

Monitoring Oracle databases with Checkmk

Checkmk is a software developed in Python and C++ for IT Infrastructure monitoring. It is used for the monitoring of servers, applications, networks, cloud infrastructures (public, private, hybrid), containers, storage, databases and environment sensors. 1 Configuring access accounts for Oracle monitoring Login to Oracle Database as sysdba user and create user Note: - In case …