The following section in registry should be checked:
HKEY_CLASSES_ROOT\http\shell\open\command
Key: (default)
Most (but not all) browsers check it to determine the current browser.
currentBrowser = RegistryGet("HKEY_CLASSES_ROOT","http\shell\open\command","")
MsgBox( currentBrowser )
Some browsers could create additional section HKEY_CLASSES_ROOT\http\shell\OpenWith\command, which helps to avoid the conflict with IE settings.
Create the table to save logon information:
CREATE TABLE logonaudittable (
event VARCHAR2(10),
sid NUMBER,
serial# NUMBER,
timestamp DATE,
username VARCHAR2(30),
osuserid VARCHAR2(30),
machinename VARCHAR2(64)
);
Find the name of the current password function
SELECT * FROM DBA_PROFILES WHERE RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';
Change the password function for the profile:
ALTER PROFILE &profile. LIMIT PASSWORD_VERIFY_FUNCTION &function_name.;
Example of the password function:
CREATE OR REPLACE FUNCTION dummy_func
(USERNAME VARCHAR2, PASSWORD VARCHAR2, OLD_PASSWORD VARCHAR2)
RETURN BOOLEAN IS
BEGIN
IF NLS_LOWER(password) = NLS_LOWER(username) THEN
raise_application_error(-20001, 'Password is the same as the username');
END IF;
RETURN(TRUE);
END;
select spid,cmd,status,loginame,open_tran,
datediff (s,last_batch,getdate()) as [Waittime (s)]
from master..sysprocesses p
where open_tran > 0
and spid > 50
and datediff (s,last_batch,getdate()) > 30
and exists ( select * from master..syslockinfo
where req_spid=p.spid and rsc_type <>2)
col opname for a40
col units for a10
SELECT sid
,opname
,sofar
,totalwork
,units
,elapsed_seconds
,time_remaining
FROM v$session_longops
WHERE sofar != totalwork;
There is a known problem with Oracle statspack report in 10g, which could cost You at least one lost statspack snapshot.
The following message is written into the alert log:
ORA-00001: unique constraint (PERFSTAT.STATS$MUTEX_SLEEP_PK) violated
ORA-06512: at “PERFSTAT.STATSPACK”, line 5264
ORA-06512: at “PERFSTAT.STATSPACK”, line 104
ORA-06512: at line 1
There is a Note 382993.1 in Metalink, which describes this bug.
The workaround is simple:
alter table perfstat.stats$mutex_sleep disable constraint STATS$MUTEX_SLEEP_PK;
create index perfstat.STATS$MUTEX_SLEEP_PK on
STATS$MUTEX_SLEEP(SNAP_ID,DBID,INSTANCE_NUMBER,MUTEX_TYPE,LOCATION);
… and check the Metalink for the news, if the bug was fixed.
[amazon-product]007222360X[/amazon-product]
Sometimes it’s necessary to read the information from the alert log together with the timestamp of the error.
The very simple Unix-shell script helps to do this:
echo
echo 'Enter # of lines:'
read NUM
tail -$NUM alert_${ORACLE_SID}.log | awk '
BEGIN {prev="" ; ret=1 }
/^(...-|Error)/ { if ( prev !~ /^(...-|Error)/ ) { print "" ; print prev;} print $0;ret=0}
{prev=$0}
END { exit ret } '
This code could be assigned to some hotkey in Your favorite telnet application, so You just need to press something like “Alt+A” to see the quick review of the recent Oracle errors.
Example:
Enter # of lines:
1000
Sep 01 19:42:03 2009
Errors in fileARC0: Archiving not possible: error count exceeded
Sep 01 19:42:06 2009
Errors in file testsrv_arc0_23486.trc:
ORA-16038: log 1 sequence# 112 cannot be archived
ORA-19502: write error on file “”, blockno (blocksize=)
ORA-00312: online log 1 thread 1: ‘redo_g1_m1.log’
Export to the compressed file
/etc/mknod my_own_pipe p
gzip -c -9 < my_own_pipe > mydump.gz &
exp username/password ...... file=my_own_pipe
rm -f my_own_pipe
Import from the compressed file:
/etc/mknod my_own_pipe p
gunzip -c mydump.gz > my_own_pipe &
imp username/password ....... file=my_own_pipe
rm -f my_own_pipe
The following trick could be used, if You want to start Oracle export as sysdba: use double quotes around the single quotes.
Warning! Dump consistency could not be guaranteed, if the export is done under sys user!
exp userid=" '/ as sysdba' " parfile=exp.par
Possible parameter file:
file=mydump.dmp
compress=n
log=mydump.log
direct=y
full=n
owner=SCOTT
consistent=y
feedback=10000
If You need the analog of Unix ‘which’ command and do not have Resource Kit, the following batch file will help.
The code was found on www.ss64.com
Published with the permission of the author, Clay Calvert.
@echo off
SETLOCAL
(set WF=)
:: Look for file in the current directory
for %%a in ("" %PATHEXT:;= %) do (
if not defined WF if exist "%~1%%~a" set WF=%CD%\%~1%%~a)
:: Look for file in the PATH
for %%a in ("" %PATHEXT:;= %) do (
if not defined WF for %%g in ("%~1%%~a") do (
if exist "%%~$PATH:g" set WF=%%~$PATH:g))
:: Store the Help Error message
if NOT "%~x1"=="" goto:END
for /f "delims=." %%a in ('help.exe *') do set HlpErr=%%a
:: If command missing from Help, goto end
help.exe "%~1" |find "%HlpErr%">nul && goto:END
:: Listed in help so find file in System32
for %%a in (exe com) do (
if /i "%WF%"=="%windir%\system32\%~1.%%a" goto:END)
:: File not in System32, so must be an internal command
set WF="%~1" is an internal command
:END
if defined WF (echo.%WF%) else (
echo The file: "%~1" was not found)
:: Credits:
:: Clay Calvert
:: alt.msdos.batch.nt