Even you dont have tnsora defined for your database , you can still connect to database using below shell script.
LOGIN_DATA="user/password@'
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XXX)(PORT=1521))
(CONNECT_DATA=(SID=SID)))'"
CONNECT=`sqlplus -S ${LOGIN_DATA} <<- span="">EOF
SET ECHO OFF;
select count(*) from table;
EOF`
echo "$CONNECT...
Firewalld: Add Puppet master ports to firewalld in CentOS7.
1. Find out what are your server's active zones.
[root@vihitaatma ~]# firewall-cmd --get-active-zones
public
interfaces: ens192
[root@vihitaatma ~]#
2 Puppet has different ports for different services.
3000: Web based installer
8140: Communication port between Puppet Master & Agent.
61613: Used by MCollective for orachestration requests by Puppet agents
443: Puppet...
SQL: Give grants to all tables in a schema
Use this procedure and just execute it as normal SQL query
BEGIN
FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner='Schema_name 1') LOOP
EXECUTE IMMEDIATE 'grant select,insert,update,delete on '||R.owner||'.'||R.table_name||' to <>';
END LOOP;
END;
Schema Name 1 : This is like to which schema you needed grants.
Schema name 2: This...
Subscribe to:
Posts (Atom)
