Sometime accidently, we create file with special character and its hard to remove file using rm command.
| " | " |
|---|---|
| & | & |
| < | < |
| > | > |
You can use the info from the 'model' command to get the processor type (PA-RISC or Itanium) like so:
Unix1$ grep -i $(model cut -d"/" -f3) /usr/sam/lib/mo/sched.models
which tells us that the box has a PA8700 processor type (PA-RISC)
To get the speed, you can do:
Unix1$ echo 'itick_per_usec/D' adb /stand/vmunix /dev/kmem grep itick_per_usectail -1
which tells us it's a 750MHz processor
To get whether the kernel is running in 32 or 64bit mode you can do:
(Unix1:oracle)# getconf KERNEL_BITS
64
which says 64bit mod
C:\> cd "C:\Program Files\PuTTY"
C:\Program Files\PuTTY> pscp -h # -h gives a short help listing
...short help listing displays here...
C:\Program Files\PuTTY> pscp -P 2003 -l alleni99 \
net2003.idallen.ca:.bashrc foo.txt
...you may be asked to accept the host key here (say yes)...
alleni99@net2003.idallen.ca's password:
...file transfers ".bashrc" to "foo.txt" in the current directory...
Remember to use the -P option and use -l to set your own userid.
C:\> cd "C:\Program Files\PuTTY"
C:\Program Files\PuTTY> psftp -h # -h gives a short help listing
...short help listing displays here...
C:\Program Files\PuTTY> psftp -P 2003 -l alleni99 net2003.idallen.ca
...you may be asked to accept the host key here (say yes)...
alleni99@net2003.idallen.ca's password:
Remote working directory is /home/alleni99
psftp> help
...short help listing displays here...
psftp> ls
...listing of directory displays here...
psftp> get .bashrc foo.txt
remote:/home/alleni99.bashrc => local:foo.txt
psftp> quit
...file "foo.txt" is now in the current directory...
Remember to use the -P option and use -l to set your own userid when
using the PuTTY version of PSFTP.
Note that the options to the PuTTY Windows version of SFTP (named
PSFTP) are not the same as the options to the Unix/Linux version
of SFTP. In particular, the option "-P" has different meanings!
################################### My examples ##########################################################
************* windows:-**********************
From desktop to TESTNET database server:
pscp -P 2222 -l oracle swingbench230376.zip localhost:swingbench230376.zip
pscp -P 2222 -l oracle jre-6u7-solaris-sparc.sh localhost:jre-6u7-solaris-sparc.sh
pscp -P 2222 -l oracle jre-6u7-solaris-sparcv9.sh localhost:jre-6u7-solaris-sparcv9.sh
From TESTNET database server to desktop:
pscp -P 2222 -l oracle localhost:trap_test.ksh trap_test.ksh
C:\Program Files\Putty>pscp -P 2222 -l oracle swingbench230376.zip localhost:swingbench230376.zip
Using keyboard-interactive authentication.
Password:
swingbench230376.zip | 9005 kB | 1500.9 kB/s | ETA: 00:00:00 | 100%
If tunnel not setup correctly then we will get following message:
C:\Program Files\PuTTY>pscp -P 2222 -l oracle swingbench230376.zip localhost:swingbench230376.zip
Fatal: Network error: Connection refused
Drop Oracle Database Manually:
Create Update trigger on stream heatbeat table to test HEAVY insert/update activiry.
CREATE OR REPLACE TRIGGER KARAM.UPDATE_AFTER_EACH_ROW
AFTER UPDATE
OF STM_UDT_TS
ON KARAM.TDM_STRMHB FOR EACH ROW
DECLARE
v_out_file UTL_FILE.FILE_TYPE;
begin
v_out_file := UTL_FILE.FOPEN('STRMADMIN_DIR','heart_beat.log', 'A');
UTL_FILE.PUT_LINE (v_out_file, 'Updated on ' to_char(sysdate,'mm-dd-YYYY HH24:MI:SS'));
UTL_FILE.FCLOSE(v_out_file);
EXCEPTION
WHEN OTHERS THEN NULL;
end update_after_each_row;
/
ALTER TRIGGER KARAM.UPDATE_AFTER_EACH_ROW ENABLE;
Also trigger will get fire only if following executed:
SQLPLUS> beginDBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST_SCHEMA','UPDATE_AFTER_EACH_ROW',FALSE);end;/