Using Printers in Solaris
Posted on May 8, 2008 - Filed Under Linux | Leave a Comment
Set your own default printer: setenv PRINTER printername (e.g. “setenv PRINTER printer1″). If you submit your printing job without specifing printer name, the default printer will be used. You may add this line to your “local.cshrc” file. Using command line to print files: lpr -Pprintername filename or lp -d printername filename. Both commands print filename [...]
Read More..>>Events and the SPFILE
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
Using the ALTER SYSTEM SET EVENT command always results in a static change; specifying the SCOPE=MEMORY clause is not allowed. The events use the syntax described earlier, but only the concatenated form is allowed if there are multiple events. To disable or alter a single event in a list, the whole list has to be [...]
Read More..>>How to remove oracle in unix/linux
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
First,pls stop all the orace services,then remove the following directories 1)Remove $ORACLE_HOME 2)Remove $ORACLE_BASE/oraInventory 3)Remove /tmp/OraInstall* 4)Remove /usr/local/bin/dbhome 5)Remove /usr/local/bin/oraenv 6)Remove /usr/local/bin/coraenv 7) Remove /etc/oratab
Read More..>>Oracle dba’s scripts
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
1.Description: This script will display the active user and the rollback segment being used in the database. Code: column rr heading ‘RB Segment’ format a18 column us heading ‘Username’ format a15 column os heading ‘OS User’ format a10 column te heading ‘Terminal’ format a10 SELECT r.name rr, nvl(s.username,’no transaction’) us, s.osuser os, s.terminal te FROM [...]
Read More..>>Gets and pins in oracle
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
Within the shared pool, there are 2 types of data structures used for concurrency control: locks (gets) and pins. A lock has a higher level than a pin and must be acquired before attempting to pin an object. Locks can be thought of as parse locks while pins can be thought of as short-term locks [...]
Read More..>>Understand events of oracle
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
Four Event Categories 1. Dump diagnostic information on request 2. Dump diagnostic information when an error occurs 3. Change database behavior 4. Produce trace diagnostics as the database runs Immediate Dump Events Immediate dump events dump diagnostic information to a trace file. Common immediate dumps are: • File headers (control file, redo log files, data [...]
Read More..>>Oracle DBA Interview Questions
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
1. How many memory layers are in the shared pool? The shared pool consists of the library cache and the dictionary cache. 2. How do you find out from the RMAN catalog if a particular archive log has been backed-up? RC_BACKUP_REDOLOG or 1) backup set RMAN> list archivelog all | from … until….. e.g RMAN> [...]
Read More..>>The relationship between shell prompt (PS1) and Carriage Return (CR)
Posted on May 8, 2008 - Filed Under Linux | Leave a Comment
When you successfully log into a text interface, in the majority of cases, You will see in a continuous blinking box or the bottom line on the screen (depending on the different releases), We call it the cursor. The role of the cursor is to tell you the location will be when you input sth [...]
Read More..>>17 small linux Faqs
Posted on May 7, 2008 - Filed Under Linux | Leave a Comment
001 Q: Change hostname A:vi /etc/sysconfig/network,change “hostname=newhostname”(pls add if none).then run command “hostname newhostname”,then change the hostname in /etc/hosts 002: Q:Remove file named “\a” A:rm \\a 003: Q:Disable ctrl+alt+del A:comment “ca::ctrlaltdel:/sbin/shutdown -t3 -r now” in /etc/inittab 004: Q:How to know the OS release A:cat /proc/version or /etc/redhat-release or /etc/issue 005: Q:Remove ^M in files A:sed [...]
Read More..>>Checklist For UNIX Hostname/IP Change
Posted on May 6, 2008 - Filed Under Linux | 1 Comment
If a unix host is running properly but you only want to change hostname and/or IP address, please check the following check-list and make proper changes. This check-list applies to SDC only, other sites only for reference.
Read More..>>