Tag: Oracle Database

firewall-cmd –get-zones MYSQL SERVER firewall-cmd --permanent --zone=public --change-interface=eth0 firewall-cmd --permanent --zone=public --list-all firewall-cmd --permanent --zone=public --add-port=3306/tcp firewall-cmd --reload CONFLUENCE, JIRA & QUALYS firewall-cmd --permanent --zone=public --add-port=80/tcp firewall-cmd --permanent --zone=public --add-port=443/tcp firewall-cmd --permanent --zone=public --add-port=8090/tcp firewall-cmd --permanent --zone=public --add-port=8080/tcp firewall-cmd --permanent --zone=public...

[ad#ad-post] Create User: CREATE PROFILE "QUALYS_PROFILE" LIMIT FAILED_LOGIN_ATTEMPTS 3 PASSWORD_GRACE_TIME 10 PASSWORD_REUSE_TIME UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_MAX 1; CREATE USER "QUALYS_SCAN" PROFILE "QUALYS_PROFILE" IDENTIFIED BY "<QUALYS_PASSWORD>" DEFAULT TABLESPACE "USERS" ACCOUNT UNLOCK; CREATE ROLE "QUALYS_ROLE"; GRANT "QUALYS_ROLE" TO "QUALYS_SCAN"; CREATE OR REPLACE VIEW...

[ad#ad-post] Stop all the OMS $OMS_HOME/bin/emctl stop oms Modify the SYSMAN password $OMS_HOME/bin/emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys pwd> -new_pwd <new sysman pwd> Re-start all the OMS $OMS_HOME/bin/emctl stop oms -all $OMS_HOME/bin/emctl start oms [ad#ad-post]...

I found this site, and I think these cheatsheets are pretty nice: http://cheatsheet4oracledba.blogspot.com/2011/09/rman-commands-cheatsheet.html [ad#ad-post]...

I ran into a problem when trying to upgrade my Oracle Enterprise Manager server from 11g to 12c. It appeared that I was missing a dependency package, that I didn’t notice was required. If you are trying to install, and are having the...

I found this handy when I was working with two databases at work: http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/backrest003.htm [ad#ad-post]...

stty erase [press your backspace key here] stty erase ^H [ad#ad-post]...