Create a new Jabber account and enter the following details:
account : username@techienotes.info
encryption required TLS/ssl : (unmarked)
ignore ssl certificate error : (unmarked)
server : talk.google.com
port : 5222 (default)
use old ssl : (unmarked)
Source
#!/usr/bin/bash
# This script calls the Ad_1.sql script and spools the output with date stamp to a log file
# Update: You MUST add your environment variables one way or another, e.g. look below
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/OraHome_1
PATH=${PATH}:${ORACLE_HOME}/bin; export PATH
export LIBPATH=${LIBPATH}:${ORACLE_HOME}/lib32:${ORACLE_HOME}/lib
if [ ! -f lock ]; then
sqlplus -s user/password@sid << EOF
column dcol new_value mydate noprint
select sysdate dcol from dual;
spool log_ad_1_&mydate..log
@Ad_1.sql;
spool off
EOF
fi
where:
if [ ! -f lock ]: very useful statement, it checks whether a file named “lock” exists or not, if it doesn’t exist, it will not execute the code block within.
sqlplus -s usr/passwod@sid: to run sqlplus commands as if I’m entering the commands manually, the -s flag lets sqlplus accept the standardin input until it finds the word “EOF”
Part 2 will be about adding the above script in crontab and executing it daily.
Using SYSDATE you can query the current date and put it in a substitution variable. The substitution variable can then be used in a SPOOL command:
column dcol new_value mydate noprint
select to_char(sysdate,’YYYYMMDD’) dcol from dual;
spool &mydate.report.txt
— my report goes here
select last_name from employees;
spool off
Well, this is the article number 200 in this blog, I’m so proud of this 🙂
View Profile Assigned to a User:
SELECT PROFILE FROM DBA_USERS
WHERE USERNAME=’SCOTT’;
PROFILE
———-
DEFAULT
View Limits Set for the Profile:
SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES
WHERE PROFILE=’DEFAULT’;
RESOURCE_NAME LIMIT
———————— ————-
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_ FUNCTION NULL
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
16 rows selected.
Alter FAILED_LOGIN_ATTEMPTS Parameter:
From the user’s profile we can see that the FAILED_LOGIN_ATTEMPTS parameter is set to a value of 10. Now we run below command to make it UNLIMITED.
SQL> ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Profile altered.
Unlock the Account:
Finally we will unlock the account by running below command.
SQL> ALTER USER SCOTT ACCOUNT UNLOCK;
Update: You’d better NOT change the settings for the “DEFAULT” profile, create a new profile instead “create profile new_profile LIMIT bla bla bla“and then assign it to the given user “alter user olap profile new_profile“
Just Some Techie Notes! 