This article shows how to create Oracle 18c database in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Database Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter Cloud18c. – From the Software Release list, […]
Category: Oracle 18c
Apply Patch on Oracle 18c Database
In this post, we are going to apply bug fix patch for testing in Oracle 18c Database. First of all, we can download latest opatch utility from support. Doc ID 274526.1 -> How To Download And Install The Latest OPatch (6880880) Version. Check the version from new OPatch utility.
|
1 2 3 4 5 |
[oracle@18c ~]$ opatch version OPatch Version: 12.2.0.1.11 OPatch succeeded. [oracle@18c 20082081]$ |
Now we are going to […]
Background Processes and Listener in Oracle 18c
In this post we can see that how many background processes will come after starting the Oracle 18c Database on virtual box. Also we can create listener in Read Only Home to connect the database remotely with the help of tns entry. Let me start the newly created 18c Database. Configured the Listener Manually or […]
Upgrade Database from Oracle 11gR2 to Oracle 18c
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 18c(18.0.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to use the […]
Read-Only Oracle Homes on Oracle 18c
Starting with Oracle Database 18c, you can configure an Oracle home in read-only mode. In a read-only Oracle home, all the configuration data and log files reside outside of the read-only Oracle home. This feature allows you to use the read-only Oracle home as a software image that can be distributed across multiple servers. Apart […]
ORA-12754: Feature ‘startup’ is disabled due to missing capability ‘Runtime Environment’
Installation of the Oracle 18c database software has been successfully completed, now while trying to run DBCA, there was an ORA-12754 error. Start DBCA DEBUG function, did not find valuable information, or decided to build a database by hand. However, the configuration of the password file and parameter file, the error is still
|
1 2 3 |
[oracle@localhost ~]$ sqlplus / as sysdba SQL> startup nomount; ORA-12754: Feature 'startup' is disabled due to missing capability 'Runtime Environment'. |
|
1 2 3 |
[oracle@localhost ~]$ cd $ ORACLE_HOME / bin [oracle@localhost ~]$ strings oracle | grep 'Runtime Environment' Runtime Environment |
It […]
Upgrade Apex for Oracle 18c
Starting with Oracle Database Release 18, APEX has not upgraded automatically as part of the database upgrade. Refer to My Oracle Support Note 1088970.1 for information about APEX installation and upgrades. To download the latest APEX: Click Here
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 01:54:54 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/ SQL> select version from dba_registry where comp_id=’APEX’; |
Stay tuned for more articles on Oracle 18c Thank you for giving your valuable time to read […]
Compile Fixed Objects
To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to gather stat for fixed objects
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 01:54:54 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; PL/SQL procedure successfully completed. |
Stay tuned for more articles on Oracle 18c Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ […]
Remove OLAP for Oracle 18c
To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to remove OLAP. Remove OLAP Catalog by running the 11.2.0.4.0 SQL script $ORACLE_HOME/olap/admin/catnoamd.sql script.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
[oracle@localhost admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 01:48:34 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @catnoamd.sql Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. <<< OUTPUT Truncated>>>> PL/SQL procedure successfully completed. 1 row deleted. SQL> commit; Commit complete. SQL> |
Stay tuned for more articles on Oracle 18c Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send […]
Remove EM for Oracle 18c
To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to Enterprise Manager. Copy the $ORACLE_HOME/rdbms/admin/emremove.sql script from the target 18.0.0.0.0 ORACLE_HOME into the source 11.2.0.4.0 ORACLE_HOME. Step 1: If database control is configured, stop EM Database Control, using the following command
|
1 |
|
1 |
gt; emctl stop dbconsole |
Step 2: Connect to the database using the SYS account AS […]