The post provides you an example about how to create an ASM diskgroup using XML code through the asmcmd command. 1. Create a XML file (e.g. diskgroup.xml) with the next code: <dg name=”datadg” redundancy=”normal”> <fg name=”SAN1″> <dsk string=”ORCL:ASMDISK1″/> <dsk string=”ORCL:ASMDISK2″/> </fg> <fg name=”SAN2″> <dsk string=”ORCL:ASMDISK3″/> <dsk string=”ORCL:ASMDISK4″/> </fg> <a name=”compatible.asm” value=”11.2″/> <a name=”compatible.rdbms” value=”11.2″/> <a […]
Archives for March 2019
How to monitor the status of dm-multipathing and multipath devices (path groups) in Linux
Monitoring The multipath command can be used to monitor the status of multipaths. When used with one -l option, it will show a quick overview of multipath topologies. If the -l option is specified twice (-ll), it will also perform a check on all paths to see if it is active. If everything is fine, […]
Understanding Linux multipath (dm-multipath)
What is multipathing? Multipathing allows the combination of multiple physical connections between a server and a storage array into one virtual device. This can be done to provide a more resilient connection to your storage (a path going down will not hamper connectivity), or to aggregate storage bandwidth for improved performance. As an example, the […]
Why Can I Login AS SYSDBA With Any Username and Password
Due to the misconception about the AS SYSDBA login allowed with any username, this post wants to avoid the panic associated with the wrong assumption that it is a security breach that you can login with any username AS SYSDBA while in fact, you are O/S authenticated. A user is able to connect AS SYSDBA/SYSOPER […]
Adding Users to Oracle Passwordfile (Oracle Passwordfile Authentication)
In a Unix environment you can use the following command to create a password file and to add user SYS and it’s password to the file: $ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=secret entries=20 On Windows you can use the same command. The only differences are: The password file should be created in %ORACLE_HOME%\database. The password file’s name […]
ORA-1031 When Connecting Remotely AS SYSDBA
The Problem Remote connections as SYSDBA are failing with ORA-1031 : $ sqlplus sys/syspassword@sidname as sysdba SQL*Plus: Release 10.2.0.3.0 – Production on Thu Dec 13 19:37:53 2007 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-01031: insufficient privileges The REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE: SQL> show parameter remote_login NAME TYPE VALUE ———————————— ———– […]
How to Create the Oracle Password File using orapwd Command
Question: How to create OS password file using the orapwd command in Unix and Windows platforms? What are the arguments ( Values and description) of orapwd command? 1. Log on to the database as an administrative user. 2. Shutdown the database. 3. On Linux/UNIX: cd $ORACLE_HOME/dbs Windows: cd %ORACLE_HOME%\database 4. Issue the orapwd command: $ […]
Linux filesystem is filling, despite no large files or directories
The Problem On a Linux-based system, the root file system is filling up by some unknown process. It continues regardless of what files are moved or cleaned from the file system. # df -hP / /dev/mapper/VGExaDb-LVDbSys1 ext3 30G 29G 0 100% / There are no large files to account for the full file system: # […]
How to start up the ASM instance when the spfile is misconstrued or lost
The Problem CRS and the ASM instance can not start up because the spfile is misconstrued or lost. – Starting ASM instance fails with error: SQL> startup; ORA-00099: warning: no parameter file specified for ASM instance ORA-00304: requested INSTANCE_NUMBER is busy – Starting up the CRS services fails with error # crsctl start crs CRS-4640: […]
How to save sar reports longer than 7 days in Solaris
It might be necessary to save sar reports longer than 7 days. This post explains the steps to achieve this goal. The “sa2” is the script that is responsible for writing a summarized daily activity report. The /usr/lib/sa/sa2 has the following entries: #!/sbin/sh # Copyright (c) 1984, 1986, 1987, 1988, 1989 AT&T # All Rights […]