Oracle 12 C – Deprecated Features and/or De-supported Features

Srinivas Maddali

Deprecation of Oracle Streams – we use for ID and PE

Oracle Streams is deprecated in Oracle Database 12c and may be desupported and unavailable in a later Oracle Database release. Use Oracle Golden Gate to replace all replication features of Oracle Streams.

Deprecation of Advanced Replication – we use in OLTP environment

Oracle Database Advanced Replication is deprecated in Oracle Database 12c. Use Oracle GoldenGate to replace all features of Advanced Replication, including multimaster replication, updatable Materialized views, hierarchical materialized views, and deployment templates.

Desupport of CSSCAN and CSALTER 

Database Character Set migration – sometime back Tim discussed and told we needed to go this route

With the introduction of Oracle Database Migration Assistant for Unicode (DMU), Oracle is proceeding with the desupport of the legacy database tools, CSSCAN and CSALTER. DMU provides a complete end-to-end Unicode migration solution for database administrators. Starting with Oracle Database 12c, DMU is included with Oracle Database, and the CSSCAN and CSALTER tools are no longer included nor supported.

Deprecation of catupgrd.sql Script and Introduction of New catctl.pl (Perl script) Utility

Oracle Database 12c introduces the new Parallel Upgrade Utility, catctl.pl. This utility replaces the catupgrd.sql script that was used in earlier releases. Although you can still use the

catupgrd.sql script, it is deprecated starting with Oracle Database 12c and will be removed in future releases. Oracle recommends database upgrades be performed with the new Parallel Upgrade Utility, catctl.pl.

If you choose to run the catupgrd.sql script instead of running catctl.pl, doing so now requires an additional input parameter as follows:

SQL> catupgrd.sql PARALLEL=NO

If you run catupgrd.sql without the parameter, then Oracle displays the following error message:

NOTE

The catupgrd.sql script is being deprecated in the 12.1 release of Oracle Database. Customers are encouraged to use catctl.pl as the replacement for catupgrd.sql when upgrading the database dictionary.

cd $ORACLE_HOME/rdbms/admin

$ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql

Refer to the Oracle Database Upgrade Guide for more information.

This database upgrade procedure must be called with the following argument when invoking from the SQL prompt:

@catupgrd.sql PARALLEL=NO

Desupport of Oracle Enterprise Manager Database Control (OEM DB Console)

Starting with Oracle Database 12c, Oracle Enterprise Manager Database Control is desupported and is no longer available. Oracle introduces Oracle Enterprise Manager Database Express (Oracle EM

Express) as a replacement. Oracle EM Express is installed when you upgrade to Oracle Database 12c.

Change for Standalone De-installation Tool

Starting with Oracle Database 12c, the deinstallation standalone utility is replaced with a deinstall option using Oracle Universal Installer (OUI). You can also run the deinstallation tool using the runInstaller command on Linux and UNIX (or setup.exe on Windows) with the -deinstall and -home options from the base directory of the installation media for Oracle Database, Oracle Database Client, or Oracle Grid Infrastructure.

Desupport of CLEANUP_ORACLE_BASE Property

In Oracle Database 12c, the CLEANUP_ORACLE_BASE property is removed and does not support an Oracle base removal during silent or response file mode deinstalls. 

Oracle Multimedia Changes

In Oracle Database 12c, ORDImage support for DICOM is deprecated.

  1. Deprecation of –cleanupOBase – The -cleanupOBase flag of the deinstallation tool is deprecated in this release.
  2. Deprecated Parameters

In Oracle Database 12c, some database parameters are deprecated.

To obtain a current list of deprecated parameters, run the following query in SQL*Plus:

SQL> SELECT name from v$parameter

WHERE isdeprecated = ‘TRUE’

ORDER BY name;

The query returns a list of the deprecated parameters as of the date and time that you run it. The following example shows the query results that appear:

active_instance_count

background_dump_dest

buffer_pool_keep

buffer_pool_recycle

commit_write

cursor_space_for_time

fast_start_io_target

global_context_pool_size

instance_groups

lock_name_space

log_archive_local_first

log_archive_start

max_enabled_roles

parallel_automatic_tuning

parallel_io_cap_enabled

parallel_server

parallel_server_instances

plsql_v2_compatibility

remote_os_authent

resource_manager_cpu_allocation

sec_case_sensitive_logon

serial_reuse

sql_trace

standby_archive_dest

user_dump_dest

SEC_CASE_SENSITIVE_LOGON 

The SEC_CASE_SENSITIVE_LOGON initialization parameter is deprecated in this release.

FILE_MAPPING

The FILE_MAPPING initialization parameter is deprecated. It is still supported for backward compatibility.

Deprecated Views

The following views are deprecated in Oracle Database 12c:

  1. ALL_SCHEDULER_CREDENTIALS view.
  2. DBA_NETWORK_ACL_PRIVILEGES view.
  3. DBA_NETWORK_ACLS view.
  4. DBA_SCHEDULER_CREDENTIALS view.
  5. USER_NETWORK_ACL_PRIVILEGES view.
  6. USER_SCHEDULER_CREDENTIALS view.
  7. V$OBJECT_USAGE view. Use the USER_OBJECT_USAGE view instead

V$OBJECT_USAGE is populated as and when USER indexes and enabled for monitoring and this helps identify ununused indexes and work on them.

This V$ view is created as USER_OBJECT_USAGE. only name is changed and this is available in the user metadata schema.

Deprecation of Single-Character SRVCTL CLI Options – this will not impact us

The Server Control Utility (SRVCTL) command line interface (CLI) supports long GNU-style options in addition to short CLI options used in earlier releases. Starting with Oracle Database 12c, single-character options are deprecated and may be desupported in a later release.

Desupported Features on Microsoft Windows Platforms – we will not get impacted as we do not have any oracle database on any windows server hosting database.

In Oracle Database 12c, some features have been deprecated or desupported for the Windows platform and they are listed below:

Desupport of Oracle COM Automation on Windows

Oracle Database 12c does not contain Oracle COM Automation. This was deprecated in Oracle Database 11g, which is the last database release that contains the database component Oracle COM Automation. Oracle recommends that you migrate your Oracle COM applications to current technology such as the .NET Framework.

Desupport of Oracle Objects for OLE

Oracle Database 12c does not contain Oracle Objects for OLE. This was deprecated in Oracle Database 11g. You can migrate your code to the OLE DB data access standard and ActiveX Data Objects (ADO), or you can migrate your applications to .NET (or Java or another application architecture) and use another driver.

Desupport of Oracle Counters for Windows Performance Monitor

Oracle Database 12c does not contain Oracle Counters for Windows Performance Monitor. This was deprecated in Oracle Database 11g. The counters were not installed by default in earlier releases, and the counters only work on Windows. For monitoring, Oracle recommends that you use Oracle Enterprise Manager Cloud Control.

Desupport of Oracle Cluster File System (OCFS) on Windows

Starting with Oracle Database 12c, Oracle Cluster File System (OCFS) is desupported on Windows. Support and distribution of OCFS on Linux (OCFS and OCFS2) remains unaffected by this desupport notice.

Databases currently using OCFS on Windows to host either the Oracle cluster files (Oracle Cluster Registry and voting files) or database files or both need to have these files migrated off OCFS before upgrading to Oracle Database 12c.

Deprecation of Stored List of Administrative Users for Cluster Administration – will not effect us

Starting with Oracle Database 12c, the method of cluster administration using a stored list of administrative users is being replaced with more comprehensive management of administrative user roles by configuring the access control list of the policy set.

Desupport for Raw Storage Devices

Starting with Oracle Database 12c, block file storage on raw devices is not supported. You must migrate any data files stored on raw devices to Oracle ASM, a cluster file system, or Network File System (NFS).

This also affects the OCR and voting files for Oracle Clusterware. You cannot store the OCR or voting files on raw devices. Oracle Clusterware files must be moved to Oracle ASM before upgrading.

Change to VARCHAR2, NVARCHAR2, and RAW Datatypes

Starting with Oracle Database 12c, the maximum size of the VARCHAR2, NVARCHAR2, and RAW datatypes has been increased to 32767 bytes when the COMPATIBLE initialization parameter is set to 12.0

and the MAX_STRING_SIZE initialization parameter is set to EXTENDED.

Changes for Oracle JDBC and SQLJ

In Oracle Database 12c, some features are deprecated or desupported that affect JDBC, UCP, SQLJ, JPublisher, and Java in the Database (Oracle JVM). The JDBC Javadoc also contains a page for all the deprecated APIs.

The following features are deprecated or desupported in this release for Oracle JDBC and SQLJ:

Deprecated Oracle Update Batching

Oracle Update Batching is deprecated in Oracle Database 12c. Use Standard Update Batching instead.

The following APIs are deprecated and marked deprecated in the JDBC Javadoc:

OraclePreparedStatement.setExecuteBatch()

OraclePreparedStatement.getExecuteBatch()

OracleCallableStatement.setExecuteBatch()

Deprecated EndToEndMetrics related APIs 

EndToEndMetrics -related APIs are deprecated in Oracle Database 12c. Use Universal Connection Pool instead.

The following APIs are deprecated and marked deprecated in the JDBC Javadoc:

getEndToEndMetrics

getEndToEndECIDSequenceNumber

setEndToEndMetrics

setApplicationContext

clearAllApplicationContext

Deprecated Stored Outlines

Stored outlines are deprecated in Oracle Database 12c. Use plan baselines instead.

Deprecated Concrete Classes in oracle.sql Package 

The concrete classes in the oracle.sql package are deprecated in Oracle Database 12c. These are replaced with new interfaces in the oracle.jdbc package.

Deprecated defineColumnType Method

The JDBC method defineColumnType is deprecated in this release.

Deprecated CONNECTION_PROPERTY_STREAM_CHUNK_SIZE Property 

The JDBC property CONNECTION_PROPERTY_STREAM_CHUNK_SIZE is deprecated in this release.

Desupported Implicit Connection Caching 

Implicit Connection Caching is desupported in Oracle Database 12c. Use Universal Connection Pool instead. 

Changes for Oracle Call Interface 

The following Oracle Call Interface (OCI) features are deprecated in Oracle Database 12c, and may be desupported in a future release:

OCI deployment parameters in sqlnet.ora are deprecated. These include the following parameters:

  1. OCI client result cache parameters:
  2. OCI_RESULT_CACHE_MAX_SIZE,
  3. OCI_RESULT_CACHE_MAX_RSET_SIZE, and
  4. OCI_RESULT_CACHE_MAX_RSET_ROWS

Deprecation of Oracle Restart 

Oracle Restart is deprecated in Oracle Database 12c. Oracle Restart is currently restricted to manage single-instance Oracle databases and Oracle ASM instances only, and is subject to desupport in future releases. Oracle continues to provide Oracle ASM as part of the Oracle Grid Infrastructure installation for Standalone and Cluster deployments.

Oracle Business Intelligence and Data Warehousing Changes

Oracle Database 12c provides changes to business intelligence and data warehousing applications and features.

This section includes these topics:

Oracle Warehouse Builder (OWB) Not Installed with Oracle Database

Starting with Oracle Database 12c, Oracle Warehouse Builder (OWB) is not installed as part of the software for Oracle Database. An installer for Oracle Warehouse Builder is available on Oracle Technology Network. OWB components that may exist from earlier releases are not upgraded as part of the Oracle Database upgrade process.

Desupport of Change Data Capture 

Oracle Change Data Capture is not included in Oracle Database 12c and has been replaced with Oracle GoldenGate.

Desupported Features in Oracle Data Mining 

The following Oracle Data Mining features are desupported in Oracle Database 12c:

The Oracle Data Mining Java API is no longer available. The programmatic interfaces to Oracle Data Mining 12c consist of two PL/SQL packages, DBMS_DATA_MINING and DBMS_DATA_MINING_TRANSFORM, and a family of SQL language functions for scoring data.

The Adaptive Bayes Network (ABN) algorithm is no longer available. The Decision Tree algorithm replaces ABN in Oracle Data Mining 12c.

Changes to Upgrading Oracle Data Mining Models

Starting with Oracle Database 12c, Oracle is desupporting the Data Mining Java API and the Adaptive Bayes Network (ABN) algorithm. Therefore, models created by the Oracle Data Mining Java API cannot be upgraded from Oracle Database release 11g to Oracle Database 12c. All other models and metadata are upgraded automatically during the upgrade from release 11g to Oracle Database 12c.

ABN models can be upgraded, but you cannot use them in an Oracle Database 12c database. You must drop ABN models either before the upgrade or afterward. You can replace ABN models by building new classification models in the Oracle Database 12c database.

Desupport of OLAP Catalog (AMD) 

Starting with Oracle Database 12c, the Common Warehouse Metamodel (CWM) standard is desupported for the OLAP catalog (AMD). This support was deprecated in Oracle Database 11g Release 2 (11.2).

If your existing database has CWM metadata in the OLAP catalog and you upgrade to Oracle Database 12c, then the upgraded database has the AMD component. If the database you upgrade does not have the AMD component, then the upgraded Oracle Database 12c database also does not have the AMD component because new installations for Oracle Database 12c do not include AMD. If your database has the AMD component and you want to remove it, then run the ORACLE_HOME/olap/admin/catnoamd.sql script before or after upgrading.

Note:

If the OLAP catalog exists in the database you are upgrading, you may see AMD OLAP Catalog OPTION OFF and invalid CWM OLAP objects. You can safely ignore the invalid OLAP objects as they are not needed. 

Oracle Database Security Changes

Oracle Database 12c includes changes to security features in Oracle Database Vault and Oracle Data Guard and other areas. This section contains these topics:

Changes to Security Auditing Features

The auditing functionality has been redesigned in Oracle Database 12c. When you create a new database with Oracle Database 12c, the full set of auditing enhancement features are automatically available. If you upgrade from an earlier release, then you are given the option of using some of the new audit features and the audit functionality from the release from which you upgraded. Oracle strongly recommends that you migrate to the full set of the latest audit features.

Deprecations for Oracle Label Security

The following Oracle Label Security features are deprecated in Oracle Database 12c, and may be desupported in a future release:

LEAST_UBOUND. Use OLS_GREATEST_LBOUND instead. See Oracle Label Security Administrator’s Guide for information about finding greatest lower bound with GREATEST_LBOUND.

LUBD. Use OLS_GLBD instead.

DOMINATES.

DOM.

STRICTLY_DOMINATES.

S_DOM.

DOMINATED_BY.

DOM_BY.

STRICTLY_DOMINATED_BY.

S_DOM_BY. 

Deprecated DBMS_NETWORK_ACL_ADMIN PL/SQL package Procedures

In Oracle Database 12c, the following procedures from the DBMS_NETWORK_ACL_ADMIN PL/SQL package are deprecated:

CREATE_ACL

ADD_PRIVILEGE

DELETE_PRIVILEGE

ASSIGN_ACL

UNASSIGN_ACL

DROP_ACL

ASSIGN_WALLET_ACL

UNASSIGN_WALLET_ACL

CHECK_PRIVILEGE

CHECK_PRIVILEGE_ACLID

Deprecation of IGNORECASE and SEC_CASE_SENSITIVE_LOGON

The IGNORECASE argument of ORAPWD and the SEC_CASE_SENSITIVE_LOGON system parameter are deprecated in Oracle Database 12c. By default, passwords in Oracle Database 12c are case sensitive.

Deprecation of SQLNET.ALLOWED_LOGON_VERSION Parameter 

The SQLNET.ALLOWED_LOGON_VERSION parameter is deprecated in Oracle Database 12c. This parameter has been replaced with two new Oracle Net Services parameters:

SQLNET.ALLOWED_LOGON_VERSION_SERVER

SQLNET.ALLOWED_LOGON_VERSION_CLIENT

Upgrading a System that Did Not Have SQLNET.ALLOWED_LOGON_VERSION Parameter Setting 

If you are upgrading a system that did not have a SQLNET.ALLOWED_LOGON_VERSION parameter setting (that is, it was using the default 8), then you might need to set the value of the SQLNET.ALLOWED_LOGON_VERSION_SERVER to 8 in the upgraded Oracle Database 12c server to maintain compatibility with clients on earlier releases. Otherwise, if no setting for

SQLNET.ALLOWED_LOGON_VERSION_SERVER (or the deprecated SQLNET.ALLOWED_LOGON_VERSION) parameter is made in the upgraded Oracle Database 12c server, then the new default value becomes 11 in the new Oracle Database 12c.

The effect of the new default value of 11 for SQLNET.ALLOWED_LOGON_VERSION_SERVER in Oracle Database 12c is that clients using Oracle Database release 10g and later can connect to the Oracle Database 12c server. Clients using releases earlier than Oracle Database release 11.2.0.3 that have not applied critical patch update CPUOct2012 or later patches must use the 10g password version.

Using a setting of 12a is most secure. However, this setting only permits Oracle Database 12c clients to connect.

AUDIT_ADMIN and AUDIT_VIEWER Roles Note

In Oracle Database 12c, two roles may exist in your database that affect upgrading: AUDIT_ADMIN and AUDIT_VIEWER.

The Pre-Upgrade Information Tool and DBUA perform a pre-upgrade check to make sure such users or roles do not exist in the database. Oracle recommends that you do not use these names in your databases. If these users or roles exist, then you should rename or drop them as appropriate before upgrading to Oracle Database 12c.

Deprecation of Windows NTS Authentication Using the NTLM Protocol

Windows users can no longer authenticate using the NTS adaptor on Windows clients and servers that require the NT Lan Manager (NTLM) protocol. Because of security vulnerabilities, NTLM is deprecated as of Oracle Database 12c. Windows users can still use Kerberos. NTLM is still used for local user authentication, and in cases in which the database service runs as a local user.

Deprecation of Public Key Infrastructure for Transparent Data Encryption

Public Key Infrastructure (PKI) is deprecated for Transparent Data Encryption (TDE) in Oracle Database 12c. To configure TDE, use the ADMINISTER KEY MANAGEMENT SQL statement. Other implementations of PKI are not affected.

Desupported Cipher Suites for Secure Sockets Layer (SSL) 

Oracle Advanced Security has desupported the following cipher suites in Oracle Database 12c: 

SSL_DH_anon_WITH_DES_CBC_SHA

SSL_RSA_EXPORT_WITH_DES40_CBC_SHA

SSL_RSA_EXPORT_WITH_RC4_40_MD5

SSL_RSA_WITH_DES_CBC_SHA

Desupport of Database Rules Manager (RUL) and Expression Filter (EXF)

Starting with Oracle Database 12c, the Expression Filter (EXF) and Database Rules Manager (RUL) features are desupported. If you are using Rules Manager, Oracle recommends that you consider migrating to Oracle Business Rules, a component of Oracle Fusion Middleware. The Continuous Query Notification feature of Oracle Database replaces Expression Filter.

This script is executed by the upgrade process. If you want to remove these components before upgrading, then you can run the catnoexf.sql script before the upgrade. The catnoexf.sql script is located under ORACLE_HOME/rdbms/admin/.

Changes for Oracle Data Guard Broker 

As part of Oracle Data Guard Broker’s support for Separation of Duty features, the following broker properties are deprecated in Oracle Database 12c with no replacements:

LsbyASkipCfgPr

LsbyASkipErrorCfgPr

LsbyASkipTxnCfgPr

LsbyDSkipCfgPr

LsbyDSkipErrorCfgPr

LsbyDSkipTxnCfgPr

LsbySkipTable

LsbySkipTxnTable

Changes for Oracle Data Pump Export Utility

The XML_CLOBS option of the Oracle Data Pump Export DATA_OPTIONS parameter is deprecated.

Changes for Oracle Database Vault

Starting with Oracle Database 12c, the Database Vault Configuration Assistant (DVCA) and Database Vault Administrator (DVA) are being deprecated. Use Oracle Enterprise Manager Cloud Control for Oracle Database Vault configuration and administration.

Additional Oracle Database Vault features are being deprecated in this release as follows:

Deprecated Default Rule Sets

The following rule sets have been deprecated for this release:

Allow Oracle Data Pump Operation rule set

Allow Scheduler Job rule set

Deprecated Default Realms

The Oracle Data Dictionary realm and Oracle Enterprise Manager realm are deprecated in this release. The objects formerly protected by the Oracle Data Dictionary realm have been migrated to new realms.

Deprecated API

The DVSYS.DBMS_MACADM.SYNC_RULES procedure has been deprecated because its functionality has been built into the rule creation functionality.

Changes for Oracle Database Semantic Technologies

The following features are deprecated for Oracle Database Semantic Technologies in Oracle Database 12c:

VPD Support in Oracle Database Semantic Technologies

Transition existing Semantic Technologies applications that depend on Virtual Private Database (VPD) to use Oracle Label Security (OLS) instead

Version-Enabled Models Support In Oracle Database Semantic Technologies

The specific alternative to using Workspace Manager with semantic data depends on the purpose of the application. For information about use cases and recommended alternatives, see My Oracle Support Note 1468273.1.

Oracle Globalization Support Changes

Oracle Database 12c provides changes to how Oracle supports globalization.

This section contains the following topic:

Oracle Net Services Changes

In this release, Oracle Net Services has deprecated or no longer supports some features, parameters, and commands. This section contains the following topics:

Desupport of Oracle Net Connection Pooling – we do not use DISPATCHERS 

In Oracle Database 12c, Oracle Net connection pooling is no longer supported. Oracle Net connection pooling was deprecated in Oracle Database 11g. This includes the DISPATCHERS attributes

TICKS, SESSIONS, and CONNECTIONS

Desupport of Oracle Names

Oracle Names has not been supported as a naming method since Oracle Database 11g. You must migrate to directory naming.

Desupport of Oracle Net Listener Password – we have not implemented this feature as we use HW clusters with each listener name unique to the database and identified as a critical resource – to be started in case has some problem on the server and not switch the entire resources. If we see the NIC faulty then we manually have to move the resources to the other node from the node where we have faulty NIC.

In Oracle Database 12c, the Oracle Net Listener password feature is no longer supported. This does not cause a loss of security because authentication is enforced through local operating system  authentication.

Desupport of SQLNET.KERBEROS5_CONF_MIT Parameter for Oracle Net Services – we have not invoked this feature.

The SQLNET.KERBEROS5_CONF_MIT networking parameter is no longer supported in sqlnet.ora. This parameter was used to specify that MIT Kerberos configuration format was used. Starting with Oracle

Database 12c, only the current Kerberos configuration is supported.

Desupport of Oracle Names Control Utility for Oracle Net Services

The Oracle Names Control Utility is desupported and has not been available starting with Oracle Database 10g. This includes all the related control utility commands. Oracle Database clients cannot use a Names Server to resolve connect strings. Migrate your applications to Oracle Internet Directory with LDAP directory naming.

Deprecated NT LAN Manager (NTLM) Protocol for Oracle Net Services

The NT LAN Manager (NTLM) protocol for domain authentication is deprecated in the Oracle Windows adapter. Only Kerberos authentication is used for the NTS adapter.

Oracle XML Database Changes:

Oracle XML DB is Mandatory and Cannot Be Uninstalled

Starting with Oracle Database 12c, Oracle XML DB is a mandatory component of Oracle Database. You cannot uninstall Oracle XML DB, and there is no option to exclude it when you create an Oracle database. Oracle XML DB is automatically installed or upgraded when you upgrade an existing database to Oracle Database 12c.

The following features are deprecated in this release, and may be desupported in a future release.

CLOB storage of XMLType, also known as unstructured storage, is deprecated. Use binary XML storage of XMLType instead.

If you need to preserve insignificant whitespace then store two copies of your original XML document: one as an XMLType instance for database use and XML processing, the other as a CLOB instance to provide document fidelity.

Creation of an XMLIndex index over an XML fragment stored as a CLOB instance embedded in object-relational XMLType data is deprecated. If you need to index the data in such a fragment then store the document using binary XML storage, not object-relational storage.

The following PL/SQL subprograms in package DBMS_XMLSCHEMA are deprecated:

generateSchema

generateSchemas

There are no replacements for these constructs and there is no workaround for this change.

PL/SQL package DBMS_XDB_CONFIG is new. All Oracle XML DB configuration functions, procedures, and constants have been moved from package DBMS_XDB to DBMS_XDB_CONFIG. They are deprecated for package DBMS_XDB. Oracle recommends that you use them in package DBMS_XDB_CONFIG instead.

These are the subprograms that are deprecated in package DBMS_XDB:

ADDHTTPEXPIREMAPPING

ADDMIMEMAPPING

ADDSCHEMALOCMAPPING

ADDSERVLET

ADDSERVLETMAPPING

ADDSERVLETSECROLE

ADDXMLEXTENSION

CFG_GET

CFG_REFRESH

CFG_UPDATE

DELETEHTTPEXPIREMAPPING

DELETEMIMEMAPPING

DELETESCHEMALOCMAPPING

DELETESERVLET

DELETESERVLETMAPPING

DELETESERVLETSECROLE

DELETEXMLEXTENSION

GETFTPPORT

GETHTTPPORT

GETLISTENERENDPOINT

SETFTPPORT

SETHTTPPORT

SETLISTENERENDPOINT

SETLISTENERLOCALACCESS

These are the constants that are deprecated in package DBMS_XDB:

XDB_ENDPOINT_HTTP

XDB_ENDPOINT_HTTP2

XDB_PROTOCOL_TCP

XDB_PROTOCOL_TCPS

See Also:

  1. Oracle Database PL/SQL Packages and Types Reference, Chapter “DBMS_XDB_CONFIG”
  2. All Oracle SQL functions for updating XML data are deprecated. Oracle recommends that you use XQuery Update instead. These are the deprecated XML updating functions:

updateXML

insertChildXML

insertChildXMLbefore

insertChildXMLafter

insertXMLbefore

insertXMLafter

appendChildXML

deleteXML

See Also:

Oracle XML DB Developer’s Guide for the appendix that describes Oracle SQL functions for updating XML data that are deprecated and recommendations for replacements Oracle SQL function sys_xmlgen is deprecated. Oracle recommends that you use the SQL/XML generation functions instead.

See Also:

Oracle XML DB Developer’s Guide for information about SQL functions that you can use to construct XML data

The following Oracle XQuery functions are deprecated. Use the corresponding standard XQuery functions instead, that is, the functions with the same names but with namespace prefix fn.

ora:matches – use fn:matches instead

ora:replace – use fn:replace instead

The following Oracle constructs that provide support for XML translations are deprecated.

  1. PL/SQL package DBMS_XMLTRANSLATIONS
  2. Oracle XPath function ora:translate
  3. XML Schema annotations

 

  1. xdb:maxOccurs,
  2. xdb:srclang, and
  3. xdb:translate

There are no replacements for these constructs and there is no workaround for this change.

See Also: 

Oracle XML DB Developer’s Guide for more information

The following XML Schema annotations are deprecated:

  1. xdb:defaultTableSchema
  2. xdb:maintainOrder
  3. xdb:mapUnboundedStringToLob
  4. xdb:maxOccurs
  5. xdb:SQLCollSchema
  6. xdb:SQLSchema
  7. xdb:srclang
  8. xdb:storeVarrayAsTable
  9. xdb:translate

There are no replacements for these constructs, and there is no workaround for this change.

The value xml_clobs for export parameter data_options is deprecated starting with Oracle Database 12c.

Oracle Text Changes – this may impact QC

Oracle Database 12c introduces changes for Oracle Text.

Desupport of CTXXPATH in Oracle Text and Oracle XML DB

CTXSYS.CTXXPATH index is desupported as of Oracle Database 12c. This does not affect CTXCAT. Use XMLIndex indexes instead. 

Desupport of ALTER INDEX OPTIMIZE for Text Indexes

The ALTER INDEX OPTIMIZE [token index_token | fast | full [maxtime (time | unlimited)] operation is not supported for Oracle Database 12c.

To optimize your index, use CTX_DDL.OPTIMIZE_INDEX.

Desupport of SYNC [ME