tag:blogger.com,1999:blog-7322534696749683232Mon, 07 Oct 2024 03:13:19 +0000Oracle TipsOra ErrorOracle Tuningoraclewhite paperData RecoveryOracle TrickOracle Installationdata storageOrace RACOracle PL/SQLSQL Tuningdata managementoracle 11goracle : product reviewData Recovery TechniquesOracle NewsOracle PL/SQL ProgrammingOracle Tutorialoracle 10goracle adminoracle grid computingData Recover Physical DamageHardwareInternetLinux: InstallationOra: ErrorOracle ArchitectureOracle RACOracle Security AlertsPL/SQLPerformanceStoragedatabasemysqlmysql:phporacle DBAoracle WebcasttoolADOAbout My SelfApplication DevelopersArchivingBackupsBusiness IntelligenceCDIData BackupData LossData Loss PreventionData Loss ProtectData Recovery BasicData Recovery OfflineData Recovery OnlineData Recovery ServicesData Recovery SolutionsData Recovery ToolsData RetentionEnterprise SoftwareError on installationFirst..LastHow ToImportant DataImportant Data LoseIndexInformaticaMicrosoft Virtual ServerORA-02243ORA-06052ORA-06512ORA-06530: Reference to uninitialized compositeORA-12154ORA-12514ORA-28547Orace + VMWareOracle 11g R2Oracle 9iOracle ASMOracle BIOracle BankupOracle Change TrackingOracle Client VersionOracle Critical Patch UpdateOracle Explain PlanOracle ListenerOracle PatchOracle RAC VIPOracle RMANOracle RMAN Setup TutorialOracle SQL OptimizationOracle UtilityOracle collectionOracle correctionOracle on WindowsOracle on Windows Server 2008PL/SQL Best PracticesPhysical DamageProxyRACRiverbed Technology Inc.SQLSQL performanceSUSE migrationSecurityServer VirtualizationServersSoftwareSolaris InstallationStrategyTNS could not resolve the connect identifier specifiedTNS operation timed outTNS-12535Virtual DesktopVirtual ServerVirtualizationWindows 32 bit memory limitationYoutubeadminadministrationadvance serverbuildercheck if oracle server behind firewareclientcross-databasecustomer data integrationdata integration implementationdatabase tooldatabase utilitydbdb tooldba admindevelopmentdynatuneeditorexportexportingfor in PL/SQLfor in plsqlfor loop in pl/sqlimportimportinginterfacemanagementmyadminoracle fusion middlewareoracle migrationpostgress plusqueryreportshared poolsqlloaderstoredtableupgrade oracleutilityDatabase Administrator Tips & Tricks applying with every version of Oracle (i.e. Oracle 8i/9i/10g/11g) including PL/SQL, Trigger, Store Procedure. Also provide how to install Oracle on Linux platform and MS Windows platform and Oracle Error and The Solution to solve themhttp://dba-tip-trick.blogspot.com/noreply@blogger.com (Unknown)Blogger136125tag:blogger.com,1999:blog-7322534696749683232.post-4720125494140161020Thu, 09 Apr 2015 03:22:00 +00002015-04-08T20:22:54.153-07:00Oracle TuningSQL Tuning When we are working with multiple applications on Oracle, there might be a need to link those applications together. One of the way to integrate them is though bank end DB Link.  There is one technique I would like to introduce to help on the DBLink performance. This little tuning tip will help a lot when you join the tables from both side of the DBLink.  When we join 2 or more http://dba-tip-trick.blogspot.com/2015/04/oracle-tuning-for-linking-local-table.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-7322534696749683232.post-7552516923546797022Wed, 19 Feb 2014 06:53:00 +00002014-02-18T22:53:19.641-08:00ORA-02243Oracle TuningSQL Tuning There is pro and con for having indexes on the table. The pro is when you use select statement indexes will help boost up the query. However, when you do DML statement (insert, update, delete) you might run into performance issue. The work around of this when you need to insert a lot of data is just don’t use the indexes when you do the insertion. In other words, disable the http://dba-tip-trick.blogspot.com/2014/02/disable-table-indexes-to-boost-up.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-8501796957373857563Tue, 20 Aug 2013 17:40:00 +00002013-08-20T10:40:39.560-07:00Oracle TuningOracle TutorialPerformanceSQL TuningThis is a good Oracle Performance Tuning video I have came across on youtube. This is a good video for both Developer and DBA. The presenter gave a very good and clear explanation. This is one of the Oracle tutorial series from the same presenter. There were 2 different type of tuning that were discussed in this video System Tuning and SQL Tuning. Roughly, System Tuning involves the appropriate http://dba-tip-trick.blogspot.com/2013/08/how-to-boot-up-your-oracle-performance.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-4210284692281978801Tue, 20 Aug 2013 11:56:00 +00002013-08-20T04:56:31.869-07:00Oracle PL/SQL ProgrammingOracle TutorialPL/SQL I came a cross one video on PL/SQL tutorial, and it is a good one. This video give us picture of what oracle PL/SQL is with the very clear and simple presentation. This is a very recommended video for PL/SQL newbie. What were talked on the video were: Why PL SQL? Types of PL/SQL Code Data types - Variables Statements control flow Cursors Exception handling http://dba-tip-trick.blogspot.com/2013/08/oracle-tutorial-plsql-basics.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-2759755094556301985Sat, 17 Aug 2013 20:34:00 +00002013-08-20T11:03:51.224-07:00Oracle Explain PlanOracle TrickYoutubeI came across this basic Oracle Explain Plan fundamental tutorial on Youtube. The explain plan is the  basic knowledge that the developers and DBAs may consider getting to understand. The presenter in this video tutorial gave the theory and then went through the explain plan demonstration. What were presented in this tutorial were: Understand of Basic Explain Plan. How to setup Oracle http://dba-tip-trick.blogspot.com/2013/08/oracle-explain-plan-fundamentals.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-3198385084443962985Tue, 06 Aug 2013 11:12:00 +00002013-08-06T04:12:54.458-07:00Ora Error   When you encounter an oracle error ORA-28001: the password has expired and you do not have sysdba priviledge, here is how to handle it. What you need is sqlplus, which is located in ORACLE_HOME/bin. The step to resolve this are: 1. Login to you account by using sqlplus in command prompt     c:\sqlplus or $sqlplus 2. Enter your user and the service     Enterhttp://dba-tip-trick.blogspot.com/2013/08/ora-28001-password-has-expired.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-550177454288258758Wed, 31 Jul 2013 08:21:00 +00002013-08-20T06:01:12.639-07:00Oracle Client VersionOracle TipsOracle TrickThe easy way to check the installed oracle client version in windows operating system: The first way to check  is checking from sqlplus binary. 1. Run sqlplus in command line, and leave it prompting for user name as shown below 2. Check oracle version from windows task manager: If the process shows "sqlplus.exe*32" as in the picture then it's the 32bit version client. If it shows "http://dba-tip-trick.blogspot.com/2013/07/how-to-check-if-your-installed-oracle.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-8554528589143198057Tue, 14 May 2013 21:14:00 +00002013-08-20T11:11:08.742-07:00Oracle TipsOracle Tuningshared poolThe Oracle shared pool provides critical services for sharing of complex objects among large numbers of users. Prior to 10g R1, DBAs often spent much time learning about the shared pool memory management to configure and tune shared pool usage; with the tight time constraints and ever-changing workloads, many found this task daunting. The Automatic Shared Memory Management (ASMM) features http://dba-tip-trick.blogspot.com/2013/05/understanding-shared-pool-memory.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-2925660193206316627Thu, 28 Feb 2013 20:13:00 +00002013-02-28T12:16:13.580-08:00Ora ErrorORA-06530: Reference to uninitialized compositeOracle correctionPL/SQLORA-06530: Reference to uninitialized composite ORA-06512: at "PROCEDURE/PACKAGE", line 88 ORA-06512: at "PROCEDURE/PACKAGE", line 446 ORA-06512: at line 11 06530. 00000 -  "Reference to uninitialized composite" *Cause:    An object, LOB, or other composite was referenced as a            left hand side without having been http://dba-tip-trick.blogspot.com/2013/02/ora-06530-reference-to-uninitialized.htmlnoreply@blogger.com (Unknown)1tag:blogger.com,1999:blog-7322534696749683232.post-5909876404731928114Thu, 28 Feb 2013 19:24:00 +00002013-02-28T11:24:10.809-08:00First..LastOra ErrorORA-06052Oracle collectionCause: The error ORA-06052: PL/SQL: numeric or value error would be found when using for loop on the type collection object, as shown below, and the collection is empty: FOR i IN type_variable.FIRST..t_variable.LAST LOOP      ----your code End Loop ; When the collection is not empty, error ORA-06052: PL/SQL: numeric or value error would not be found. This is because FIRST and http://dba-tip-trick.blogspot.com/2013/02/ora-06052-plsql-numeric-or-value-error.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-104704686617886622Thu, 24 Jan 2013 12:31:00 +00002013-05-14T14:22:03.713-07:00Oracle TipsSUSE migration If you are thinking of migrating your SUSE to Oracle Linux, there are things to think of and things to be prepared before you do it. The preinstallation process and pro installation process need to be prepared. Below is the link to get information on the migration. Please read it before you do it. http://www.oracle.com/technetwork/articles/servers-storage-admin/dell-linux-1498654.htmlhttp://dba-tip-trick.blogspot.com/2013/01/migrate-suse-linux-to-oracle-linux.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-7918180544511324125Tue, 16 Oct 2012 04:28:00 +00002012-10-15T21:29:42.886-07:00oracle 11gOracle 11g R2upgrade oracleIf you are using Oracle 9i, 10g, and decide to move forward to use 11g, below are what will you get form the 11g R2 upgrade:- Oracle Database 11g Release 2, the latest release of the award-winning Oracle Database 11g, enables IT professionals to deliver more information with higher quality of service, make more-efficient use of their budgets, and reduce the risk of change in datacenters. By http://dba-tip-trick.blogspot.com/2012/10/the-reason-to-upgrade-to-oracle-11g.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-209525621161711802Fri, 14 Sep 2012 09:31:00 +00002013-08-15T01:07:15.461-07:00IndexSQL performance Having a lot of indexes on your table will affect the performance of your table either bad side or good side. It depends on what operation you use most.         Index will help fasten your query, and at the same time might slow your query down. When you do a lot of insertion, update, deletion based on the index columns, this will slow the query down. On the http://dba-tip-trick.blogspot.com/2012/09/how-many-database-indexes-is-too-many.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-3741346442200535617Mon, 16 Apr 2012 23:36:00 +00002012-04-16T16:36:31.854-07:00Ora ErrorORA-06512ORA-06512: at stringline string Cause: Backtrace message as the stack is unwound by unhandled exceptions. Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA. PostingPosting http://dba-tip-trick.blogspot.com/2008/05/ora-06512-at-line.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-7394922954767776027Fri, 25 Nov 2011 13:16:00 +00002011-12-20T15:40:06.602-08:00for in PL/SQLfor in plsqlfor loop in pl/sqlOracle PL/SQLOne of the statement  in oracle I use most is for loop in pl/sql. This for loop is very handy to use and the basic statement comes like this: for variable in 1..x  loop    statement; end loop; The reverse loop statement is: for variable in reverse 1..x  loop    statement; end loop; The example code comes like this for v_cnt in 1 .. 100  http://dba-tip-trick.blogspot.com/2011/11/for-loop-in-plsql.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-5027212814295855370Tue, 12 Apr 2011 20:57:00 +00002011-11-28T21:53:20.113-08:00Oracle PL/SQLOracle PL/SQL ProgrammingPL/SQL Best PracticesPL/SQL Best Practices with Steven Feuerstein Renowned Oracle PL/SQL expert, Steven Feuerstein, presents "PL/SQL Best Practices" -- offering high-level principles to guide our work. Here are some example of the PL/SQL best practices derived from PL_SQL_Best_Practices2.pdf: DEV-01: Set Standards and Guidelines for Your Application Before Anyone Starts Writing DEV-02: Ask for Help if you http://dba-tip-trick.blogspot.com/2011/04/plsql-best-practices.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-7308868188687295707Tue, 12 Apr 2011 20:51:00 +00002011-04-12T13:51:53.475-07:00Oracle ArchitectureOracle Change Trackingoracle Webcast It has often been said that the only constant is change. IT's ability to manage change is an important business success criteria in today's competitive markets. Change can either be planned or unplanned. This presentation will help you understand the effects of change, and how to manage change properly. It will help database administrators better prepare to implement changes and measure the http://dba-tip-trick.blogspot.com/2011/04/database-change-tracking-for-oracle.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-2430558929197952086Tue, 12 Apr 2011 20:49:00 +00002011-04-12T13:49:37.710-07:00Oracle SQL OptimizationSQL TuningQuest® SQL Optimizer for Oracle proactively identifies potential performance issues and automates SQL optimization by scanning and analyzing running SQL statements, PL/SQL, or other source code. * The value of SQL tuning to you and your organization * What the ideal solution looks like * How to use the key functions and new features in Quest SQL Optimizer for Oracle v7.2 http://dba-tip-trick.blogspot.com/2011/04/automating-sql-optimization.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-5411117397476318682Tue, 12 Apr 2011 20:27:00 +00002011-04-12T13:27:30.523-07:00Oracle PL/SQLOracle PL/SQL Programmingoracle WebcastI just came a cross this video about oracle pl/sql programming, which provide good technique to write pl/sql code. Very good video to take a look for pl/sql programmer. You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to skip over unnecessary lines of code? If slip-ups like these sound familiar (or if you don't know why these are http://dba-tip-trick.blogspot.com/2011/04/common-mistakes-in-oracle-plsql.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-2348729388306242389Tue, 22 Mar 2011 21:43:00 +00002011-03-22T14:43:35.721-07:00Ora ErrorORA-12514Oracle ListenerCause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has http://dba-tip-trick.blogspot.com/2011/03/ora-12514-tnslistener-does-not.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-6908278356462581031Tue, 22 Mar 2011 21:26:00 +00002011-03-22T14:26:51.220-07:00Ora ErrorORA-12154TNS could not resolve the connect identifier specifiedCause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could http://dba-tip-trick.blogspot.com/2011/03/ora-12154-tnscould-not-resolve-connect.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-2001198506103806847Fri, 12 Nov 2010 07:52:00 +00002010-11-11T23:52:51.282-08:00sqlloaderWhen loading text file into db via sqlloader, there might be the case that varchar2 column with Thai character data turn out weird (i.e. instead of showing "รถยนต์นั่งไม่เกิน 7 คน" it turn out to be "เธžเธฃเธš เธฃเธ–เธขเธ™เธ•เนŒเธ™เธฑเนˆเธ‡เน„เธกเนˆเน€เธเธดเธ™ 7 เธ„เธ™"). The cause of this problem, from what I experienced, is that the format/encoding of text file is invalid. To solve this youhttp://dba-tip-trick.blogspot.com/2010/11/sqlloader-with-text-file-format.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-1738614206296163928Thu, 28 Oct 2010 10:26:00 +00002010-10-28T03:26:25.962-07:00Oracle TipsThere might be the case that you find it difficult to recreate the table with another table having foreign keys dependent on it. When you need to recreate the table that mean you need to drop that table first. Apart form losing data and other objects related to that table you will also lost foreign key constraint on every tables which referring to it. There is a little tip top help you get all http://dba-tip-trick.blogspot.com/2010/10/save-your-foreign-key-constraint-before.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-5805622645143629375Sun, 22 Aug 2010 18:14:00 +00002013-02-28T12:19:27.438-08:00Error on installationLinux: InstallationOracle InstallationSolaris InstallationWhen trying to add oracle user on unix or linux there might be the case that you get the following error: solaris UX: useradd: ERROR: Inconsistent password files. See pwconv(1M). Here are steps to fix this problem, and what causes this error. The reason behind this error is that the /etc/passwd and /etc/shadow files are out of synchronization on your machine. To fix this, run the following http://dba-tip-trick.blogspot.com/2010/08/solaris-ux-useradd-error-inconsistent.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-7322534696749683232.post-3810198417327528000Thu, 05 Nov 2009 21:06:00 +00002009-11-05T13:10:33.061-08:00Orace RACoracle 10gOracle TutorialRACOracle Real Application ClusterThe video talk about Oracle RAC architecture there are 2 parts of it.Video IVideo IIhttp://dba-tip-trick.blogspot.com/2009/11/oracle-rac-10g.htmlnoreply@blogger.com (Unknown)0