• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for March 2019

How To Create An ASM Diskgroup Using XML code in ASMCMD

by admin

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 […]

Filed Under: ASM, oracle

How to monitor the status of dm-multipathing and multipath devices (path groups) in Linux

by admin

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, […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Fedora, Linux

Understanding Linux multipath (dm-multipath)

by admin

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 […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Fedora, Linux

Why Can I Login AS SYSDBA With Any Username and Password

by admin

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 […]

Filed Under: oracle

Adding Users to Oracle Passwordfile (Oracle Passwordfile Authentication)

by admin

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 […]

Filed Under: oracle

ORA-1031 When Connecting Remotely AS SYSDBA

by admin

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 ———————————— ———– […]

Filed Under: oracle

How to Create the Oracle Password File using orapwd Command

by admin

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: $ […]

Filed Under: oracle

Linux filesystem is filling, despite no large files or directories

by admin

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: # […]

Filed Under: Linux

How to start up the ASM instance when the spfile is misconstrued or lost

by admin

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: […]

Filed Under: ASM, oracle

How to save sar reports longer than 7 days in Solaris

by admin

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 […]

Filed Under: Solaris

Next Page »

Primary Sidebar

Recent Posts

  • JavaFX ComboBox: Set a value to the combo box
  • Nginx load balancing
  • nginx 504 gateway time-out
  • Images preview with ngx_http_image_filter_module

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright