Command prompts for Windows

Command prompts for Windows

Control Panel

·         CONTROL: opens the control panel window

·         CONTROL ADMINTOOLS: opens the administrative tools

·         CONTROL KEYBOARD: opens keyboard properties

·         CONTROL COLOUR: opens display properties with the appearance tab

·         CONTROL FOLDERS: opens folder options

·         CONTROL FONTS: opens font policy management

·         CONTROL INTERNATIONAL or INTL.CPL: opens the regional and language option

·         CONTROL MOUSE or MAIN.CPL: opens mouse properties

·         CONTROL USERPASSWORDS: opens user accounts editor

·         CONTROL USERPASSWORDS2 or NETPLWIZ: user account access restrictions

·         CONTROL PRINTERS: opens faxes and printers available

·         APPWIZ.CPL: opens the add or remove programs utility tool

·         OPTIONALFEATURES: opens the add or remove windows component utility

·         DESK.CPL: opens display properties with the themes tab

·         HDWWIZ.CPL: opens add hardware wizard

·         IRPROPS.CPL: infrared utility tool

·         JOY.CP: opens game controllers settings

·         MMSYS.CPL: opens sound and audio device properties with the volume tab

·         SYSDM.CPL: opens system properties

·         TELEPHON.CPL: opens phone and modem options

·         TIMEDATE.CPL: date and time properties

·         WSCUI.CPL: opens Windows Security Center

·         ACCESS.CPL: opens accessibility options

·         WUAUCPL.CPL: opens automatic updates

·         POWERCFG.CPL: opens power options properties

·         AZMAN.MSC: opens authorisation management utility tool

·         CERTMGR.MSC: opens certificate management tool

·         COMPMGMT.MSC: opens the computer management tool

·         COMEXP.MSC or DCOMCNFG: opens the computer services management tool

·         DEVMGMT.MSC: opens device manager

·         EVENTVWR or EVENTVWR.MSC: opens event viewer

·         FSMGMT.MSC: opens shared folders

·         NAPCLCFG.MSC: NAP client configuration utility tool

·         SERVICES.MSC: opens service manager

·         TASKSCHD.MSC or CONTROL SCHEDTASKS: opens schedule tasks manager

·         GPEDIT.MSC: opens group policy utility tool

·         LUSRMGR.MSC: opens local users and groups

·         SECPOL.MSC: opens local security settings

·         CIADV.MSC: opens indexing service

·         NTMSMGR.MSC: removable storage manager

·         NTMSOPRQ.MSC: removable storage operator requests

·         WMIMGMT.MSC: opens (WMI) Window Management Instrumentation

·         PERFMON or PERFMON.MSC: opens the performance monitor

·         MMC: opens empty console

·         MDSCHED: opens memory diagnostics tools

·         DXDIAG: opens DirectX diagnostics tools

·         ODBCAD32: opens ODBC data source administrator

·         REGEDIT or REGEDT32: opens registry editor

·         DRWTSN32: opens Dr. Watson

·         VERIFIER: opens driver verifier manager

·         CLICONFG: opens SQL server client network utility

·         UTILMAN: opens utility manager

·         COLORCPL: opens color management

·         CREDWIZ: back up and recovery tool for user passwords

·         MOBSYNC: opens synchronization center

·         MSCONFIG: opens system configuration utility

·         SYSEDIT: opens system configuration editor (careful while using this command)

·         SYSKEY: Windows account database security management (careful while using this command)

Windows utility and applications

·         EPLORER: opens Windows Explorer

·         IEXPLORER: opens Internet Explorer

·         WAB: opens contacts

·         CHARMAP: opens character map

·         WRITE: opens WordPad

·         NOTEPAD: opens Notepad

·         CALC: opens Calculator

·         CLIPBRD: opens Clipbook Viewer

·         WINCHAT: opens Microsoft Chat Interface

·         SOUNDRECORDER: opens sound recording tool

·         DVDPLAY: run CD or DVD

·         WMPLAYER: opens Windows Media Player

·         MOVIEMK: Opens untitled Windows Movie Maker

·         OSK: opens on-screen keyboard

·         MAGNIFY: opens Magnifier

·         WINCAL: opens Calendar

·         DIALER: opens phone dialer

·         EUDCEDIT: opens Private Character Editor

·         NDVOL: opens the mixer volume

·         RSTRUI : opens Tool System Restore (For Vista only)

·         %WINDIR%\SYSTEM32\RESTORE\rstrui.exe: opens Tool System Restore (for XP only).

·         MSINFO32: Opens System Information

·         MRT : launches the utility removal of malware

·         Taskmgr : Opens the Windows Task Manager

·         CMD: opens a command prompt

·         MIGWIZ: Opens the tool for transferring files and settings from Windows (Vista only)

·         Migwiz.exe: Opens the tool for transferring files and settings from Windows (for XP only)

·         SIDEBAR: Open the Windows (Vista only)

·         Sigverif : Opens the tool for verification of signatures of files

·         Winver : Opens the window for your Windows version

·         FSQUIRT: Bluetooth Transfer Wizard

·         IExpress opens the wizard for creating self-extracting archives. Tutorial HERE

·         MBLCTR: opens the mobility center (Windows Vista only)

·         MSRA : Opens Windows Remote Assistance

·         Mstsc : opens the tool connection Remote Desktop

·         MSDT: opens the diagnostic tools and support Microsoft

·         WERCON: opens the reporting tool and solutions to problems (for Vista only)

·         WINDOWSANYTIMEUPGRADE: enables the upgrade of Windows Vista

·         WINWORD : opens Word (if installed)

·         PRINTBRMUI : Opens migration wizard printer (Vista only)

Disk management

·         DISKMGMT.MSC: opens disk management utility

·         CLEANMGR: opens disk drive clean up utility

·         DFRG.MSC: opens disk defragmenter

·         CHKDSK: complete analysis of disk partition

·         DISKPART: disk partitioning tool

Connection management

·         IPCONFIG: lists the configuration of IP addresses on your PC (for more information type IPCONFIG/? in the CMD menu)

·         INETCPL.CPL: opens internet properties

·         FIREWALL.CPL: opens Windows firewall

·         NETSETUP.CPL: opens network set up wizard

Miscellaneous commands

·         JAVAWS: View the cover of Java software (if installed)

·         AC3FILTER.CPL: opens the properties AC3 Filter (if installed)

·         FIREFOX: Mozilla launches Firefox (if installed)

·         NETPROJ: allow or not connecting to a network projector (For Vista only)

·         LOGOFF: closes the current session

·         SHUTDOWN: shuts down Windows

·         SHUTDOWN-A: to interrupt Windows shutdown

·         %WINDIR% or %SYSTEMROOT%: opens the Windows installation

·         %PROGRAMFILES%: opens the folder where you installed other programs (Program Files)

·         %USERPROFILE%: opens the profile of the user currently logged

·         %HOMEDRIVE%: opens the browser on the partition or the operating system is installed

·         %HOMEPATH%: opens the currently logged user C:\Documents and Settings\ [username]

·         %TEMP%: opens the temporary folder

·         VSP1CLN: deletes the cache for installation of the service pack 1 for Vista

·         System File Checker (Requires Windows CD if the cache is not available):

·         SFC / scannow: immediately scans all system files and repairs damaged files

·         SFC / VERIFYONLY: scans only those files system

·         SFC / Scanfil = "name and file path": scans the specified file, and repairs if damaged

·         SFC / VERIFYFILE = "name and file path": Scans only the file specified

·         SFC / scanonce: scans the system files on the next restart

·         SFC / REVERT: return the initial configuration (For more information, type SFC /? In the command prompt CMD.

ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal

Error Description 

Import: Release 11.2.0.3.0 - Production on Thu Dec 26 13:48:26 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "CORP2012"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "CORP2012"."SYS_IMPORT_FULL_01":  CORP2012/******** directory=IMPDP dumpfile=26122013_1100-CORPORATE.DMP remap_schema= logfile= full=y
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"CORP2012" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."SPLIT_TBL"   OID 'ECD98FAC59A9469F8E458BDC2567F955' AS TABLE OF VARCHAR2 (32767)
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."MONTHWISESALES_OBJ_TYPE"   OID '8C344D8083BC496499E0FB3822C37F9F' IS OBJECT
(
ITEMNUMBER VARCHAR2(20),ITEM1  VARCHAR2(150),ITEMGROUP VARCHAR2(150),FMAXSALES NUMBER(15,2),
SMAXSALES NUMBER(15,2) ,THIRTYSALES NUMBER(15,2),JAN NUMBER(15,2),FEB NUMBER(15,2),MAR NUMBER(15,2),APR NUMBER(15,2),
MAY NUMBER(15,2),JUN NUMBER(15,2),JUL NUMBER(15,2),AUG NUMBER(15,2),SEP NUMBER(15
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."STOCKDTL_OBJ_TYPE"   OID '4E3C080CC3F94EB9947FEE8769738BD3' IS OBJECT
(
ITEMNUMBER VARCHAR2(20),ITEM1  VARCHAR2(150),ITEMGROUP VARCHAR2(150),PENDINGPR NUMBER(15,2),poqty number(15,2),
CLSTOCK NUMBER(15,2),PORTQTY NUMBER(15,2),ONWAY NUMBER(15,2)
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."BDFTREETYPE"   OID '9C2BA68B02FA4BFCBFD19561C64A3C2C' AS OBJECT (
PARENTNO NUMBER,
CHILDNO NUMBER,
SID NUMBER,
SC_CODE VARCHAR2 (500),
SD_CODE VARCHAR2 (500),
SRD_CODE VARCHAR2 (500),
NIIN_NO VARCHAR2 (100),
ITEMNAME VARCHAR2 (500),
WUC_CODE VARCHAR2 (100),
WUC_DESC VARCHAR2 (500),
SERIALNO VARCHAR2 (100),
DOCID VARCHAR2 (100),
TREEDESCRIPTION VARCHAR2 (1000),
APPCODE
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."SPLIT_TBL1"   OID 'DD944536D2EB453B8A965D8502B03C14' AS TABLE OF CLOB
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."FUNDFLOW_OBJ_TYPE"   OID '044C10C96FAD403FB31DBB9B72B02838' IS OBJECT
(
ACCOUNT VARCHAR2(100),INAMOUNT NUMBER(15,2),OUTAMOUNT NUMBER(15,2))
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."MONTHWISESALES_TABTYPE"   OID '260BF5B33A7D481CA814B61766ED47DA' AS TABLE OF MONTHWISESALES_OBJ_TYPE
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."STOCKDTL_TABTYPE"   OID '2DD34594CE534F01AC4E0E1EE3396186' AS TABLE OF STOCKDTL_OBJ_TYPE
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."BDFARRAYTYPE"   OID '9645FBF504544A508531FA40C217F950' AS TABLE OF BDFTREETYPE;
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."FUNDFLOW_TABTYPE"   OID '4FA8101A71344FE5A3394AEB14D79F24' AS TABLE OF FUNDFLOW_OBJ_TYPE


Solution

CORP2012/******** directory=IMPDP dumpfile=26122013_1100-CORPORATE.DMP logfile=CORP2012_28122013.log REMAP_SCHEMA=CORPORATE:CORP2012 TABLE_EXISTS_ACTION=APPEND PARALLEL=5 TRANSFORM=oid:n 

How to increase no. of sessions in oracle database?

If you want to increase sessions parameter you should consider increasing processes and transactions parameter as well.

Here is the formula you can use to determine their values.

processes=x
sessions=x*1.1+5
transactions=sessions*1.1

E.g.
processes=500
sessions=555
transactions=610

Commands:-
sqlplus "/as sysdba"
or
sqlplus '/as sysdba'


sql> show parameter sessions
sql> show parameter processes
sql> show parameter transactions
sql> alter system set processes=500 SCOPE=SPFILE; 
sql> alter system set sessions=555 SCOPE=SPFILE; 
sql> alter system set transactions=610 SCOPE=SPFILE; 

and Restart the database.

Below parameters values also must be changed.....

sql>alter system set open_cursors=1500 scope=both;
sql>alter system set processes=3000 scope=spfile;
sql>alter system set job_queue_processes=4 scope=both;
sql>alter system set undo_retention=10800 scope=both;
sql>alter system set max_shared_servers=50 scope=both;
sql>alter system set db_files=2000 scope=spfile; 
sql>alter system set sessions=3305 SCOPE=SPFILE;  
sql>alter system set transactions=3635 SCOPE=SPFILE;