Best Of
Re: Start Single Instance Database in target node
Hi:
[grid@wapdbdevn1 ~]$ crsctl stat res -t
Name Target State Server State details
Local Resources
ora.LISTENER.lsnr
ONLINE ONLINE wapdbdevn0 STABLE
ONLINE ONLINE wapdbdevn1 STABLE
ora.chad
ONLINE ONLINE wapdbdevn0 STABLE
ONLINE ONLINE wapdbdevn1 STABLE
ora.net1.network
ONLINE ONLINE wapdbdevn0 STABLE
ONLINE ONLINE wapdbdevn1 STABLE
ora.ons
ONLINE ONLINE wapdbdevn0 STABLE
ONLINE ONLINE wapdbdevn1 STABLE
Cluster Resources
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE wapdbdevn0 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE wapdbdevn1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE wapdbdevn0 STABLE
ora.cvu
1 ONLINE ONLINE wapdbdevn1 STABLE
ora.qosmserver
1 ONLINE ONLINE wapdbdevn1 STABLE
ora.scan1.vip
1 ONLINE ONLINE wapdbdevn0 STABLE
ora.scan2.vip
1 ONLINE ONLINE wapdbdevn1 STABLE
ora.scan3.vip
1 ONLINE ONLINE wapdbdevn0 STABLE
ora.wap_dev.db
1 ONLINE ONLINE wapdbdevn1 Open,HOME=/u01/app/o
racle/product/19.0.0
.0/dbhome_1,STABLE
ora.wapdbdevn0.vip
1 ONLINE ONLINE wapdbdevn0 STABLE
ora.wapdbdevn1.vip
1 ONLINE ONLINE wapdbdevn1 STABLE
[grid@wapdbdevn1 ~]$ crsctl stat res ora.wap_dev.db -f
NAME=ora.wap_dev.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:dbaoper:r-x,user:grid:r-x
ACTIONS=relocate_client,group:"dba",group:"dbaoper",user:"grid",user:"oracle" status_target,group:"dba",group:"dbaoper",user:"grid",user:"oracle" listJavaServices,group:"dba",group:"dbaoper",user:"grid",user:"oracle" isPUJSDone,group:"dba",group:"dbaoper",user:"grid",user:"oracle" unmonitor,user:"grid" serviceDrain,group:"dba",group:"dbaoper",user:"grid",user:"oracle" monitor,user:"grid" startoption,group:"dba",group:"dbaoper",user:"grid",user:"oracle"
ACTION_SCRIPT=
ACTION_START_OPTION=
ACTION_TIMEOUT=600
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALLOW_RESTART=default
AUTO_START=restore
CARDINALITY=1
CARDINALITY_ID=0
CHECK_INTERVAL=900
CHECK_TIMEOUT=30
CLEAN_TIMEOUT=60
CLUSTER_DATABASE=false
CONFIG_VERSION=1
CSS_CRITICAL=no
DATABASE_TYPE=SINGLE
DB_UNIQUE_NAME=WAP_DEV
DEFAULT_NETNUM=
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Database resource
DISABLED_REASON=
DRAIN_ID=
DRAIN_TIMEOUT=
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=3600
FAILURE_THRESHOLD=4
GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/WAP_DEV/adump
GEN_RESTART=
GEN_RESTART@SERVERNAME(wapdbdevn0)=StartCompleted
GEN_RESTART@SERVERNAME(wapdbdevn1)=StartCompleted
GEN_START_OPTIONS=
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(wapdbdevn0)=WAP_DEV
GEN_USR_ORA_INST_NAME@SERVERNAME(wapdbdevn1)=WAP_DEV
HOSTING_MEMBERS=
ID=ora.wap_dev.db
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_COUNT=1
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
JAVA_SERVICES=
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
ORACLE_HOME_OLD=
OXR_SECTION=0
PATCH_IN_PROGRESS=false
PLACEMENT=restricted
PWFILE=+DATA/WAP_DEV/PASSWORD/orapwWAP_DEV
RANK=0
RELOCATE_ACTION=0
RELOCATE_BY_DEPENDENCY=1
RELOCATE_KIND=offline
RESOURCE_GROUP=
RESTART_ATTEMPTS=1
RESTART_DELAY=0
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.WAP_DEV
SERVER_POOLS_PQ=
SERVER_POOLS_RF=
SERVICE_NAMES=
SPFILE=+DATA/WAP_DEV/PARAMETERFILE/spfile.785.1215090841
START_CONCURRENCY=0
START_DEPENDENCIES=weak(type:ora.listener.type,uniform:ora.ons)
START_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="isEDV">False</Cond><Cond name="ASMClientMode">True</Cond><Arg name="acfs_or_nfs" type="ResList"></Arg><Cond name="OHResExist">False</Cond><Cond name="DATABASE_TYPE">SINGLE</Cond><Arg name="acfs_and_nfs" type="ResList"></Arg></xml>
START_DEPENDENCIES_TEMPLATE=<xml>hard(<If cond="isEDV" value="True"><Then><Res>{ccmb}</Res>,</Then></If><If cond="ASMClientMode" op="neq" value="True"><Then><If cond="ASMmode" value="remote"><Then><ResList>uniform:global:{dg}</ResList>,</Then><Else><ResList>{dg}</ResList>,</Else></If></Then></If><ResList>{acfs_or_nfs}</ResList><If cond="OHResExist" value="True"><Then>,<Res>{oraclehome}</Res></Then></If>) weak(<If cond="DATABASE_TYPE" op="eql" value="RAC|RACOneNode"><Then>type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns</Then><Else>type:ora.listener.type,uniform:ora.ons</Else></If>) dispersion(<If cond="DATABASE_TYPE" value="RACOneNode"><Then><If cond="DB_CENTRIC" value="False"><Then>type:ora.database.type</Then></If></Then></If>) pullup(<If cond="ASMClientMode" op="neq" value="True"><Then><If cond="MANAGEMENT_POLICY" op="neql" value="MANUAL|NORESTART"><Then><If cond="ASMmode" value="remote"><Then><ResList>global:{dg}</ResList>,</Then><Else><ResList>{dg}</ResList>,</Else></If></Then></If></Then></If><ResList>{acfs_and_nfs}</ResList><If cond="OHResExist" value="True"><Then>,<Res>{oraclehome}</Res></Then></If>)</xml>
START_TIMEOUT=600
STATE=ONLINE
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=
STOP_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="ASMClientMode">True</Cond><Arg name="nfs" type="Res"></Arg><Cond name="OHResExist">False</Cond><Cond name="isEDV">False</Cond></xml>
STOP_DEPENDENCIES_TEMPLATE=<xml><If cond="ASMClientMode" op="neq" value="True"><Then><If cond="DGExist" value="True"><Then><If cond="ASMmode" value="remote"> <Then>hard(global:intermediate:ora.asm,<ResList>global:shutdown:{dg}</ResList>)</Then> <Else>hard(intermediate:ora.asm,<ResList>shutdown:{dg}</ResList>)</Else> </If></Then> </If>hard(<Res>{acfs_same_as_oh}</Res>,<ResList>intermediate:{acfs}</ResList>)</Then> <Else>hard(intermediate:<Res>{nfs}</Res>)</Else> </If><If cond="OHResExist" value="True"><Then>hard(intermediate: <Res>{oraclehome}</Res>)</Then></If><If cond="isEDV" value="True"><Then>hard(intermediate:<Res>{ccmb}</Res>)</Then></If></xml>
STOP_TIMEOUT=600
TARGET=ONLINE
TARGET_DEFAULT=default
TARGET_NAME=
TARGET_TYPE=
TYPE_VERSION=3.3
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_QOS_DATA=no
USE_STICKINESS=0
USR_ORA_DB_NAME=WAP_DEV
USR_ORA_DOMAIN=cpd0.urv.cat
USR_ORA_ENV=ORACLE_BASE=/u01/app/oracle TZ=Europe/Madrid
USR_ORA_FLAGS=
USR_ORA_INST_NAME=WAP_DEV
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0
Regards
Jordi
Re: Recent OPC update: Opening multiple projects at once. Why am I not seeing this option?
We are already in May and no update. Lol.
Re: My Oracle Support Login Issues
Hi,
I also found that I do not have access to KB167206. Since your contract is confirmed to be active, I would suggest contacting official support directly rather than using the community forum. They should be able to investigate the access issue and provide a resolution for you.
Regards,
asahide
Re: Product Certifications in the New My Oracle Support Cloud Portal
Hi Prasad,
At this time, we don’t have any confirmed plans or committed timeline to add voice search capabilities to the search bar.
Thanks,
Desiree
Re: Oracle supplied Oracle Linux AWS AMIs gone
Checked for the AMIs today. No luck. "Mid to late April" doesn't seem to have been entirely accurate.
Re: Opatch for OMS24ai
Good to hear, now move on:
- Agent OMS Patch
- Searching a candidate Agent for Gold Image
- Patch this candidate too
- Bring Agent JDK to latest approved JDK release
- Rollout Agent
Or do it by Patch Plan, but take a look in GI, this makes your life much easier.
Re: Using Rework (RWK) Step in 'M' Type Routing
Hi @User_KUZ38
No, it is not possible to include a rework (RWK) step in an "M" type routing.
Mixing routing types within a single routing is not allowed. Costing is performed only for "M" type routings, and adding other types can result in variances.
As a workaround, you can use a user-defined field in the routing to help manage this and avoid accounting variances.
Regards,
Mahesh
Re: Master Routings for process items.
Hi,
No, it is not possible to create master routings for process items with different co-products.
In process manufacturing, routing controls all variables, and different co-products may require different processes. It is not feasible to produce different products with the same ingredients and process.
Also, master routings are mainly designed for discrete manufacturing and not for process manufacturing scenarios.
Regards,
Mahesh