Using files greater then 2GB in Oracle 7

Oracle 7.3.4 can't read or write to files larger than 2GB ( 2,147,483,648 bytes), so you have to pipe the export/import though gzip. EXPORT #!/bin/ksh . /export/home/oracle7/.profile # create a named pipe mknod /oracle/exports/orasid.pipe p # read the pipe - output to zip file in the background gzip < /oracle/exports/orasid.pipe > /oracle/exports/export.exp.gz & exp exp/passwd@orasid file=/oracle/exports/orasid.pipe full=y direct=y log=/oracle/exports/export.log IMPORT #!/bin/ksh .

Kill All Connected Sessions for a user

Script that kills all sessions connected as AUSER SET SERVEROUTPUT ON SIZE 1000000 BEGIN FOR usersession IN (SELECT s.USERNAME, s.OSUSER, s.STATUS, s.SID, s.SERIAL# FROM v$process p,v$session s WHERE p.addr = s.paddr AND s.username = 'AUSER') LOOP BEGIN IF usersession.STATUS = 'ACTIVE' THEN EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION ' || '''' || usersession.sid || ',' || usersession.serial# || '''' || 'IMMEDIATE'; ELSIF usersession.STATUS = 'INACTIVE' THEN EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION ' || '''' || usersession.sid || ',' || usersession.serial# || '''' || 'IMMEDIATE'; ElS

Setting up a new network printer in Solaris

7.1 Create a new network printer # lpadmin \ > -p networkprinter \ > -v /dev/null \ > -T PS \ > -A write \ > -i /usr/lib/lp/model/netstandard \ > -o dest=10.0.0.10 \ > -o protocol=bsd \ > -o nobanner \ > -o banner=never \ > -I postscript \ > -u allow:all 7.2 Give the new networkprinter a description # lpadmin -p networkprinter -D "This is my network printer" 7.3 Enable the printer # enable networkprinter # accept networkprinter 7.4 Define filters # lpfilter -f catv -F /etc/lp/fd/catv.fd # lpfil

Stop GDM from starting at boot

You need to change your run level or change the services that is executed for that runlevel, see below.
  • Runlevel 0 is halt.
  • Runlevel 1 is single-user.
  • Runlevels 2-5 are multi-user.
  • Runlevel 6 is reboot.
First open /etc/inittab and look for the default runlevel. # The default runlevel. id:2:initdefault: It's 2 in this case. Next go to '/etc/rc2.d' there you will see a symbolic link to gdm, usually S99gdm->../init.d/gdm Remove S99gdm and you system will not boot into X
Tags:

Configure dual screens in Solaris 10

If you have a video card that supports dual connections and you are using Solaris 10, you can use fbconfig to configure dual monitors. First use fbconfig -list to see what monitors are attached. Then use fbconfig -doublewide enable to turn on dual screen. You may then have to reboot for it to take effect. If you want to change the login screen so that it better suits dual screens have a look at how to create a GDM theme and how to switc
Tags:

chmod absolute-mode - symbolic mode conversion

Owner Group World Permission ========= ========= ========= ====================== 7 (u+rwx) 7 (g+rwx) 7 (o+rwx) read + write + execute 6 (u+wx) 6 (g+wx) 6 (o+wx) write + execute 5 (u+Rx) 5 (g+Rx) 5 (o+Rx) read + execute 4 (u+r) 4 (g+r) 4 (o+r) read only 2 (u+w) 2 (g+w) 2 (o+w) write only 1 (u+x) 1 (g+x) 1 (o+x) execute only
Tags:

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer