How to check character set in Oracle

One of the requirements for samePage is that the character set should be UTF-8. You can either check with your DBA or run the following SQL to determine whether your database character set is UTF-8.    SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ; It should return the value AL32UTF8. Another option is to … Continue reading How to check character set in Oracle

Advertisements

Linux Unix d.bin command

Hello, Some useful Oracle RAC Database commands in daily use Background Processes fraudms80:/dev#cd fraudms80:/home/oracle#ps -ef |grep d.bin oracle 7536914 1 0 10:17:18 - 0:00 /oracle/product/11.2.0.4/grid/bin/ohasd.bin reboot oracle 12452116 1 0 10:17:38 - 0:00 /oracle/product/11.2.0.4/grid/bin/evmd.bin oracle 14287240 1 0 10:17:38 - 0:00 /oracle/product/11.2.0.4/grid/bin/oraagent.bin oracle 23200164 12452116 0 10:17:39 - 0:00 /oracle/product/11.2.0.4/grid/bin/evmlogger.bin -o /oracle/product/11.2.0.4/grid/evm/log/evmlogger.info -l /oracle/product/11.2.0.4/grid/evm/log/evmlogger.log fraudms80:/home/oracle# … Continue reading Linux Unix d.bin command

Install the Oracle Oracle ASM rpm Packages and configuring oracle asm disks

 Os version : OEL 6u8 DB version : Oracle 11g, Install the ASMLib kernel module package as root using the following command: # yum install kmod-oracleasm Install the ASMLib library package obtained from step 2 as root using the following command, with the downloaded package: # yum localinstall oracleasmlib-<version>.x86_64.rpm # Where <version> is the revision … Continue reading Install the Oracle Oracle ASM rpm Packages and configuring oracle asm disks

UDI-27140: operation generated ORACLE error 27140 Error Solutions

Hello,  UDI-27140: operation generated ORACLE error 27140 error solutions: connect to root  ( Oracle home and Grid home ) chmod 6751 /$ORACLE_HOME/bin/oracle chmod 6751  /oracle/product/11.2.0.4/grid/bin/oracle   have a good day.  

DBMS_SESSION.CLOSE_DATABASE_LINK

Hello, The CLOSE_DATABASE_LINK procedure is used to close an open but inactive database link in the session. Determining Which Links Are in the Database The following views show the database links that have been defined at the local database and stored in the data dictionary: DBA_DB_LINKS Lists all database links in the database. ALL_DB_LINKS Lists … Continue reading DBMS_SESSION.CLOSE_DATABASE_LINK

Creating kill script file for processes.

I want to share useful Linux commands for Oracle DBAs. I  am using the below line of code to kill the process:. Creating kill script file for processes ps -ef |grep “process_name” |awk ‘{print ” kill -9 ” $2}’>/tmp/kill.sh

ORA-09925 Solution On Oracle Linux 6

Error : [oracle@ErmanTestSTDBY ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 15 15:42:42 2017 Copyright (c) 1982, 2014, Oracle.  All rights reserved. ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 13: Permission denied Additional information: 9925 ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 13: Permission denied Additional … Continue reading ORA-09925 Solution On Oracle Linux 6