Monday, 17 February 2014

SOME INTERVIEW QUESTIONS





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


http://img1.blogblog.com/img/icon18_wrench_allbkg.png




1)    How to check privileges granted on a particular table?


2)    How to check permissions given to a particular user?


3)    How to Resize a datafile?


4)    How to see the Installed product details of Oracle Database?


5)    Find out the tables that are ANALYZED in the Database?


6)    Show all Active Users in the System?


7)    How to identify what a current user is doing?


8)    How will I find the Count of Tables available in the Database?


9)    How will we see the available ALL INDEXES in a database?


10)Show ALL TABLES available in a database?


11)Identify the Space Used by Tablespace?


12)Identify the Space Used by Users/Schema in a database? 


13)How to find the OS Version, Database Version in Unix and Windows?


 


14)Identify the Reads and Writes of Datafiles in a Database?


15)Identify the SEGMENTS that are getting CLOSE TO MAX_EXTENT values?


16)Identify the SEGMENTS that are getting CLOSE TO RUNNING CONTIGUOUS FREE SPACE?


17)How will we display Archived Log Information? v$archive_dest


18)How to see the HISTORICAL ARCHIVED LOG information from a Control File? v$archived_log


19)How to find current archived log destinations? Archive log list


20)I want to know the details of BACKUP’s of ARCHIVED LOG files?


21)How to check the ALL ONLINE REDO LOG GROUPS and MEMBERS in a database?


V$log-CURRENT STATUS, v$logfile-group&member details,V$log_history-history of logs


22)Show ALL DATAFILES of a TABLESPACE? V$datafile –ts#=v$tablespace-ts# or dba_data_files


23)How to find SCHEMA / USER SIZE in a database? Dba_segments


24)What is the Size of QOUTA allocated for a particular user/schema? Dba_ts_quotas


25)How to find TABLESPACE Usage in %, Blocks Used and Blocks Empty?


Usage%:- sum(sys.seg$.blocks)*sys.ts$.blocksize*count(distinct(sys.file$.file#))*100


Total Available:- sum(sys.file$.blocks)*t.blocksize


Total Used:- sum(sys.seg$.blocks)*sys.ts$.blocksize


Total Space Remaining:- Total Available in sys.file$.blocks minus total used in sys.seg$


26)Display all tables in current schema along with TABLESPACE and TABLE SIZE in GB?


27)How to find ROWS spread across different TABLESPACES and DATAFILES? How many rows are there in each DATAFILE for EACH TABLE?


28)How to Recover Data after the loss of Redo Log Files in Archive mode & NoArchiveLog mode?


29)How to Recovering After the Loss of All Members of an Online Redo Log Group?


30)How to recover table from DROP/DELETE/TRUNCATE commands in Oracle Database?


Flashback table rman.rman_table to before drop;


Flashback table rman.rman_table to timestamp (systimestamp –interval ‘05’ minute);


31)How to recover database when ALL DATAFILES lost in User Managed Databases?


32)How to recover DATAFILE when there is no Backup available?


33)How to Restore and Recover database to a NEW HOST using RMAN?


34)How to SKIP a Tablespace for Restore Operation in RMAN?


35)Explain about Restore and Recover database in NOARCHIVELOG Mode?


36)Explain Restore and Recovery of INDIVIDUAL TABLESPACES / DATAFILES?


37)How to Restore SPFILE from a recent Backup?


38)How to Restore an SPFILE from Older backup more than 7 days / upto specific days?


39)Explain about Restore POINT and FLASHBACK DATABASE?


40) Write a script to TRACK SPACE UTILIZATION of your Database over time?


41)Cold backup procedure and Hot Backup Procedure explanation?


42)How to check ALERT LOG in oracle 11g?


43)What will happen if Oracle unable to write ALERT LOG, CORE DUMP OR TRACE FILES?


44)Stop ALERT NOTIFICATION for a specified period of time as when you plan to bring downtime for the database?


45)What is Server-Generated Alerts like Threshold Alerts, Event Based Alerts?


46) How to view and change Threshold Settings for Threshold Alerts?


47)How to notify or send email Event in oracle from EM?


48)What are the mandatory Variables to be declared for LOG_ARCHIVE_FORMAT?




50)Enable Archive Log Mode for RAC Database?


51)Solution for ORA-000257: Archive Error. Connect Internal Only, Until Freed?














58)RMAN-03002, RMAN-06059, ORA-19625 and ORA-27037 during RMAN archivelog backup. The problem happened because Oracle archivelog files were deleted at OS level.






61)I mounted remote location jupiter:/export/home/oracle on my local server as /export/home/oracle/remote and then I wanted to take RMAN backup on the mapped drive but it fails with ORA-19504: and ORA-27054.


62)How to take RMAN backup on a Remote Location?


63)How to extract data from a CORRUPT table?


64)WHERE Clause Fails with ORA-01578(Data block corrupted). This problem is caused due to a corrupted block in one or more blocks belonging to an index type of segment. Since the corrupted block does not belong to the table, some statements could be executed successfully if the information is retrieved via full tablescan.


65)How to handle Block Corruptions in ORACLE and How to Recover Data from Corrupted Blocks.


66)What is the solution for Solution of ORA-600 [4194] or ORA-600 [4193]. The problem ORA-600[4194] or ORA-600[4193] occurs when there is mismatch detected between Redo records and rollback (Undo) records.




68)Oracle data pump import fails with ORA-39002 and ORA-39322 during importing transport tablespaces?












74)ORA-07445: exception encountered: core dump [nstimexp()+28] [SIGSEGV] [ADDR:0x58] [PC:0x107D6071C] [Address not mapped to object] []


75)ORA-07445: exception encountered: core dump [osnsgl()+625] [SIGSEGV] [Invalid permissions for mapped object] [0x000000068] [] []






78)Database Crash With ORA-07445 [_ndoprnt()+4]. Sorry, no swap space to grow stack for pid 6048 (oracle)










83)Drop user hangs or it returns ORA-01940. SESSION HANGS WHEN TRYING TO DROP A USER


84)Drop user cascade takes more than 1 day. Dropping a simple user takes hour after hours and after 1 day it is not completed yet






87)ORA-00054, ORA-04022 while gathering table statistics. The following errors are reprted when executing DBMS_STATS procedures simultaneously in order to collect database tables statistics.


88)ORA-13503: Creating SYSAUX tablespace with invalid attributes. While creating SYSAUX tablespace manually it fails with error ORA-13503.


89)What is an Oracle database instance?  Also, showing the steps in creating an Oracle instance?


90)What is OEM (including showing some of its contents)?  Also explain its advantages.


91)What is OFA?  Also, what is the reason and purpose of adopting OFA?


92)What are the usages of the control and redo log files?  What kind of relationship exists between these two types of file.


93)Based on the logic structure (table, segment, extent, & data block) discussed in the textbook, explain how can a database table (e.g. CUSTOMER table which stores all customer data) be split and stored within the logic structure.


94)When creating an Oracle database table, the storage settings are optional, why?


95)What is the advantage and reasoning to include storage settings when creating a new database table?


96)What is a “role”?  What are the advantages of creating and using roles?






99)What to do when we found in trace fil WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!.


100)              Name the different types of Constraints


101)  What are the DDL statements?


102)  What are the Transaction Control (TC) statements?


103)  What are the Session Control statements?


104)  What are the System Control statements?




106)  While connecting to oracle database it fails with ORA-12532: TNS:invalid argument like below.


107)  It is used LDAP, sqlnet.ora entry is NAMES.DIRECTORY_PATH = (LDAP) and Tnsping fails with TNS-03505: Failed to resolve name or TNS-12154 / ORA-12154: TNS:could not resolve service name.




109)  ORA-28547 connection to server failed, probable Net8 admin Error


110)  ORA-12154: TNS:could not resolve the connect identifier specified














117)  ORA-00205: error in identifying control file. Whenever you try to start your oracle database instance or mount your database it fails with ORA-00205 error message


118)  ORA-00600: internal error code, arguments: [2141]. While starting up or shutting down the database it fails with oracle error message ORA-00600


119)  ORA-01665: control file is not a standby control file. While recovering standby database, using command alter database recover managed standby database disconnect from session it fails with message ORA-01665


120)  Recover database after only lose of all controlfiles. You have lost all your current and backup of controlfile. You have avaiable your current data files. You have available your online redo log files.


121)  MAXDATAFILES , DB_FILES parameters and ORA-00059. Whenever I try to create tablespace it fails with error message, ORA-00059


122)  ORA-01667: cannot add any more tablespaces: limit of exceeded. If your database version is higher than 8 suppose 10.2g then when MAXDATAFILES of your control file reached then MAXDATAFILES parameter would expand automatically unless you hit bug. You can see the post here,
New Feature of 10.2g Eliminate Control file Recreation
However if you are before 8 then while creating any tablespace and while adding a datafile to a tablespace you may get ORA-01667: cannot add any more tablespaces: limit of exceeded




124)  Both Data files and Online Redo logs are in tact


125)  Data files are intact but Online Redo logs are lost


126)  Data files are lost but online redo logs are available


127)  Both Data files and redo logs file are lost


128)  File size is not a multiple of logical block size ORA-00202,ORA-27046.  Whenever you tried to start the database the database failed to mount


129)  How to Restore the Controlfile from Backup. If you loss or if your all copies of control file is corrupted and if you have backup of your control file then it is required to restore your control file from your backup


130)  New Feature of 10.2g: Eliminate Control File Re-Creation. Before Oracle 10.2g if we need to change the limit of MAXLOGFILE, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES then the possible solutions is either RE-create new controlfile or create a new database. But from Oracle 10.2g all sections of the control file are now automatically extended when they run out of space. This means that there is no longer a requirement to re-create the control file when changes in the configuration parameter the MAXLOGFILE, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES are needed


131)  kccrsz: denied expansion of controlfile section 9 by 65535 record(s). The machine did not respond properly and in the alert log you the got the following. kccrsz: denied expansion of controlfile section 9 by 65535 record(s) the number of records is already at maximum value (65535).


132)  ORA-01450: maximum key length (3215) exceeded. Whenever I try to rebuild index online then it fails with message ORA-00604: error occurred at recursive SQL level 1 along with ORA-01450: maximum key length (3215) exceeded.


133)  How to determine OS block size for windows or unix. In many times you probably have heard about set the oracle db block size as a multiple of the OS block size. But whenever you ask how I can determine or find OS block size for windows or Unix then many one get stopped. In fact this question is OS related.


134)  Overview of Extents and when extents are allocated, When Extents are de-allocated.


135)  Playing with Oracle data block size. I have experiment of oracle data block size with 8k and 16K. I performed DML operation against both 8k and 16k data block size. I created two tables table_8k under 8k tablespace tbs_8k and table_16k under 16k tablespace tbs_16k. The summary of the experiment is bigger data block cause more time while update but less time while insert operation.






138)  DB_BLOCK_SIZE, DB_nK_CACHE_SIZE and BLOCKSIZE. First I want to say about BLOCKSIZE cluase in oracle. The BLOCKSIZE cluase is used to specify the block size for the tablespace. If you don't specify this clause while tablespace creation then standard that is default blocksize is used which is specified by parameter DB_BLOCK_SIZE.


139)  When datafile bytes size greater than maxbytes. From dba_data_files we can check the size of the datafile, the maximum size of the datafile it can grows if AUTOEXTENSIBLE option is set and their status with many other fields.




141)  ORA-01295: DB_ID mismatch between dictionary USE_ONLINE_CATALOG and logfiles. While doing remote mining in the mining database through logminer START_LOGMNR procedure fails with ORA-01295. May be you want to analysis redo log files of the production database in the testing environment.












147)  Archiving not possible: No primary destinations. Today I got a very interesting problem. The developer told me that they can't connect to database. It says ORA-00257: archiver error. Then I log on to the database and it was ok. I asked developer it is fine. After some time developers again asked me they are having the same problem. I then look for alert log and saw the following stack of message.




149)  Table, View, Tablespace Creation Script in Oracle, In order to get definitions of view, table ,tablespace etc we can use GET_DDL function of DBMS_METADATA package.






152)  Causes and Solution of ORA-00376: ORA-01110:, Whenever I try to access a objects it fails with errors.


153)  Troubleshooting ORA-00942: ORA-04043: ORA-00942: table or view does not exist, ORA-04043: object %s does not exist










158)  Error ORA-01555 on Active Data Guard Standby Database We have active data guard setup in our 11.2.0.1 version of Oracle database. It is upgraded to version 11.2.0.2 and now we see this ORA-1555 on the Standby Database. We can't logon to database with system, dbsnmp or other database users. Only sys as sysdba is working. Also we have investigated that we are running on system's undo Tablespace, - and not the one which has been created for undo.










163)  Primary DB freezed with waited too long for a row cache enqueue lock. On Oracle database 10.2.0.3.0 Data Guard with Broker configuration whenever there is an attempting to restart the standby in read only


164)  While startup standby database it fails with ORA-01154. Whenever you try to open or shutdown a standby database it fails with error ORA-01154


165)  ORA-01665: control file is not a standby control file. While recovering standby database, using command alter database recover managed standby database disconnect from session it fails with message ORA-01665: control file is not a standby control file like below.




















175)  impdp fails with ORA-39174 or ORA-39176. You have transparent data encryption feature enabled in your database. You took your dump with expdp utility with the ENCRYPTION_PASSWORD parameter. Now whenever you try to import your dump without ENCRYPTION_PASSWORD parameter you will get ORA-39174 error.


176)  How to export table containing encrypted columns. Let's first check whether database has any encrypted columns or not by querying dba_encrypted_columns view


177)  EXP-00107: Feature (COLUMN ENCRYPTION) of column is not supported. While exporting encrypted table using oracle export utility it fails with EXP-00107 error and encrypted table is not exported.


178)  ORA-39097, ORA-39065, ORA-31643, ORA-19510, ORA-27045 Linux-x86_64 Error: 5. Oracle data pump export operation on 10.2.0.4 database into CIFS file system fails with error ORA-39097, ORA-39065, ORA-31643, ORA-19510, ORA-27045 Linux-x86_64 Error: 5.


179)  ORA-39029, ORA-31671, ORA-39078 received during Oracle Parallel data pump Import. Oracle data pump import operation is working fine without PARALLEL parameter. But whenever we specify PARALLEL parameter within the import statement it fails with this error.


180)  Data pump fails with ORA-31626: job does not exist. Data pump export jobs failed with following errors:


181)  ORA-31626 ORA-31650 while using Oracle DataPump export in RAC database. ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response


















190)  EM Daemon is not running. On windows whenever I try to start my dbconsole in one time during process it shows me message EM Daemon is not running.


191)  Authentication failed!null. After upgrading the database containing dbconsole's repository whenever you try to logon to Enterprise Manager or DBCONSOLE it succeed but return with error


192)  How to Change DB Control Http Port




194)  An Stack of Problems while creating Repository using emca. In my database I tried to create repository and stopped several times while creating repository. I spend a significant amount of time to create repository and after analysis I got the following


195)  Running EMCA Fails To Accept the DBSNMP Password. Today when I tried to create DB Control on my computer I got an interesting problem.








199)  Java.lang.Exception: IOException in sending Request. this problem will appear if you just change the Time Zone of your system.


200)  You must have CREATE TARGET privilege to perform this operation. In the Enterprise Manager main page (connected with SYS as SYSDBA or as SYSTEM), when I click on performance tab, it gives me following notification




202)  In EM connection fails with ERROR: NMO not setuid-root (Unix-only). This problem is notified on Unix system only.
Whenever you try to connect to enterprise manager after giving host username and password as prompted it fails with message
HostPassword - Connection to host as user oracle failed: ERROR: NMO not setuid-root (Unix-only)




204)  Does oversize of datatype VARCHAR2 causes performance problem. From the beginning of learning Oracle SQL you have possibly heard that in case of VARCHAR2 datatype it allocates space exactly what it needs. So if you allocates 4000 bytes of VARCHAR2 data type and database needs 10 bytes only then exactly 10 bytes are allocated






























219)  Export fails with ORA-24324 ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]. Database export operation fails with ORA-24324 and ORA-07445
























231)  DataPump Export (EXPDP) Client Gets UDE-8 ORA-31626 ORA-39086. Doing Oracle data pump export operation from client side reports error UDE-00008, ORA-31626, ORA-39086 and ORA-06512.


232)  Export fails with ORA-01406: fetched column value was truncated. Exporting oracle 11g database using 10g exp utility fails with ORA-01406 errors


233)  exp fails with EXP-00023 and expdp fails with ORA-31631, ORA-39161, It is needed to export/import full database. To export full database, "EXPORT FULL DATABASE" privilege is granted and to import full database "IMPORT FULL DATABASE" privilege is granted. Now while doing full database export/import, exp fails with EXP-00023 and expdp fails with ORA-31631: privileges are required , ORA-39161: Full database jobs require privileges




235)  Version Query Pseudocolumns, The version query pseudocolumns are only valid for flashback version query which are discussed on Flashback Version Query.


236)  ORA-01466: unable to read data - table definition has changed, Whenever you tried to flashback of a table immediately after creating table and inserting data into it, or you tried to flashback of the table to a time or to a SCN before creating it then flashback table or flashback query fails with error message,


237)  ORA-08189: cannot flashback row movement is not enabled, Whenever I tried to Flashback Table feature of oracle the following error occurs.




239)  Flashback ON fails with ORA-38706 and ORA-38714, Whenever you tried to enable your database flashback feature it failed with errors.


240)  How to get back dropped Tablespace using Flashback Database, It needs to remember that if you drop your tablespace with including datafiles option then it is not possible to get your tablespace back with flashback database. While dropping if you use DROP TABLESPACE INCLUDING CONTENTS option then it is possible to get back tablespace.


241)  How to restore the old data using flashback query, My intention is , I want to get back past data of database after erroneously updated and committed.


242)  Limitation of Flashback Database, The Flashback Database allows you to get back the entire database to a specific point-in-time


243)  Flashback Database To The Right of Open Resetlogs, In some cases, you may need to return the database to a point in time in the parent incarnation, later than the SCN of the OPEN RESETLOGS at which the current incarnation path branched from the old incarnation.


244)  Flashback Database to Undo an OPEN RESETLOGS, Suppose you have opened your database with OPEN RESETLOGS option after performing flashback feature. And after that you have made unwanted changes in your database.


245)  Performing Flashback Database, Before going any production upgrade to database we can make a guaranteed restore point to database and if any wrong then we can get back to the restore point state. Guaranteed restore point always ensure that we can get back data to our restore point creation time.


246)  ORA-00439: feature not enabled: Flashback Database, While trying to enable flashback feature the error comes.


247)  Restore Point and Flashback Database. Flashback database enables us to get back our database to a prior time


248)  How to Enable Flashback Database, To enable flashback database the following operations is needed


249)  Flashback Table and Flashback Drop, The FLASHBACK TABLE statement enables users to get a table to a previous point in time. It provides a fast, online solution to get back a table that has been accidentally modified or deleted by a user or application. It eliminates the DBA to perform more complicated point in time recovery operations.




















259)  CSSCAN fails with ORA-00600, CSS-00152, CSS-00120, While running csscan it fails with error message ORA-600, CSS-00152: failed to enumerate all tables and CSS-00120 as below


260)  CSSCAN fails with error while loading shared libraries: libclntsh.so.10.1, While running csscan in order to check all character data in the database and tests for the effects and problems of changing the character set, it fails with error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file as below








264)  ORA-39014 ORA-39029 ORA-31672 One or more workers have prematurely exited, Whenever you tried to import data into the database it failed with error as below


265)  How to Import data without Dumpfile-Network Mode Import, It is possible to import data in a database without the dump file. From network the data will be retrieved from one database and then import that data back to the target database. There are no dump files involved.


266)  Import Oracle Data from Anywhere, Suppose, I have server machine named "NEPTUNE". In the server machine under /oradata2 directory there is a dump file named net.dmp. However to run import operation we need not connect to server "NEPTUNE" and then perform import operation. From any machine which have data pump import client can do the operation.




268)  Verify Physical Data Structure in Oracle












































290)  How to uninstall Oracle 11g , Uninstall Oracle software 11.2g




292)  How to Identify OS or Oracle 64 bit or 32 bit on Unix










297)  How to discover DBID




















307)  ORA-19566: exceeded limit of 0 corrupt blocks for file, While I am taking a database backup it halt with returning an error,




309)  How to disable SELinux, Before going to directly disabling SELinux let's have an idea about what SELinux is. SELinux indicates Security Enhanced Linux which is a security patch applied to Linux kernel. When it is enabled in the kernel it follows some principle of least privilege. It is an implementation of mandatory access control using Linux Security Modules.






312)  While startup listener it fails with HPUX Error: 29: Illegal seek, While issuing "lsnrctl start" command on HP-UX it fails with HPUX Error: 29: Illegal seek error like below


313)  TNS-01169: The listener has not recognized the password, The TNS-01169 error occurred because security feature is enabled for listener i.e password is set in listener.ora file but lsnrctl command is issued without proper authentication






316)  The listener supports no services, Whenever I issue lsnrctl status command it says "The listener supports no services" and no one from outside could not connect to database through listener


317)  Listener Hangs, Child listener process remains persistence, Some days ago in our database server we got a problem regarding listener issue. Our TNS Listener hangs. Below is the problem symtompts.


318)  ORA-12541: TNS:no listener, For newbie users they found ORA-12541 and search here and there to solve the problem. But it is one word about the error which it says no listener and think next what to do. Never mix this error with another error like ORA-12514: which are different and mutually exclusive.


319)  ORA-12514: TNS:listener does not currently know of service requested in connect descriptor, I will try to show how efficiently we can avoid error ORA-12514. My suggestion is whenever you get this error forget about tnsnames.ora and other stuff related to it. Start fixing problem step by step.


320)  How to Enable Listener Logging and Tracing, I will try to show two different ways to enable logging and tracing of listener.ora file. These logging and tracing helps you to identify the network problems and troubleshooting connection problems in oracle.It also help to identify when a client is connected to oracle database.


321)  RMAN login fails with ORA-12638, RMAN login to the target database fails with the following errors


322)  CONFIG: Error uploading configuration data to the repository while, While configuring dbconsole it fails with error message oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions.












328)  How to Check Your IP Address in Windows and Unix


329)  Who is connected to your windows machine using which port


330)  How to Monitor traffic between nodes, With the command netstat -i we can monitor the traffic in the network nodes. The sample output of netstat -i is below


331)  Types of Operators in Orace? Concatenation, Arthimetic, User-Defined, Hierarchial, Set Operators?








335)  Database Objects in Oracle, If we look for database objects in oracle then there comes two types of objects, one is schema objects that are associated with a particular schema or in other word they are owned by a database user. And the other is nonschema Objects that are not reside in a particular schema


336)  How to Rename a User Through Oracle, There is nothing straight forward command in oracle to rename a user. You have to do it through several steps. In following I have shown it.


337)  Required users and groups while installing oracle, Drop Table Command, Default Tablespace in Oracle




339)  Working an object that resides on multiple datafile, An object can span in multiple datafiles within a single tablespace. In this case if I make one datafile offline then the contents within that datafile will be affected, other datafile is online and can be possible to query which may return rows with errors. To illustarte this scenario I will make two datafiles inside a tablespace.




















349)  RMAN-06172: no autobackup found, While performing disaster recovery I get the error RMAN-06172 as below




351)  OUI-10020: A write lock cannot be obtained






354)  Online Redefinition fails with ORA-23540: Redefinition not defined or initiated, While doing online redefinition on a table dbms_redefinition.copy_table_dependents fails with error ORA-23540










359)  ORA-25153: Temporary Tablespace is Empty, Whenever you try to access temporary tablespace it fails with error ORA-25153. Suppose I want to get the user creation script of user ARJU but it fails with following message


360)  Logminer fails with ORA-01284, ORA-00308, ORA-27047, Whenever you try to run the logminer in the mining database (different from source database. Source database is one in which redo or archived redo logs are generated and mining database is one in which you try to analysis those logs) to add logfile using DBMS_LOGMNR.ADD_LOGFILE it generates error ORA-01284, ORA-00308, ORA-27047




































378)  java.util.zip.ZipException: reading zip file central directory failed, While applying opatch, from the front end I see following message.




































396)  Troubleshoot ORA-06512: at line, ORA-06512 is a common error faced by Oracle DBA, programmers as well as end users. ORA-06512 does not identify the root cause of the problem, rather it only prints the line number where the errors or exception happened. So just before ORA-06512 there will be additional error which we may need to investigate. If the errors come from any function or package or package body or procedure then with ORA-06512 there exists the name of the function or package or package body or procedure as well as the line number of those objects where error is occurred.
 


 






403)  Restore operation fails with RMAN-11003 ORA-01511 ORA-01516, I am performing disaster recovery operation. The new host path are different than from original host. So for the datafile I used SET NEWNAME .. clause. And for the online redo log file I used SQL "ALTER DATABASE RENAME FILE .. " clause to rename the online logfiles to a valid location on to a new host. I have already ran the restore srcipt in previous but it fails to rename third online redo logfiles due to invalid location. And after fixing location whenever I ran the script again it fails with serveral RMAN and Oracle error


404)  Recover database after missing online redo logs and all controlfiles




406)  Crash Recovery Fails With ORA-27067, After performing shutdown abort whenever I try to start my database it fails to perform crash recovery. Below is from alert log.


407)  Allow Recovery to Corrupt Blocks, Whenever during recovery database finds corrupt block then recovery will automatically stops. In order to do recovery with skipping corrupt blocks run the RECOVER command with the ALLOW n CORRUPTION clause, where n is the number of allowable corrupt blocks.


408)  Recovering Through an Added Datafile with a Backup Control File, If database recovery with a backup control file rolls forward through a CREATE TABLESPACE or an ALTER TABLESPACE ADD DATAFILE operation, then the database stops recovery when applying the redo record for the added files and lets you confirm the filenames.




410)  Media recovery can be used to recover from a lost or damaged current datafile, SPFILE or control file




















































436)  Script to Check Schemas with Stale Statistics, This script is an automated way to deal with stale statistics operations that are required to be done as part of manual upgrade OR when reported by DBUA


























449)  ORA-28008: invalid old password, We have a 2 node RAC database. We wanted to change our database password. As it is 2 node Oracle RAC so in the first node I changed the password.






452)  ORA-01012: not logged on, No other user can connect to database. Whenever user with sysdba privilege try to login to database it shows connected but it does not allow to happen any query to database instead it fails with ORA-01012: not logged on as below






















463)  Relocate Datafiles in Oracle Database, Rename/relocate datafiles operation vary based on the log mode of the database. Database may be in archival mode or noarchive mode.




























































































509)  ORA-27100: shared memory realm already exists, when you try to startup your database instance even you issue startup nomount ORA-27100 is reported.












































531)  Information about Temporary Segments






















































































574)  Who is connected to your windows machine using which port






at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)