Skip to main content

Posts

How to Create a Shortcut to Run a Program as a Specified User in Windows

1.  Right click on an empty area on desktop, and click on  New  and  Shortcut . 2.  Type the command below into the location area, and click on the  Next  button. (see screenshot below) Replace  USER-NAME  in the command with the actual name of the user account that you want to run the program as. runas /user:USER-NAME "C:\full\path\of\Program.exe" For example, if I wanted to run Notepad as the  test  user, I would type this command below. runas /user:myadmin "D:\myprogram\myprogram.exe" 3.  Type a name for the shortcut in the name section, and click on the  Finish  button.  4.  Right click on the new shortcut on the Desktop and click on  Properties . 5.  Click on the  Shortcut  tab, then click on the  Change Icon  button. 6. Now you can access the file through your new shortcut.  Double  click on the icon and you may...

DBVERIFY: Database Verification Utility

DBVERIFY  is a utility of Oracle , that can be used to perform a physical structure integrity check against  database files. Note that the database should be off line before performing a DBVERIFY. But it will work with online data files also,but its not recommended. DBVERIFY is invoked using dbv command.It should be called from ORACLE_HOME/bin directory. To access help on DB_VERIFY type:   dbv help=y To perform a simple DBVIRIFY use below command.Output will be written to the dbv.log file. >dbv file=/u01/oracle/product/10.2.0/oradata/orcl/users01.dbf logfile=dbv.log Note that this is only a verification tool to get a idea about data files,whether they are corrupted or not.You'll have to follow other methods to recover corrupted data files. Exmples: dbv example of  a datafile with no corruption. (Pages are data blocks) DBVERIFY: Release 11.2.0.2.0 - Production on Tue Mar 13 15:41:47 2012 Copyright (c) 1982, 2009, Oracle and/or its ...

Linux tar Command

The  tar (tape archive) command bundles a bunch of files together and creates an archive  on a tape, disk drive etc. Simple way for creating a tar file. Go to the relevant path.In our example go to the path where "myfolder" resides.So if I want to add files in myfolder to a tar file issue below command.It will create the tar file in /my location. tar -cvf  /my/test.tar  myfolder How to untar... Go to the location where you want to untar the files/folder and issue below command. tar -xvf  /my/test.tar You can use below command to list the contents of a tar file to a log. tar -tvf  test.tar  > temp/test.log Options available with tar command: c  Create a new archive. t  List the contents of an archive. x  Extract the contents of an archive. f  The archive file name is given on the command line (required whenever the tar output is going to a file) M  The archive can span multiple flop...

Oracle Database 9i DBCA error - ORA-29807: Specified oprator does not exist

During installation of Oracle 9i database - DBCA - Creating a database step - you will get an error like below.Error will be shown in " Creating data dictionary Views" section when the process is around 17% complete. ORA-29807: Specified oprator does not exist  This is actually a bug in the software. It is a known Oracle 9i problem regarding data dictionary views. It has been determined that this error is being raised while DBCA is running the script prvtxml.plb. Prvtxml.plb is a script which creates a particular package body. This script is called from the catxml.sql script - which in turn is called by the catproc.sql script - run automatically when creating a database using DBCA. Anyway  You can safely ignore the error and continue with the creation of the database. Workaround: 1. Click Ignore and go ahead with DBCA (after invoking DBCA).     The database creation using DBCA should now proceed without additional errors. OR  2. Go to the script catx...