ERROR: The following required ports are in use:
----------------------------- 70X0 : WLS Admin Server Port
Fix:
Using patch environment, run adstpall.sh forcepatchfs
all about Oracle Applications
CREATE MATERIALIZED VIEW "ABC"You can create a view first and select from the view, or:
TABLESPACE "XYZ"
PCTFREE 10 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT)
NOLOGGINGPARALLEL (DEGREE 4) CACHE USING NO INDEX
REFRESH FORCE START WITH to_date('04-11-2011 11:58:35','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1/24 AS select * from abc@dblink
CREATE MATERIALIZED VIEW "ABC"
TABLESPACE "XYZ"
PCTFREE 10 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT)
NOLOGGINGPARALLEL (DEGREE 4) CACHE USING NO INDEX
REFRESH FORCE START WITH to_date('04-11-2011 11:58:35','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1/24 AS select * from (select * from abc@dblink)
# rpm -q ovs-agent
ovs-agent-2.3-38
rs.append(("ha_check_oracle_vm_version", ha_check_oracle_vm_version(hosts)))3. Comment out the specific line to bypass the pre-check. For example, to bypass the CPU compatibility check change the line as below:
rs.append(("ha_check_agent_version", ha_check_agent_version(hosts)))
rs.append(("ha_check_cpu_compatibility", ha_check_cpu_compatibility(hosts)))
rs.append(("ha_check_hostname_ip", ha_check_hostname_ip(hosts)))
rs.append(("ha_check_storage_repos", ha_check_storage_repos(hosts, ha_enable)))
rs.append(("ha_check_ocfs2_config", ha_check_ocfs2_config(hosts)))
# rs.append(("ha_check_cpu_compatibility", ha_check_cpu_compatibility(hosts)))4. Restart the agent
# service ovs-agent restart
OVSAgentServer shutdown...
OVSAgentServer stopped.
OVSAgentServer is now starting...
OVSAgentServer started.
5. This procedure will need to be executed on any pool server that might become a master via HA. After completing it, you will be able to add a server node that had previously failed with the ha_check_cpu_compatibility error.# service ovs-agent restart --disable-nowayout
rs.append(("ha_check_cpu_compatibility", ha_check_cpu_compatibility(hosts)))
select
substr(a.spid,1,9) pid,
substr(b.sid,1,5) sid,
substr(b.serial#,1,5) ser#,
substr(b.machine,1,6) box,
substr(b.username,1,10) username,
substr(b.osuser,1,8) os_user,
substr(b.program,1,30) program
from
v$session b,
v$process a
where
b.paddr = a.addr
and type='USER'
order by spid;
orwhere column_name = nvl(:parameter, column_name)
orwhere column_name like nvl(:parameter, '%')
where (column_name = :parameter or :parameter is null)
Then you can kill it with (change sid and serial# using result from query above):select s.username,s.sid,s.serial#,s.last_call_et/60 mins_running,q.sql_text from v$session s
join v$sqltext_with_newlines q
on s.sql_address = q.address
where status='ACTIVE'
and type <>'BACKGROUND'
and last_call_et> 60
order by sid,serial#,q.piece
ALTER SYSTEM KILL SESSION 'sid,serial#';