1. Net Sevice Name Incorrectly Specified
Sid Name Incorrect
2. Tns Lost Contact
Recreate Listener
3. Ora-01455: Converting Column Overflows Integer Datatype
Statistics=None Or Exclude=Statistics
Nls_Characterset. Nls_Language=American_America.We8mswin1252
4. Canot Open Database In Exclusive Mode
Shut Instance Which Already Runing Using Same Crd Files
5. How To Do Data Pump Import From Higher To Lower Version Database
Expdp Arju/A Tables=Test Dumpfile=Test_Table.Dmp Logfile=Test_Table.Log Directory=E Version=10.2
6. Data In The Partition Was Deleted But Space Allocated To That Partition Was Not Gained
Alter Table User_Activity Truncate Partition Mar_2008 Drop Storage;
7.The Sha-Bang (#!) At The Head Of A Script Tells Your System That This
File Is A Set Of Commands To Be Fed To The Command Interpreter Indicated.
After #! There Is Path Name Which Is The Path To The Program That Interprets The ommands In The Script, Whether It Be A Shell, A Programming Language, Or A Utility. This Command
Interpreter Then Executes The Commands In The Script, Starts At The Top And Ignore
Comments.
8. Ora-27101: Shared Memory Realm Does Not Exist
Create Spfile From Pfile . Problem Will Solve With Old Sga Parameters
9. Ora-00054 Resource Busy And Acquire With Nowait Specified
Oracle Database 11g Includes The Ddl_Lock_Timeout Parameter, Which You Can Set Using
The Alter System And Alter Session Commands. Now You Have The Opportunity Not To Issue
Ddl Frequently And Query Itself Can Wait A Specified Time And If It Find Resource Free Within This Time Ddl Operation Will Be Completed.
10. To Add New Partition To A Table
Alter Table Chitta Split Partition Pmax At (To_Date('01-Aug-2011'))
Into (Partition P0711,Partition Pmax)
11. Exporting Questionable Statistics
Slect Nls_Characterset From Nls_Database_Parameters
Export Nls_Lang=American_America.Character Set
12 . Ping[Arc0]: Heartbeat Failed To Connect To Standby 'Standby'. Error Is 1031. Insufficient Privs
Recreate Standby Database Password File Using Orapwd Utility
13 . Ora-01153: An Incompatible Media Recovery Is Active
Alter Database Recover Managed Standby Database Cancel;
14. Ora-16607: One Or More Databases Have Failed
Both Databases Should Start With Spfile Only And In Both Databases The Parameter
Dg_Broker_Start Should Be Set To True
15.Oc4j Configuration Issue. F:\Oracle\Product\10.2.0\Db_1/Oc4j/J2ee/Oc4j_Dbconsole_Radha_Orcl Not Found.
16. To View A List Of Archivelogs That Are No Longer Needed On The Standby, You Must First Execute The Following Procedure:
Execute Dbms_Logstdby.Purge_Session;
This Procedure Updates The Dba_Logmnr_Purged_Log View With A List Of Archivelogs That Are No Longer Needed.
Alter Database Start Logical Standby Apply Skip Failed Transaction;
17. Rman-05001: Auxiliary Filename '%S' Conflicts With A File Used By The Target Database
Db_File_Name_Convert=(,)
Log_File_Name_Convert=(,)
18. Rman-06023: No Backup Or Copy Of Datafile 5 Found To Restore
Copy Rman Backup Set Copies To Remote System Directory
19. To Mount Widows Folder Into Linux
Mount –T Cifs //10.150.1.26/Shared Folder /Mount –O Username=Root
20. Case Statement In Where Clase
Sql>Var Dyy Number
Sq>Exec :Dyy:=15
Select * From Estimate_Approval_Auth_M O Where O.Category_Id='100-22' And No_Of_Days = (Case When
:Dyy >=5 Then 5 When :Dyy>5 And :Dyy>=10 Then 10 When :Dyy>10 And :Dyy>=15 Then 15 When :Dyy>;15 And :Dyy>20 Then 20 Else 25 End )
22. Run Level check failed in cluvfy
Check: Run level
Node Name run level Required Status
------------ ------------------------ ------------------------ ----------
il06devvcpdb01 unknown 3,5 failed
Result: Run level check failed
[oragrid@il06devvcpdb01 grid]$ /usr/bin/who -r
[oragrid@il06devvcpdb01 grid]$
Chmod 644 /etc/inittab
Chmod 644 /var/run/utmp
[oragrid@il06devvcpdb01 grid]$ who -r
run-level 5 2012-02-07 06:58 last=S
[oragrid@il06devvcpdb01 grid]$
No comments:
Post a Comment