operator   1278

« earlier    

Seamless Istio control plane upgrade · Banzai Cloud
うーん、なるほどな。やっぱこういう流れになっていくのかね。
istio  kubernetes  operator 
16 days ago by summerwind
Kubernetes native Jenkins Operator – VirtusLab – Medium
The Jenkins Operator is a Kubernetes native operator which fully manages Jenkins on Kubernetes. It is easy to install with just a few manifests and allows users to configure and manage Jenkins on…
jenkins  kubernetes  operator  operators 
17 days ago by pinterb
What Happens To Undo Tablespace During DataPump Import And How To Fix It
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

2. For large database imports – it really matters. You don’t want the UNDO tablespace to grow too big and run out of space.

This is exactly what you do:

prior to running the import, disable the primary key constraints. If you have foreign key constraints that reference these primary keys, disable those as well.
ALTER TABLE ... MODIFY CONSTRAINT ... DISABLE NOVALIDATE;
import data only, and create the indexes on the tables, after the import.
use the following parameter for impdp:
ACCESS_METHOD=DIRECT_PATH
after import completes, enable the primary key constraints (and of course foreign key constraints if applicable).
ALTER TABLE ... MODIFY CONSTRAINT ... ENABLE VALIDATE

Dbaparadise.com Tip:

Prior to running the import, generate the disable constraint statements, and in the same time the enable constraint statements:

--disable constraints
select 'ALTER TABLE ' || owner || '.' || table_name || ' MODIFY CONSTRAINT ' || constraint_name || ' DISABLE NOVALIDATE;'
from dba_constraints where owner='HR'
and constraint_type='P'
order by owner, table_name,constraint_name;

--enable constraints
select 'ALTER TABLE ' || owner || '.' || table_name || ' MODIFY CONSTRAINT ' || constraint_name || ' ENABLE VALIDATE;'
from dba_constraints
where owner='HR'
and constraint_type='P'
order by owner, table_name,constraint_name;
For your next large datapump import, you know: Disable PK constraints prior to the import!
oracle  database  operator  import  impdp  tablespace  undo  undotbs 
25 days ago by iteruel
EM 12c : El Error ORA-00020 en la BD del Repositorio OMS
SQL> select count(1),USERNAME from gv$session group by USERNAME;

set lines 250
col inst_id for 99
col program for a60
col username for a15
col event for a35
col module for a30
col action for a30
col state for a10
select inst_id,sid,sql_id,module,action,username,status,state,event,p1,p2 from gv$session
where status='ACTIVE' and
event not in ('smon timer','pmon timer','rdbms ipc message','Null event',
'parallel query dequeue','pipe get','client message',
'SQL*Net message to client','SQL*Net message from client',
'SQL*Net more data from client','dispatcher timer',
'virtual circuit status','lock manager wait for remote message',
'PX Idle Wait','PX Deq: Execute Reply','PX Deq: Execution Msg',
'PX Deq: Table Q Normal','PX Deq Credit: send blkd','PX Deq: Execute Reply',
'PX Deq Credit: need buffer','PX Deq: Signal ACK','PX Deque wait',
'wakeup time manager','slave wait','i/o slave wait','jobq slave wait',
'null event','gcs remote message','gcs for action','ges remote message',
'queue messages','Streams AQ: waiting for messages in the queue',
'DIAG idle wait','VKTM Logical Idle Wait','ASM background timer','fbar timer',
'Streams AQ: waiting for time management or cleanup tasks',
'Streams AQ: qmn coordinator idle wait','Streams AQ: qmn slave idle wait',
'class slave wait','Space Manager: slave idle wait','JOX Jit Process Sleep',
'EMON slave idle wait','GCR sleep','LNS ASYNC end of log','PING',
'Streams AQ: emn coordinator idle wait','wait for unread message on broadcast channel')

SQL> /

SQL> SELECT sid, event, p1raw, seconds_in_wait, wait_time
FROM sys.v_$session_wait
WHERE event like 'library cache%'
AND state = 'WAITING' 2 3 4 ;
oracle  database  admin  operator  process  ora-00020 
28 days ago by iteruel
ORA-00020: maximum number of processes exceeded
SELECT
inst_id,resource_name,
current_utilization,
max_utilization,
limit_value
FROM gv$resource_limit
WHERE resource_name in ('processes','sessions');

select distinct
s.inst_id,
s.username,
s.machine,
count(*)
from gv$session s,
gv$process p
where s.paddr = p.addr
and s.inst_id = p.inst_id
GROUP BY s.inst_id,
s.username,
s.machine
ORDER BY 4 desc;
oracle  database  admin  operator  process  ora-00020 
28 days ago by iteruel
ORA-00020 maximum number of processes exceeded
How to increase PROCESSES initialization parameter:

1. Login as sysdba
sqlplus / as sysdba

2. Check Current Setting of Parameters
sql> show parameter sessions
sql> show parameter processes
sql> show parameter transactions

3. If you are planning to increase "PROCESSES" parameter you should also plan to increase "sessions and "transactions" parameters
A basic formula for determining these parameter values is as follows:

processes=x
sessions=x*1.1+5
transactions=sessions*1.1

4. These paramters can't be modified in memory. You have to modify the spfile only (scope=spfile) and bounce the instance.
sql> alter system set processes=500 scope=spfile;
sql> alter system set sessions=555 scope=spfile;
sql> alter system set transactions=610 scope=spfile;
sql> shutdown abort
sql> startup
oracle  database  admin  operator  process  ora-00020 
28 days ago by iteruel
Analysis of Open source Kubernetes Operators – CloudARK – Medium
In this post we present analysis of open source Kubernetes Operators available on GitHub. Operators have now become mainstream in Kubernetes world. Over 400 GitHub repositories show up as a result of…
kubernetes  operators  operator  cloudark  bestpractices  bestpractice 
4 weeks ago by pinterb
Displays the DDL for a specific role
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/script_creation/role_ddl.sql
-- Author : Tim Hall
-- Description : Displays the DDL for a specific role.
-- Call Syntax : @role_ddl (role)
-- Last Modified: 28/01/2006
-- -----------------------------------------------------------------------------------

set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on
column ddl format a1000

begin
dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'SQLTERMINATOR', true);
dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'PRETTY', true);
end;
/

variable v_role VARCHAR2(30);

exec :v_role := upper('&1');

select dbms_metadata.get_ddl('ROLE', r.role) AS ddl
from dba_roles r
where r.role = :v_role
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', rp.grantee) AS ddl
from dba_role_privs rp
where rp.grantee = :v_role
and rownum = 1
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', sp.grantee) AS ddl
from dba_sys_privs sp
where sp.grantee = :v_role
and rownum = 1
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', tp.grantee) AS ddl
from dba_tab_privs tp
where tp.grantee = :v_role
and rownum = 1
/

set linesize 80 pagesize 14 feedback on verify on
oracle  database  operator  ddl  get  security  role 
4 weeks ago by iteruel
OperatorHub.io | The registry for Kubernetes Operators
OperatorHub.io is a new home for the Kubernetes community to share Operators. Find an existing Operator or list your own today.
operatorhub  kubernetes  operator  hub  collection  devops  list 
5 weeks ago by vicchow

« earlier    

related tags

*  4th  access  ada  admin  advanced  advisor  alexa  amateur  amazon  ansible  app  array  article  assistant  authentication  authorization  backup  basics  bestpractice  bestpractices  bit  bitwise  bonny  book  bot  c++  chatbot  check  claims  class  cloud  cloudark  cnc  collection  communication  complete  configuration  container  controller  coreos  crd  creation  customresourcedefinitions  cylinder  database  ddl  deployment  devops  dex  docker  documentation  door  duckduckgo  elastic  elasticsearch  elixir  engine  equals  example  expression  facebook  fb  filter  find  framework  get  gets  gitops  gmail  gnatsd  google  guide  ham  hams  hashicorp  helm  help  howto  hub  image  impdp  import  important  interpolation  irish  istio  italian  its  jenkins  k8s  kafka  kill  kotlin  kubernete  kubernetes  kurs  lang-pl  language  learn  less  link  list  lock  locks  lxc  lxd  management  map  mastercam  message  metric  mobile  monitoring  mortise  mysql  nats  notation  note  object  on  openpolicyagent  openshift  openstack  operand  operation  operations  operatorhub  operators  or  ora-00020  oracle  order  pattern-matching  pattern  percent  persistent  phone  postfix  postgresql  pr  presentation  process  product  programista  prometheus  promethus  puerto  pvc  qrz  query  radio  rail  ransom  receptionist  redhat  redis  reference  referencials  registry  rico  rman  role  ruby  scala  sdk  search  security  seo  service  servicemesh  set  setup  shell-operator  single  sinumerik-808d  sms  splat  stackoverflow  storage  string  struct  support  swift  syntax  sysdig  szkolenie  tablespace  technolog  terraform  terrafotm-operator  thanos  theory  tie  tip  tips  tools  trick  tuple  tutorial  tv  twilio  undo  undotbs  user  vault-operator  vault  vertical  vim  virtual  vm  volume  website  with 

Copy this bookmark:



description:


tags: