via TomWillFixIT.com http://www.facebook.com/pages/p/133762196688221
Sunday, January 27, 2013
Sunday, January 13, 2013
Disabling Java for a few days may be a good move. Check out : http://gizmodo.com/5975475/how-to-disable-java-in-your-browser
via TomWillFixIT.com http://www.facebook.com/pages/p/133762196688221
Saturday, January 5, 2013
Need to provide better customer service? Communicate better with colleagues and customers? Check out Google Community for your business : http://socialfresh.com/google-plus-communities/
via TomWillFixIT.com http://www.facebook.com/pages/p/133762196688221
Thursday, January 3, 2013
In the future you will be able to swagger through downtown Timbuktu like a local : http://mashable.com/2013/01/03/michael-jones-google-maps
via TomWillFixIT.com http://www.facebook.com/pages/p/133762196688221
Thursday, October 27, 2011
Check that Oracle DB 11.2.0.2 test db is receiving connections
Logged in as oracle user this works :
Make sure ORACLE_HOME, ORACLE_SID and PATH are all set :
# echo $ORACLE_HOME
/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1
# echo $ORACLE_SID
orcl
# echo $PATH
/usr/bin:/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1/bin:
# $ORACLE_HOME/bin/sqlplus -s "/ as sysdba"<<! > /tmp/check_$ORACLE_SID.tom.ora
> select * from v\$database;
> exit
> !
# cat /tmp/check_$ORACLE_SID.tom.ora
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE PR
Command :
/bin/su - oracle -c "ORACLE_HOME=/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1;export ORACLE_HOME;ORACLE_SID=orcl;export ORACLE_SID;$ORACLE_HOME/bin/sqlplus -s '/ as sysdba'<<! > /tmp/check_$ORACLE_SID.ora
select * from dual;
exit
!"
Make sure ORACLE_HOME, ORACLE_SID and PATH are all set :
# echo $ORACLE_HOME
/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1
# echo $ORACLE_SID
orcl
# echo $PATH
/usr/bin:/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1/bin:
# $ORACLE_HOME/bin/sqlplus -s "/ as sysdba"<<! > /tmp/check_$ORACLE_SID.tom.ora
> select * from v\$database;
> exit
> !
# cat /tmp/check_$ORACLE_SID.tom.ora
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE PR
Command :
/bin/su - oracle -c "ORACLE_HOME=/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1;export ORACLE_HOME;ORACLE_SID=orcl;export ORACLE_SID;$ORACLE_HOME/bin/sqlplus -s '/ as sysdba'<<! > /tmp/check_$ORACLE_SID.ora
select * from dual;
exit
!"
Subscribe to:
Posts (Atom)