Change WEB Port on 12.2
Change WEB Port on 12.2 The steps to change the webport to 8000. Step-1:Start only Weblogic admin using adadminsrvctl.sh start on run file system Login to Enterprise Manager(em) Console using below…
Read MoreORA-01017: invalid username/password; logon denied
ORA-01017: invalid username/password; logon denied ERROR: ORA-01017: invalid username/password; logon denied First of all you need to edit your sqlnet.ora adding (or lowering) the parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER to…
Read MoreOracle Database 18c new features
Oracle Database 18c new features Versions 18.1.0 18.2.0 18.3.0 General Features in 18C we can configure ORACLE_HOME in read-only mode. we can CANCEL any database session SQL query (instead…
Read MoreData Guard New Features in Oracle 18c and 19c
Data Guard New Features in Oracle 18c and 19c Data Guard Oracle Data Guard ensures high availability disaster recovery and data protection for enterprise data Data Guard maintains these standby…
Read MoreNew Features in Oracle Database 19c
General Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs New ALTER SYSTEM statement clause FLUSH PASSWORDFILE_METADATA_CACHE Clear flashback logs…
Read MoreData Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c
Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high…
Read MoreDBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c
DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs.…
Read MoreORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-20001: Statistics Advisor: Invalid task name for the current user During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA…
Read MoreORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired The error is raised when the following statement is executed against the Oracle Database. SQL> truncate table WRI$_OPTSTAT_HISTHEAD_HISTORY; truncate…
Read MoreORA-16826: apply service state is inconsistent with the DelayMins property
ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – new_DG_CONFIG Protection Mode: MaxPerformance Databases: new – Primary database newia –…
Read More