ASM new features in Oracle 12c

Below are the ASM new features of Oracle 12c version:
==========================================
1. Connecting to ASM instance of remote node:
Now we can connect to asmcmd prompt(asm instance) of remote node from local node.
SYNTAX – asmcmd –inst < REMOTE ASM INSTANCE NAME>

asmcmd --inst +ASM2
2.Move ASM password file using pwmove:
We can move the asm pwfile from one diskgroup to another diskgroup online using pwmove command.
Check the asm pwfile location
$ crsctl stat res ora.asm -p|grep PWFILE
PWFILE=+MGMTDB/orapwASM
$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
Connect to asmcmd and run pwmove command
$echo $ORACLE_HOME
$/crsapp/app/oracle/product/grid12c
echo $ORACLE_SID
+ASM1
$ asmcmd
ASMCMD> pwmove --asm +MGMTDB/orapwASM +B2BWMDB/orapwASM
moving +MGMTDB/orapwASM -> +B2BWMDB/orapwASM
Check the new location.
crsctl stat res ora.asm -p|grep PWFILE
PWFILE=+B2BWMDB/orapwASM
Check the crs status:

$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
We can see cluster components are online during the password movement activity.
3. Rebalance from asmcmd :
Now we can do rebalance of diskgroup from asmcmd prompt also.
To rebalance a diskgroup with power limit of 100
SYNTAX –
rebal –power < POWER_LIMIT> < DISKGROUP_NAME>
ASMCMD> rebal --power 100 B2BWMDB
Rebal on progress.
To monitor the rebalance operation:
ASMCMD> lsop
Group_Name Pass State Power EST_WORK EST_RATE EST_TIME
B2BWMDB COMPACT WAIT 1 0 0 0
B2BWMDB REBALANCE RUN 1 12072 4400 2
4. Miscellaneous asmcmd commands:
Check the patches installed in grid home:

ASMCMD> showpatches
Check asm instance version:
ASMCMD> showversion
Check the cluster mode:
ASMCMD> showclustermode
ASM cluster : Flex mode disabled
Check the cluster state:
ASMCMD> showclusterstate
Normal

Comments

Post a Comment

Popular posts from this blog

Troubleshooting EBS login page issue in R12.2:

Troubleshooting EBS login page issue in R12.2: ------------------------------------------------------------------------------------------------------------------- 1. If the login page doesn't comes up then we have to focus on the varios logs present under $LOG_HOME directory. In case of EBS 12.2(as it is the latest release), 1) OHS (apache) failure If OHS is not running or not responding, one would see a message as below. If OHS is not running then there will not be any messages in any EBS log file for this request. Firefox: “The connection was reset” Steps to take Check OHS has started OK adapcctl.sh status adapcctl.sh stop adapcctl.sh start 2 OACore JVM process not available If the OACore JVM is not running or not reachable, then one will likely see the following message in the browser: Failure of server APACHE bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. There could be two reas...
Read more

Oracle Apps EBS R12.2 Login Flow

Image
EBS R12.2 Login Flow When a HTTP request is made for EBS, the request is received by the Oracle HTTP Server (OHS). When the configuration of OHS is for a resource that needs to be processed by Java, such as logging into EBS, the OHS configuration will redirect the request to the Web Logic Server (WLS) Java process (OACore in this case). WLS determines the J2EE application that should deal with the request, which is called "oacore". This J2EE application needs to be deployed and available for processing requests in order for the request to succeed.   The J2EE application needs to access a database and does this via a datasource which is configured within WLS. Login HTTP headers When the EBS login works OK, the browser will be redirected to various different URLs in order for the login page to be displayed.  The page flow below shows the URLs that will be called to display the login page: /OA_HTML/AppsLogin EBS Login URL /OA_HTML/AppsLocalLogin.jsp Redir...
Read more

Oracle apps dba Interview Q&A's

Oracle apps dba Interview Q&A's: =========================== What is the significance of utl_file_dir parameter in init.ora file? ===================================================================== Answer The value of this parameter is the group of directories to which u r database can write,  means u r database packages have permission to write to flat files in these directories. What is APPLPTMP environment variable? ======================================= Answer This is the temporary file location for the pl/sql temp files.  If this variable was not set then the concurrent programs may error-ed out. DIAG_PARAM ="Y" in adcmctl.sh. for CM issues oracle apps concurrent managers interview question and common information's Question:Error: ================ After submitting the concurrent program, i am getting the status as inactive and no manager and when i clicked on diagnostics button its showing a message like This request will not be pro...
Read more