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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
To upgrade from Oracle 11gR2 to Oracle 18c, 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/ […]
To upgrade from Oracle 11gR2 to Oracle 18c, we need 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 us […]
To upgrade from Oracle 11gR2 to Oracle 18c, 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 |
$> emctl stop dbconsole |
Step 2: Connect to the database using the SYS account AS SYSDBA […]
You can perform a direct upgrade to the new release from the following releases: 11.2.0.3 and 11.2.0.4 12.1.0.1 and 12.1.0.2 12.2.0.1 The path that you must take to upgrade to the latest Oracle Database release depends on the release number of your current database. If your current Oracle Database is a release earlier than 11.2.0.3, […]