This is a quick post about an issue that I faced while trying to start one database yesterday. When I was trying to open one 12cR1 database, I got the following error: SYS SQL>alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback database The database status was "mounted": … Continue reading ORA-38760 While starting an Oracle Database
I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace. For example: In the current database, all application users are sharing the tablespaces “USERS” The client wants to change this, so as each schema … Continue reading Is it possible to map one Tablespace to many Tablespaces with impdp?
In this post we are going to load data from text files (formatted as CSV “comma separated values”) into oracle database (12.1) using 3 different techniques: Oracle SQL LoaderOracle SQL DeveloperOracle sqlcl command line utility. We will just touch the above techniques; you still need to drill down for more options and more details. Environment: … Continue reading Loading Data into Oracle Database from text CSV files
When time came to troubleshooting , we started to search and review the log files. At stress time, one may waste time searching about the location of these log files. So, it may be a good practice to document the location of your environment log files, so as to reach them quickly when you need … Continue reading Oracle Exadata Log Files
Oracle Database 12c introduced Oracle Enterprise Manager Database Express 12c. Oracle Enterprise Manager Express is a Web-based interface for managing an Oracle database. Using Oracle EM Database Express, you can perform basic administrative tasks such as user, performance, memory, and space management. Oracle Enterprise Manager Database Control is no longer available. EM Database Express is … Continue reading Oracle Enterprise Manager Database Express 12c Overview
Following are screen shots from one of my latest presentations about this topic: References: https://docs.oracle.com/database/121/HTMIG/db_pluggable.htm https://oracle-base.com/articles/12c/multitenant-uninstall-apex-from-the-cdb-12cr1 ThanksAhmed
This post is just a screen cast for the process of creating a new container database with two PDBs in Oracle version 12.2. Login to the database server, set the ORACLE_HOME , PATH and DISPLAY , then run the Database Configuration Assistant "dbca" as oracle user: Check the listener status and ensure that the newly … Continue reading Oracle 12.2 Database Creation