Skip to main content

Remarkable new features Oracle 18c for DBAs



New Default Location of Oracle Database Password File
Password file in earlier releases was stored in $ORACLE_HOME/dbs location. This has been changed to $ORACLE_BASE. This steps seems to be taken in order to leverage read-only ORACLE_HOME that is next feature worth noting.



Read-Only Oracle Home
You can choose for a Read only Oracle Home!!! Yes, a read only Oracle Home that will keep only configuration files.
So where will processes and database tools maintain logfiles? --> ORACLE_BASE.
This will maintain version control and standardization 



RPM-based Database Installation

This was observed by me when deploying recent versions for jdk and good to see the same has been now introduced in leveraging Oracle database software installation.

Using the rpm-ivh command, an RPM-based database installation performs 
preinstallation validations
extracts the packaged software
reassigns the ownership of the extracted software to the preconfigured user and groups
maintains the Oracle inventory 
executes all the root operations required to complete the Oracle Database software installation.

File /etc/sysconfig/oracledb_ORCLCDB-18c.conf is worth noting before running rpm command.
Shared Single Client Access Names
 Imagine set of ips needed for datacenter having 40 clusters. Each cluster will have its own SCAN. This SCAN will be resolved using DNS/GNS, suppose DNS, then there will be set of 3 ips that will be used for single SCAN, which means you will be needing 120 ip addresses for 40 clusters!!!
A shared single client access name (SCAN) enables the sharing of one set of SCAN virtual IPs (VIPs) and Listeners (referred to as the SCAN setup) on one dedicated cluster in the data center with other clusters to avoid the deployment of one SCAN setup per cluster.


 
NodeVIP-Less Cluster
NodeVIP-Less Cluster enables the configuration of a cluster without the need to explicitly configure nodevips on the public network. While the VIP resources on Clusterware level will still be maintained, there is no need to provision additional IPs for each node in the cluster, which in larger cluster estates can potentially save hundreds of IPs per subnet. 

Integration of Active Directory Services with Oracle Database
Starting with this release, you can authenticate and authorize users directly with Microsoft Active Directory. EUS is not being replaced or deprecated; this new feature is another simpler option if you only want to authenticate and authorize users with Microsoft Active Directory.

Ability to Create Schema Only Accounts
You now can create schema only accounts, for object ownership without allowing clients to log in to the schema.
A user (or other client) cannot log in to the database schema unless the account is modified to accept an authentication method.

Comments

Post a Comment

Popular posts from this blog

Logfile locations in EBS r12.1 and EBS r12.2

Startup/shutdown Apps tier services are started and stopped frequently and we must know logfiles when troubleshooting startup/shutdown issues. $INST_TOP/logs/appl/admin/log $INST_TOP/logs/appl/admin/log Apache OHS being part of opmn in r12.1 has continued in r12.2. Logfile locations for troubleshooting have been changed $INST_TOP/logs/ora/10.1.3/Apache/error_log[timestamp] $INST_TOP/logs/ora/10.1.3/opmn/HTTP_Server~1.log $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/*/*log*   OPMN Logfile locations for r12.1 and r12.2 have been changed $INST_TOP/logs/ora/10.1.3/opmn/opmn* $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OPMN/opmn/* Oacore oacore in r12.1 is oc4j component and part of 10gAS. However, in r12.2, oacore is now a managed server for weblogic server $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore*/ $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore*/ $LOG_HOME/ora/10.1.3/opmn/oacore*/oacor...
1 comment
Read more

Query to Check AD and TXK code levels in your EBS environment

Below query can be very handy in finding out current AD and TXK code levels. col ABBREVIATION for a10 set lines 1000 col NAME for a50 col CODELEVEL for a20 SELECT ABBREVIATION,NAME,codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad'); ABBREVIATI NAME                                                CODELEVEL ---------- -------------------------------------------------- ------------ ad           Oracle Applications DBA                             C.11 txk         Oracle Applications Technology Stack    ...
2 comments
Read more

Query to fetch Function assigned to which responsibility

1. Check for which function needs to be assigned to which responsibility. 2. Check for responsibility's menu sytem administrator-> Secutiry -> responsibilty -> Define 3. Search for responsiblity (% Inventory User) 4. Get default Menu name and search for that menu System Administrator -> Application->Menu 5.Once you get Function name, go for function short name as follows - System Administrator -> Application->Function Enter Function Short code for below query SELECT frtl.responsibility_name,        fr.responsibility_key,        fm.menu_id,        fm.menu_name,        menu.function_id,        menu.prompt,        menu.grant_flag,        fffv.user_function_name,        fffv.function_name,      ...
Post a Comment
Read more