Troubleshooting issues in Oracle, RedHat Linux, Windows and lot more!.

Oracle Import getting stuck Processing object type SCHEMA_EXPORT/ /database1/rdbm6/export> tail -200f impdp_D.SPORTS_03192012.log ;;; Import: Release 11.2.0.2.0 - Production on Mon Mar 19 15:34:10 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SYS_IMPORT_FULL_02" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_FULL_02":  "/******** AS SYSDBA" REMAP_SCHEMA=SPORTS:SPORTS DIRECTORY=dpump_dir DUMPFILE=expdp_D.SPORTS_02282012.dmp LOGFILE = impdp_D.SPORTS_03192012.log REMAP_TABLESPACE = SPORTS_DATA_TS:SPORTS_DATA_TS , SPORTS_INDEX_TS:SPORTS_INDEX_TS Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"SPORTS" already exists Processing object type SCHEMA_EXPORT/ROLE_GRANT Proc

Here is the way to find to SGA and PGA Values SQL> select * from v$sga; NAME                      VALUE -------------------- ---------- Fixed Size           ########## Variable Size        ########## Database Buffers     ########## Redo Buffers         ########## SQL> show sga; Total System Global Area  530288640 bytes Fixed Size                  2256864 bytes Variable Size             394264608 bytes Database Buffers          125829120 bytes Redo Buffers                7938048 bytes SQL> select max (pga_used_mem) / 1024/1024 M from v$process;          M ---------- 123.972422 SQL> show parameter pga NAME                                 TYPE        VALUE ------------------------------------ ----------- ---------------- pga_aggregate_target                 big integer 0 SQL> select * from v$pgastat; NAME                      VALUE UNIT -------------------- ---------- -------------------- aggregate PGA target ########## b

ORA-12560  is common error on Windows that results from any number of different causes. ORA-12560 is also very common exception when we have two Oracle homes. Mostly ORA-12560 occurs when we have Oracle Client configuration related issues but some times it may be due to Server side and network related issues. To resolve ORA-12560 we need to ensure following points: - Ensure Database Service is up. - Ensure listener is up and pointing to desired database service. - Ensure all oracle variables are configured correctly (ORACLE_BASE, ORACLE_HOME, ORACLE_SID, PATH, TNS_ADMIN). - On Windows: Ensure Full Access is granted to ORACLE_HOME and its sub-directories. In Windows OS: --------------- C:\Users\Home>set ORACLE_HOME=F:\app\Home2\product\11.2.0\dbhome_1 C:\Users\Home>SET ORACLE_SID=RED C:\Users\Home>sqlplus "/as sysdba" Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error C:\Users\Home>oradim -start -sid RED C:\Users\Home>sqlplus &qu

How to make database offline or online 1)With the help of Alter database Command We can make the database offline or online with the help of the Alter database command. The Alter Database command to make the database offline is: ALTER DATABASE database name SET Offline If we want to make the database online we can use the following Alter Database command: ALTER DATABASE database name SET Online 2)With the help of the Db_options We can also use the db_options command to make a database offline or online.To make a database offline we can use the following command: sp_dboption databasename , ' offline' , true To make the database online we can use the following command: sp_dboption databasename , ' offline' , false 3)With the help of Sql server management studio We can also use the Sql server management studio to make a database offline as shown in the given figure. To make database offline we have to follow steps show in fig 1 and

If you want to clear screen in sqlplus window there is small cmd that you need to remember which is below, SQL> select username from dba_users; USERNAME -------------------- BOCMS BOAUDIT  CKI8727 GRU9151 MNA9189 FRE9283  KKO8750  KMU8649 HME9041 ZLP1492 DBE9176  QRA8651  PFI8706 SQL> host cls Once you hit enter the screen will be cleared. SQL> select username from dba_users; USERNAME -------------------- BOCMS BOAUDIT  CKI8727 GRU9151 MNA9189 FRE9283  KKO8750  KMU8649 HME9041 ZLP1492 DBE9176  QRA8651  PFI8706 SQL>clear screen Once you hit enter the screen will be cleared.

SQL*Plus Commands SQL*Plus commands allow a user to manipulate and submit SQL statements. Specifically, they enable a user to: Enter, edit, store, retrieve, and run SQL statements List the column definitions for any table Format, perform calculations on, store, and print query results in the form of reports Access and copy data between SQL databases The following is a list of SQL*Plus commands and their functions. The most commonly used commands are emphasized in italics: /  – Execute the current SQL statement in the buffer – same as RUN ACCEPT – Accept a value from the user and place it into a variable APPEND – Add text to the end of the current line of the SQL statement in the buffer AUTOTRACE – Trace the execution plan of the SQL statement and gather statistics BREAK – Set the formatting behavior for the output of SQL statements BTITLE – Place a title on the bottom of each page in the printout from a SQL statement CHANGE – Replace text on the current line of the

What is the Net Command?: The net  command  is a  Command Prompt command  that can be used to manage almost every aspect of a network and its settings including managing network shares, network print jobs, network users, and much more. C:\>net /? The syntax of this command is: NET     [ ACCOUNTS | COMPUTER | CONFIG | CONTINUE | FILE | GROUP | HELP |       HELPMSG | LOCALGROUP | PAUSE | SESSION | SHARE | START |       STATISTICS | STOP | TIME | USE | USER | VIEW ] Net Accounts The net accounts command is used to set password and logon requirements for users. For example, the net accounts command can be used to set the minimum number of characters that users can set their password to. Net Computer The net computer command is used to add or remove a computer from a domain. Net Config Use the net config command to show information about the configuration of the  Server  or Workstation  service.