JSESSIONID is the default name of the cookie used by WebLogic Server web applications. It can be changed to another string in weblogic.xml. The format of JSESSIONID is: SessionId!PrimaryServer JVM Hash!SecondaryServer JVMHash Other than this you don’t see any other details. Consider a scenario with two servers (SERVER-NAME1, SERVER-NAME2) in a cluster. When you enable […]
oracle
CRSCTL Command Examples in ASM Standalone Configurations
The CRSCTL command utility is an essential tool to master in the DBA toolbox for Clusterware maintenance and administration. It provides Clusterware monitoring functions as well as the ability to add and remove key components of the Oracle Clusterware such as adding or removing vote disks and management of Clusterware processes and resources. With the […]
How to Change sys password in oracle 12c on RAC and dataguard
As part of the password change policy, we have to change the password of sys user. This can be difficult at times if we do not do it correctly. One of the scenario is as below: Database type: RAC two nodes on primary with one node dataguard Location of password file on primary: under ASM […]
MAX_STRING_SIZE Parameter in Oracle Database
Oracle Database parameter MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, and RAW data types in SQL. From Oracle Database 12c onwards, table column(s) length can be modified to greater than 4000 characters when this parameter value is set to EXTENDED. Allowed values for this parameter are: STANDARD: Default value. Means that the length limits […]
How to change max_string_size value from STANDARD to EXTENDED
MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, and RAW data types in SQL. There are 2 possible values of this parameter: MAX_STRING_SIZE = STANDARD means that the length limits for Oracle Database releases prior to Oracle Database 12c apply (for example, 4000 bytes for VARCHAR2 and NVARCHAR2, and 2000 bytes for RAW). MAX_STRING_SIZE = […]
FLUSH_DATABASE_MONITORING_INFO Procedure
As per documentation, the FLUSH_DATABASE_MONITORING_INFO procedure flushes in-memory monitoring information for all tables in the dictionary. Corresponding entries in the *_TAB_MODIFICATIONS, *_TAB_STATISTICS, and *_IND_STATISTICS views are updated immediately, without waiting for the Oracle database to flush them periodically. This procedure is useful when you need up-to-date information on those views. Because the GATHER_*_STATS procedures internally […]
ORA-01506: missing or illegal database name
Error Text, Cause and Action from Message File/s for ORA-01506 Versions 10.1, 10.2, 11.1, 11.2, 12.1 Error: ORA-01506 missing or illegal database name ————————————————————————— Cause: No db_name INIT.ORA aprameter was specified. Action: The database name must be given in the db_name INIT.ORA parameter. Versions 9.2 Error: ORA-01506 missing or illegal database name ————————————————————————— Cause: No […]
Error: ORA-16810: multiple errors or warnings detected for the database
If you’re seeing the ORA-16810 on standby database, here is a step by step monitoring guide. The ora error description is as follows: Error code: ORA-16810 Description: multiple errors or warnings detected for the database Cause: The broker detected multiple errors or warnings for the database. Action: To get a detailed status report, check the […]
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
The Problem Received below error while restoring COLD backup of source database using RMAN at target server. RMAN> run{ 2> restore database; 3> } Starting restore at 07-SEP-16 RMAN-06908: WARNING: operation will not run in parallel on the allocated channels RMAN-06909: WARNING: parallelism require Enterprise Edition allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=391 device type=DISK released […]
Warning: ORA-16829: fast-start failover configuration is lagging
Using DGMGRL, you can change property values directly by using the command-line utility. It includes commands to create an observer process that monitors the whole configuration, including the primary and standby, to evaluate if a failover is necessary, and to initiate FSFO. You might encounter the error “ORA-16829: fast-start failover configuration is lagging” while checking […]