17 January 2011

Convert FAT to NTFS

Is it possible to convert a FAT32 Hard Drive to NTFS without losing all data on the drive? I like to change from FAT32 to NTFS, my operating system is Windows XP PRO, how can I do that? Without the lost of my programs?

A: Standard Windows utility that is called CONVERT serves this purpose
Just go to the Command Prompt and execute the command:
C:\> CONVERT  C:  /fs:ntfs
Where C: is a name of the drive you want to convert.
After machine re-boot conversion process will start and you'll have your FAT32 converted to NTFS without of data loss.

13 January 2011

ORA-01000:maximum open cursors exceeded

 Error :-

 execute below command
[oracle@our12-dev ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 13 18:11:32 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set open_cursors = 10000;

System altered.

SQL> select * from  v$parameter where name ='open_cursors';

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
      1365

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
open_cursors

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
         3

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
10000

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
10000

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
FALSE     FALSE IMMEDIATE TRUE  SYSTEM_MOD FALSE FALSE TRUE

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
max # cursors per session

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------


       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------
4033294835

       NUM
----------
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
      HASH
----------


SQL>

05 January 2011

Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for Linux: Version 11.1.0.7.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production

Error:-
i am using oracle AppsR12.1.1 in my database alert log show below error .

Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
        TNS for Linux: Version 11.1.0.7.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
  Time: 05-JAN-2011 12:12:33
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537

TNS-12535: TNS:operation timed out
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: <unknown>
ORA-609 : opiodr aborting process unknown ospid (17682_47967265127616)
Wed Jan 05 12:18:13 2011


***********************************************************************

Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
        TNS for Linux: Version 11.1.0.7.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
  Time: 05-JAN-2011 12:18:13
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537

TNS-12537: TNS:connection closed
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
ORA-609 : opiodr aborting process unknown ospid (18182_46915810041024)

Solution:-
shut down your database
edit your db sqlnet.ora
enter below entry DIAG_ADR_ENABLED=off
start your database . then see your problem is resolved

04 January 2011

REP-0004: Warning: Unable to open user preference file .

Error :- 
PPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
AMERICAN_INDIA.UTF8

'.,'

Enter Password:
REP-0004: Warning: Unable to open user preference file.

Report Builder: Release 10.1.2.3.0 - Production on Tue Jan 4 16:46:43 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.




+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PUBLISH -------------+
Unable to find an Output Post Processor service to post-process request 8276455.

Check that the Output Post Processor service is running.
+--------------------------------------+

+------------- 2) PRINT -------------+
Not printing the output of this request because post-processing failed.
+--------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 04-JAN-2011 16:47:17

+---------------------------------------------------------------------------+
Solution:-
Please check the Display variables default
#export DISPLAY=our12-dev:1.0