Disable JDE password expire script

-- disable JDE password expire
alter profile DEFAULT limit password_life_time UNLIMITED;
alter profile DEFAULT limit password_grace_time UNLIMITED;
select resource_name,limit from dba_profiles where profile='DEFAULT';
---
spool /tmp/userUnLock.log
select username,account_status,to_char(EXPIRY_DATE, 'yyyy-mm-dd')Expire from dba_users;
alter user PS910DTA identified by PS910DTA;
alter user PS910CTL identified by PS910CTL;
alter user PS910 identified by PS910;
alter user TESTDTA identified by TESTDTA;
alter user TESTCTL identified by TESTCTL;
alter user DV910 identified by DV910;
alter user CRPDTA identified by CRPDTA;
alter user CRPCTL identified by CRPCTL;
alter user PY910 identified by PY910;
alter user PRODDTA identified by PRODDTA;
alter user PRODCTL identified by PRODCTL;
alter user PD910 identified by PD910;
alter user DD910 identified by DD910;
alter user OL910 identified by OL910;
alter user SVM910 identified by SVM910;
alter user SY910 identified by SY910;
alter user PRODUSER identified by PRODUSER;
alter user DEVUSER identified by DEVUSER;
alter user APPLEAD identified by APPLEAD;
alter user JDEDBA identified by JDEDBA;
alter user JDE identified by JDE;
alter user OVR_BIPLATFORM identified by ovsadminE1;
alter user OVR_MDS identified by ovsadminE1;
select username,account_status,to_char(EXPIRY_DATE, 'yyyy-mm-dd')Expire from dba_users;
spool off;
exit;

Troubleshoot Opennebula

Troubleshoot opennebula

ISSUE:  error: failed to connect to the hypervisor
error: error from service: CheckAuthorization: Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network co
nnection was broken.

On host check
virsh -c qemu:///system list

if fail fix /etc/libvirt/libvirtd.conf

auth_unix_ro = "none"
auth_unix_rw = "none"
unix_sock_group = "oneadmin"
unix_sock_ro_perms = "0770"
unix_sock_rw_perms = "0770"

# systemctl restart libvirtd

ISSUE: Command execution fail: 'if [ -x"/var/tmp/one/im/run_probes" ]

On nebula gui host as user oneadmin

$ onehost sync --force

Troubleshoot mgr in ceph Luminous

Note: change ceph1 according your server hostname

Check auth in ceph 

# ceph auth get mgr.ceph1
exported keyring for mgr.ceph1

[mgr.ceph1]
        key = AQDQn4pZkWQjKRAAmEQ45FZgqDeCL5i6ZhfS0g==
        caps mds = "allow *"
        caps mon = "allow profile mgr"
        caps osd = "allow *"

Create auth if needed by command
ceph auth get-or-create mgr.ceph1 mds 'allow *' mon 'allow profile mgr' osd 'allow *'

Check keying file and content in path /var/lib/ceph/mgr/ceph-ceph1

[root@ceph1 ceph-ceph1]# ls -l

total 4
-rw------- 1 ceph ceph 67 Aug  9 12:38 keyring

[root@ceph1 ceph-ceph1]# cat keyring

[mgr.ceph1]

        key = AQDQn4pZkWQjKRAAmEQ45FZgqDeCL5i6ZhfS0g==

Check mgr in systemd

# systemctl | grep mgr

systemctl reset-failed ceph-mgr@ceph1.service
systemctl enable ceph-mgr@ceph1.service
systemctl start ceph-mgr@ceph1.service