=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tip September 12, 2001 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Welcome to the searchDatabase.com Database Administrator Tips newsletter! Today's tip, "Is your database accessible?" can also be viewed online at: http://www.searchDatabase.com/tip/1,289483,sid13_gci769447,00.html Help your fellow database geeks and perhaps win a Toshiba DVD player! Submit your own technical tip here: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz764692_cts764388,00.html ******** Sponsored by SyncSort *********** **Mine Web Data Fast!-FREE Flashlight-FREE Trial** An active web site can easily generate a billion web records a day. How can you mine all that information fast to better understand customer behavior and increase profits? Web data mining pioneers like Microsoft are using SyncSort, a lightning-fast data manipulation product, to sort, select, reformat, clean, standardize and aggregate web data. For a FREE product trial, and a FREE flashlight to remind you that SyncSort can shine a light on buried nuggets of information fast, click here: http://www.syncsort.com/tgb910 ************************************************* "Is your database accessible?" By Kirtikumar Deshpande As a DBA, there will be situations when you would like to know if a particular Oracle database is up and running, and if it is accessible to end users. Most solutions involve checking for the presence of a background process such as PMON or SMON (or in older versions, the file sgadef.dbf). However, these solutions do not tell the DBA if the database is accessible or not. The following simple code does two things. It positively verifies that the listener process is working properly and the database is accessible by trying to connect to it. You do not need to set up any special user account to try to make a connection! Here's the code: #!/usr/bin/ksh # # dbcheck : Script to check if datbase is up # and accessible #----------------------------------------------- echo "Enter Name of the Database SID to check if it is accessible" read DB # Let us try to connect to the DB using a # dummy userid/password. sqlplus -s << EOF > /tmp/$$.1 whenever sqlerror exit aaa/aaa@$DB exit; EOF ## Please be sure EOF start in column 1 egrep 'ORA-121|ORA-01034' /tmp/$$.1 > /dev/null if [[ $? = 0 ]] then echo "-----> '$DB' is _NOT_ Accessiblen" else grep 'ORA-01017' /tmp/$$.1 > /dev/null if [[ $? = 0 ]] then echo "-----> '$DB' is UP and Accessiblen" else echo "-----> '$DB' is _NOT_ Accessiblen" fi fi rm /tmp/$$.1 # --- End of File FOR MORE INFORMATION: The Best Oracle Web Links: tips, tutorials, and more http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax282873,00.html Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums: http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html Help your peers: Submit your own tip and win a Toshiba DVD player! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html ================================================ SPONSORED BY: **Storage Decisions 2001** ================================================ TIME IS RUNNING OUT to qualify to attend the FREE Storage Decisions 2001 conference in Chicago September 26-28. Learn to set strategy/make the smartest decisions to most effectively manage your storage initiatives for 2002. Pre-qualified audience of your peers and NO vendor sales pitches. Don't get shut out at this critical event. Visit: http://ad.doubleclick.net/clk;3230220;5058249;w?http://www.StorageDecisions2001.com ======================================= MORE GREAT STUFF ON SEARCHDATABASE! ======================================= This week's Featured Topic: Whither Informix? Although IBM's acquisition of Informix is now a month old, questions remain. Will IBM really continue to support Informix products? How will the development of DB2 be affected? Why did IBM buy Informix anyway? Click the link below for more... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci768593,00.html Did you miss Bill Inmon's excellent presentation about the "Top ten data warehousing success factors"? Check out this archived version, complete with audio and PowerPoint presentation: http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci760304,00.html WIN A TOSHIBA DVD PLAYER: Share your knowledge, help your peers, and compete to win a $200 DVD player. Submit your technical tip today: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz764692_cts764388,00.html Sonal and Sonix are still waiting for your help! Check out the "DBA Water Cooler" for their questions about Oracle drivers and storing BLOBs: http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html Over 200 DBA, developer, Oracle, DB2, and SQL Server tips FREE to searchDatabase members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html NEW: Hundreds of hand-picked and reviewed resources about every aspect of data warehousing and business intelligence, including ETL, data quality, ROI, OLAP, star schemas, and much more: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281567,00.html Ask the Expert category of the day: "SQL" http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_cid376817_tax285649,00.html SQL guru extraordinaire Rudy Limeback is waiting to tackle your toughest SQL scripting problems. ======================================= LEARNING ZONE FEATURED BOOK OF THE WEEK ======================================= "Oracle 9i SQLJ Programming" By Nirva Morisseau-Leroy Take advantage of greater programming capabilities with SQLJ--a standard language specification that embeds SQL statements in Java--in the Oracle 9i environment. Officially authorized by Oracle Corporation, this authoritative resource explains how to develop hosted applications, achieve remarkable scalability, implement real-time business intelligence features, and reach a new level of programming functionality. Get comprehensive coverage of SQLJ programming techniques, including SQL programming and development, SQLJ stored programs, triggers, and object-relational processing. Oracle9i SQLJ Programming will help you control each piece of the development process. Discover the benefits of Oracle's highly developed SQL-embedded Java programming standard. http://www.digitalguru.com/product_detail.asp?catalog_name=Books&category_name=&product_id=0072190930&partner_id=77 ================================================ If you would like to sponsor this or any TechTarget newsletter, please contact Gabrielle DeRussy at [EMAIL PROTECTED] ================================================ If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.