{"id":1066,"date":"2006-08-29T12:00:00","date_gmt":"2006-08-29T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1066"},"modified":"2006-08-29T12:00:00","modified_gmt":"2006-08-29T12:00:00","slug":"great-expectations","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/08\/29\/great-expectations\/","title":{"rendered":"Great Expectations"},"content":{"rendered":"

I’m working on our script to change the oracle owner unix account password across our server estate at the moment and it occurred to me it might be worth mentioning the expect<\/a> utility for anyone who might not have come across it. It allows you to write scripts that automate ssh, ftp, telnet (etc.) sessions. In our case, we have a script to login to each of the servers in turn and change the account password using old and new passwords we supply. <\/p>\n

Well worth a look if you haven’t seen it before.<\/p>\n","protected":false},"excerpt":{"rendered":"

I’m working on our script to change the oracle owner unix account password across our server estate at the moment and it occurred to me it might be worth mentioning the expect utility for anyone who might not have come across it. It allows you to write scripts that automate ssh, ftp, telnet (etc.) sessions.… Continue reading Great Expectations<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1066","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1403,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/17\/moving-awr-data\/","url_meta":{"origin":1066,"position":0},"title":"Moving AWR data","date":"April 17, 2008","format":false,"excerpt":"Note - features in this post require the Diagnostics Pack license[I originally had the first section at the end of the blog post, but then realised I might as well get the bad news out of the way to save you wasting your time if you're not interested]A small section\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1312,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/02\/full-volume-database-refresh-part-4\/","url_meta":{"origin":1066,"position":1},"title":"Full Volume Database Refresh – Part 4","date":"September 2, 2007","format":false,"excerpt":"As a post-script to the earlier blogs, Alex Gorbachev suggested a link to his UKOUG 2006 presentation in this area might prove useful and I agree. So here it is.","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1332,"url":"http:\/\/orcldoug.com\/blog\/2007\/10\/28\/script\/","url_meta":{"origin":1066,"position":2},"title":"Script","date":"October 28, 2007","format":false,"excerpt":"Well, as the which blog was deemed useful (although most commentors did already know about it), how about the script Unix command?It's very useful for keeping a record of an extended series of actions, like those a DBA will often encounter when implementing a complex change. It's also useful for\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1449,"url":"http:\/\/orcldoug.com\/blog\/2008\/09\/29\/oow-2008-presentations\/","url_meta":{"origin":1066,"position":3},"title":"OOW 2008 Presentations","date":"September 29, 2008","format":false,"excerpt":"I noticed via H.Tongu\u00e7 Y\u0131lmaz's blog that some of the presentation slides have started to appear.1) Go to http:\/\/www28.cplan.com\/cc208\/login.jsp 2) Username\/Password is cboracle\/oraclec6 (Updated later - actually, maybe this doesn't work for unregistered attendees yet)3) Search for sessions4) Click link in right hand column where the presentation exists5) You might\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1669,"url":"http:\/\/orcldoug.com\/blog\/2012\/01\/10\/ukoug-2011-ash-outliers\/","url_meta":{"origin":1066,"position":4},"title":"UKOUG 2011 – Ash Outliers","date":"January 10, 2012","format":false,"excerpt":"My final UKOUG 2011 post is about another of my favourite presentations -\u00a0 \"ASH Outliers: Detecting Unusual Events in Active Session History\" by John Beresniewicz. (JB for short, but Marco Gralike made a fairly good stab at pronouncing his surname correctly during the introduction.)I'd been looking forward to this presentation\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":884,"url":"http:\/\/orcldoug.com\/blog\/2006\/01\/12\/something-else-i-didnt-know\/","url_meta":{"origin":1066,"position":5},"title":"Something Else I Didn’t Know","date":"January 12, 2006","format":false,"excerpt":"This one is courtesy of Andrew Campbell at Sun Microsystems. He noticed in an Oracle Magazine article that you can use a URL as a script name in sqlplus.SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL\/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for 32-bit Windows:\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1066"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1066\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1066"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}