It is better to use scp/sftp rather than ftp – because ftp transmits passwords in plain text and also requires extra firewall openings to work. 1) Simplest way – use sftp specfiying the password in the script, like this: lftp -u user:password sftp://server.domain.com << END_LFTP put /directory/file.txt quit END_LFTP Use the -O option to put […]
Read More scp and sftp either with or without a password using authorized keysSteps to shrink msdb database in SQL Server 2005: T-SQL: truncate table msdb.dbo.log_shipping_monitor_history_detail T-SQL: exec msdb.dbo.sp_purge_jobhistory @oldest_date='2013-02-07T13:55:10'(change date above as required) T-SQL: alter index all on msdb.dbo.sysjobhistory reorganize Management Studio: system databases > msdb > tasks > shrink > databaseOR, same thing in T-SQL: dbcc shrinkdatabase('msdb') To see disk usage for a database: Management Studio: […]
Read More Shrink msdb database SQL ServerHere is the crib sheet/study notes I used for the three exams: 70-457 Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 – Part 1 70-458 Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 – Part 2 70-459 Transition your MCITP on SQL Server 2008 to MCSE: Data Platform […]
Read More Study notes crib sheet for exams 70-457 70-458 70-459 MCSE SQL Server 2012Some fun from the Angry DBA site – http://web.archive.org/web/20050206023801/http://www.angrydba.com/ Contents: Why are DBA’s angry? Angry DBA stories Is your DBA angry? Angry DBA Gallery How to make your DBA angry DBA Jokes Are you an angry DBA? The website disappeared a long time ago, but is still available thanks to the Wayback Machine. H/t APC.
Read More Angry DBARman catalog can be upgraded to a higher version than its hosting database oracle version. This is useful if you want to back up new versions of oracle without changing the oracle version on the database used to host the rman catalog. To do this, run the following commands from the higher version oracle database: […]
Read More Upgrade rman catalog – no need to upgrade oracle database versionI used the steps below to apply patchset 11.2.0.3 to an existing 11.2.0.2 2-node RAC cluster on linux RHEL 5.8 64 bit. Note that GRID_HOME and DB_HOME locations will both be changed as part of this patchset. 0) Download and unzip software from My Oracle Support into e.g. /unzipped Main patch is 7 large zipfiles, […]
Read More Patch upgrade Oracle RAC 11.2.0.2 to 11.2.0.3 on linuxFound this error on upgrade to 11gR2 trying to call Oracle Reports from within database: ERROR at line 1: ORA-20001: Error for submit_report. Report: ab_batch. Error -29273 ORA-29273: HTTP request failed ORA-06512: at “SYS.UTL_HTTP”, line 1722 ORA-24247: network access denied by access control list (ACL) ORA-06512: at “MYUSER.MYPROC”, line 60 ORA-06512: at line 1 Fix […]
Read More Fix for ORA-24247 ACL calling Oracle ReportsSee which remote databases are using a ‘materialized view log’ on source database with: SELECT mview_site , COUNT(*) FROM dba_registered_mviews GROUP BY mview_site ORDER BY 1 ; The snaptime$$ column shows how old the data is in any materialized view log: SELECT TRUNC(snaptime$$) , COUNT(*) FROM owner.mlog$_mytable GROUP BY TRUNC(snaptime$$) ORDER BY 1 ; Oracle’s […]
Read More List databases using materialized view logI found I had to disable the virbr0 network interface to get Oracle RAC 11gR2 11.2.0.2 to install correctly (on RHEL 5.8 64 bit 2.6.18-308.el5 with ocfs2). Problem was that root.sh failed on the second node. The error recorded in ocssd.log, “has a disk HB, but no network HB”, appeared to point to the multicast […]
Read More RAC 11.2.0.2 Grid install fails on second node until disable virbr0 virtual networkProblem today where one hourly cron MV refresh hung (waiting on “SQL*Net message from dblink”), causing the other refreshes to queue up waiting on locks, eventually using up all the session so users got “ORA-00018: maximum number of sessions exceeded” To prevent this happening in the future, it is possible to timeout the MV refresh […]
Read More Timeout SQL materialized view refresh