Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, November 6, 2014

ORA-15001: diskgroup " " does not exist or is not mounted


Issue:
====
SQL> drop diskgroup TESTDAT;
drop diskgroup TESTDAT
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "TESTDAT" does not exist or is not mounted


SQL> select name from v$asm_diskgroup;

NAME
------------------------------
TESTDAT


Fix:-
====
SQL> drop diskgroup TESTDAT force including contents;

Diskgroup dropped.



rsync - scp to Copy files between servers



rsync
Use this command to transfer files remotely and locally in Linux based machines.

-v : verbose
-r : copies data recursively (but don’t preserve timestamps and permission while transferring data
-a : archive mode, archive mode allows copying files recursively and it also preserves symbolic links, file permissions, user & group ownerships and timestamps
-z : compress file data
-h : human-readable, output numbers in a human-readable format

example:

rsync -avzh source destination
rsync -avzh username@shaiksameer.com:/u0/db/oracle/oradata/ /u0/db/oracle/oradata 
 

Tuesday, July 22, 2014

Create Oracle RAC 11gR2 database using dbca silent file


How to create a 11g RAC database using dbca silent response file.

dbca -progress_only -responseFile “/home/shaiksameer/dbca_testdb.rsp”

vi dbca_testdb.rsp
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = "TESTDB"
SID = "TESTDB"
NODELIST=machine1,machine2,machine3,machine4
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "syspass12"
SYSTEMPASSWORD = "systempass12"
STORAGETYPE=ASM
DISKGROUPNAME=DATA
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16
SAMPLESCHEMA=FALSE
MEMORYPERCENTAGE = "10"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"

or you can pass the variable values directly.

dbca -silent -nodelist machine1,machine2,machine3,machine4 
 -createDatabase -templateName General_Purpose.dbc 
 -gdbName TESTDB 
 -sid TESTDB 
 -SysPassword syspass12
 -SystemPassword systempass12 
-emConfiguration NONE 
-characterSet WE8ISO8859P15
 -totalMemory 500

Monday, July 21, 2014

The local BEA product registry is corrupted. Please select another Middleware Home or contact Oracle Support

While installing weblogic using silent install file you may get the below error:


Issue:-
=====
java -Xmx5096m -jar weblogic64/wls1036_generic.jar -mode=silent -silent_xml=weblogic_install.xml -logfile=weblogic_install.log
Extracting 0%....................................................................................................100%
The local BEA product registry is corrupted. Please select another Middleware Home or contact Oracle Support


Fix:-
====
Silent file contains incorrect product list, please correct the product list and try again. i.e either a "|" is missed or quotes so on...

Recitfy the silent file and rerun the install.

Ex:-
  <data-value name="COMPONENT_PATHS"
        value="WebLogic Server/Core Application Server|WebLogic Server/Administration Console|WebLogic Server/Configuration Wizard and Upgrade Framework|WebLogic Server/Web 2.0 HTTP Pub-Sub Server|WebLogic Server/WebLogic JDBC Drivers|WebLogic Server/Third Party JDBC Drivers|WebLogic Server/WebLogic Server Clients|WebLogic Server/WebLogic Web Server Plugins|WebLogic Server/UDDI and Xquery Support|Oracle Coherence/Coherence Product Files" />

Wednesday, July 16, 2014

Create weblogic domain using silent install

Create weblogic domain using silent file.



Create the silent file that you will use for domain creation:-
=====================================

vi /weblogic_path/stage/response_files/wl_create_domain_demo.rsp
************ File starts here ***********
read template from "/weblogic_path/WL_DEMO/wlserver_10.3/common/templates/domains/wls.jar";

set JavaHome "/weblogic_path/java/jdk1.8.0_05"; //Set JDK to use

set ServerStartMode "dev"; //production mode or development mode

//To create a Admin server find it from wls template
find Server "AdminServer" as AdminServer;
set AdminServer.ListenAddress "";
set AdminServer.ListenPort "8001";
set AdminServer.SSL.Enabled "true";
set AdminServer.SSL.ListenPort "8002";

//We can directly create a new managed server.
create Server "ms1" as MS1;
set MS1.ListenAddress "";
set MS1.ListenPort "8003";
//set MS1.SSL.Enabled "true";
//set MS1.SSL.ListenPort "7004″;

//Craeting Cluster
//create Cluster "MyCluster" as MyCl;

//Putting managed servers into the cluster
//assign Server "MS1″ to Cluster "MyCluster";
//assign Server "MS2″ to Cluster "MyCluster";

//Create Machine
create Machine "shaiksameer.com" as Machinename;

//Create JDBC datasource and targeting it to cluster
//create JDBCConnectionPool "demoPool" as mypool;
//set mypool.DriverName "com.pointbase.jdbc.jdbcUniversalDriver";
//set mypool.URL "jdbc:pointbase:server://localhost:9092/demo";
//set mypool.Password "PBPUBLIC";
//set mypool.Properties "user=PBPUBLIC";
//assign JDBCConnectionPool "*" to target "MyCluster";

//Create File Store
//create JMSFileStore "FileStore" as filestore;
//set filestore.Directory "d:\FStore";
//create JMS server
//create JMSServer "JMSServer" as jmsserver;
//set jmsserver.PersistentStore "FileStore"; //Add persistence store to the JMS server
//assign JMSServer "*" to target "MS1″;

//create JMS queue, default subdeployment will be created and targeted. Not sure
//create JMSQueue "Queue" as queue;
//set queue.JNDIName "jms/queue"; //JNDI name for Queue
//set queue.JMSServer "JMSServer"; //Target queue to JMS server

//use templates default weblogic user
find User "weblogic" as u1;
set u1.password "weblogic4u";

//create a new user
create User "shaiksameer" as u2;
set u2.password "weblogic4u";

write domain to "/weblogic_path/WL_DEMO/user_projects/domains/demo_domain"; // The domain name will be "demo-domain"

close template;

********File end here ********


Start the domain creation:-
==================
/weblogic_path/WL_DEMO/wlserver_10.3/common/bin> ./config.sh -mode=silent -silent_script=/weblogic_path/stage/response_files/wl_create_domain_demo.rsp -logfile=/weblogic_path/WL_DEMO/create_domain.log

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
<< read template from "/weblogic_path/WL_DEMO/wlserver_10.3/common/templates/domains/wls.jar"
>>  succeed: read template from "/weblogic_path/WL_DEMO/wlserver_10.3/common/templates/domains/wls.jar"
<< set config option JavaHome to "/weblogic_path/java/jdk1.8.0_05"
>>  succeed: set config option JavaHome to "/weblogic_path/java/jdk1.8.0_05"
<< set config option ServerStartMode to "dev"
>>  succeed: set config option ServerStartMode to "dev"
<< find Server "AdminServer" as AdminServer
>>  succeed: find Server "AdminServer" as AdminServer
<< set AdminServer attribute ListenAddress to ""
>>  succeed: set AdminServer attribute ListenAddress to ""
<< set AdminServer attribute ListenPort to "8001"
>>  succeed: set AdminServer attribute ListenPort to "8001"
<< set AdminServer attribute SSL!Enabled to "true"
>>  succeed: set AdminServer attribute SSL!Enabled to "true"
<< set AdminServer attribute SSL!ListenPort to "8002"
>>  succeed: set AdminServer attribute SSL!ListenPort to "8002"
<< create Server "ms1" as MS1
>>  succeed: create Server "ms1" as MS1
<< set MS1 attribute ListenAddress to ""
>>  succeed: set MS1 attribute ListenAddress to ""
<< set MS1 attribute ListenPort to "8003"
>>  succeed: set MS1 attribute ListenPort to "8003"
<< create Machine "shaiksameer.com" as Machinename
>>  succeed: create Machine "shaiksameer.com" as Machinename
<< find User "weblogic" as u1
>>  succeed: find User "weblogic" as u1
<< set u1 attribute Password to "********"
>>  succeed: set u1 attribute Password to "********"
<< create User "shaiksameer" as u2
>>  succeed: create User "shaiksameer" as u2
<< set u2 attribute Password to "********"
>>  succeed: set u2 attribute Password to "********"
<< write Domain to "/weblogic_path/WL_DEMO/user_projects/domains/demo_domain"
...............................................................................................
>>  succeed: write Domain to "/weblogic_path/WL_DEMO/user_projects/domains/demo_domain"
<< close template
>>  succeed: close template

Wednesday, June 18, 2014

Weblogic silent install

Sample xml file to install weblogic in silent mode. I have tested this on weblogic 10.3.6 /Linux OEL6


Create the xml file using the below options, remember to take out the products that you don't need.

vi weblogic_install.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- Silent installer option: -mode=silent -silent_xml=/PATH/silent.xml -->
<bea-installer>
  <input-fields>
  <data-value name="BEAHOME" value="/oracle/FMW/WebLogic" />
  <data-value name="COMPONENT_PATHS"
        value="WebLogic Server/Core Application Server|WebLogic Server/Administration Console|WebLogic Server/Configuration Wizard and Upgrade Framework|WebLogic Server/Web 2.0 HTTP Pub-Sub Server|WebLogic Server/WebLogic JDBC Drivers|WebLogic Server/Third Party JDBC Drivers|WebLogic Server/WebLogic Server Clients|WebLogic Server/WebLogic Web Server Plugins|WebLogic Server/UDDI and Xquery Support|Oracle Coherence/Coherence Product Files" />
  <data-value name="USE_EXTERNAL_ECLIPSE" value="false" />
  <data-value name="INSTALL_NODE_MANAGER_SERVICE" value="no" />
  <data-value name="NODEMGR_PORT" value="5559" />
  <data-value name="LOCAL_JVMS" value="/oracle/comn/java/jdk1.7.0_25"/>
  </input-fields>
</bea-installer>


Download weblogic from:-
=================
http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html


Install:-
======
java -Xmx1024m -jar ../weblogic64/wls1036_generic.jar -mode=silent -silent_xml=weblogic_install.xml
Extracting 0%....................................................................................................100%


Reference:-
http://docs.oracle.com/cd/E23943_01/doc.1111/e14142/silent.htm#i1044116

Tuesday, April 1, 2014

OID Get ORASSO password

Obtaining the Single Sign-On Schema Password



$ORACLE_HOME/bin/ldapsearch -h oidhostname -p portnumber -D "cn=orcladmin" -w orcladminpwd -b "orclReferenceName=, cn=IAS Infrastructure  Databases, cn=ias, cn=products, cn=oracleContext" -s sub "orclResourceName=ORASSO" orclpasswordattribute


Ex:-

$ORACLE_HOME/bin/ldapsearch -h oidhost01 -p 389 -D "cn=orcladmin" -w mypass -b "orclReferenceName=OIDDB, cn=IAS Infrastructure  Databases, cn=ias, cn=products, cn=oracleContext" -s sub "orclResourceName=ORASSO" orclpasswordattribute

Result:-
OrclResourceName=ORASSO,orclReferenceName=OIDDB,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext
orclpasswordattribute=PASSWORDHERE


Reference:-
========
http://docs.oracle.com/cd/B14099_19/idmanage.1012/b14078/schema.htm

Saturday, February 1, 2014

Enable FND Debug and get data from FND_LOG_MESSAGES table

Enable FND Debug and get log information from FND_LOG_MESSAGES table:

 

If the size of FND_LOG_MESSAGES table is too big? then

Considering running the concurrent request:  “Purge Debug Log and System Alerts”. 

 

 Enable Debug mode:-

=================

1)Log into system admin responsibility and set the following profile options
FND: Debug Log Enabled - Yes
FND: Debug Log Level - Statement  (Consider other options from the drop down if needed)
FND: Debug Log Module - %

 2)Capture the Max sequence number
 SELECT MAX(log_sequence)  b4seq# FROM fnd_log_messages;


 3)Try to reproduce the issue with above user for which FND profile options are set.

4)Capture the Max sequence number again:
SELECT MAX(log_sequence) afterseq# FROM fnd_log_messages;


5)Run following select to get the log messages
SELECT LOG_SEQUENCE, MESSAGE_TEXT, USER_ID FROM fnd_log_messages WHERE
log_sequence > b4seq# -1 and b4seq# 

Wednesday, January 8, 2014

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options ORA-27054 ORA-01580



RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/08/2014 18:02:28
ORA-01580: error creating control backup file /export/u0/DBS/dbs/snapcf_DBSP1.f
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Additional information: 1


The workaround recommended is to use the Event 10298.
sql> alter system set events '10298 trace name context forever, level 32';