• https://davidwalsh.name/password-protect-directory-using-htaccess
• http://www.htaccesstools.com/articles/password-protection/

Two files are needed.<br /> The .htaccess Code

0@@

The .htpasswd Code

1@@

Generate an MD5 hash with the tools above and paste into this file

2@@

Check modules.conf file to ensure mod_auth and mod_rewrite are enabled

3@@

Alter the lighttpd.conf file to allow the authentication

4@@

Restart the lighttpd server

5@@

I tried it with htdigest but could not get it to protest the directory!

6@@

7@@

• Oracle have a document that describes a few ways of doing it in Note 824473.1

If the filename contains control characters and cannot be selected in the normal way, use ls -ali to find the node number and then use find with -inum to rename (or move) the file

8@@

Work out what the database thinks the name is and rename it there too! AskTom has a discussion on it here

9@@

You can see there's a 127 just before the .dbf… this crept in a the backspace key was not working correctly.

10@@

Before deleting or dropping directories in the database, use this script to generate the create statements

11@@

Using bareword comparison to check PATH variable

12@@

13@@

From Ask Tom

14@@

This example is taken from ReviewLite.

15@@

• fast-dba.blogspot.be

16@@

sed could be shorter but this one works cross-platform

17@@

18@@

If the plustrace (plustrc.sql) role has been granted, explaining sql statements (without running the statement) is as easy as

19@@

20@@

Article showing how to dump blocks also.<br /> Tips and Tricks: Invisible Columns in Oracle Database 12c by Alex Zaballa, Oracle Ace and Daniel Da Meda (OCM)

• Inserting Custom Messages in Oracle Alert/Trace files

Writes to trace file

21@@

Writes to the alertlog

22@@

Writes to the alertlog and trace file

23@@

Also available, KSDIND, KSDDDT and KSDFLS

24@@

if yes, and to commit them…

25@@

Some forgotten SQL*Plus tricks from the good old days and some new ones…

• orafaq.com

26@@

27@@

Use to find the pathnames of all the filesystems/directories in which a database is housed.

28@@

29@@

gives something like this if found…

30@@

31@@

Found these in the log file

32@@

This could be due to a timeout on the pipe.<br /> Increase parameters and restart agent. Add following lines to or.config:

33@@

34@@

• Check the candle user password has not expired in the database.
• There may be a clue in the log file. Check /opt/IBM/ITM/logs/`hostname`_or_${SID}_col.out
• Check limits for itmora account in /etc/security/limits. Should be same as oracle user.
• Check the config file. We had this issue when a new ORACLE_HOME was installed but the cfg file still had the old one in it.

35@@

36@@

Solution:<br />

• Change all occurrences of 11.2.0.1 to 11.2.0.3
• Restart agent

37@@

38@@

Solution:<br />

• Run agent reconfigure to setup the new password for the candle user (tivoli)

39@@

• Restart agent

40@@

This can happen if the server is rebooted before the agents have been added to the itmora list using kdyedit / kciedit

41@@

42@@

Solution: Add these instances to the itmora list

43@@

44@@

Kill any agents still running as root

45@@

Because these agents were owned by root, there will be permissions issues when trying to restart the agents with itmora so these need to be fixed before restarting the agents.<br /> The simplest way of doing this is to run lockdown.

46@@

47@@

Return multiple columns/elements from Oracle to shell script at the same time

48@@

This has been bugging me for years. Something you would think simple… what is ORACLE_HOME? I know it's a question mark at the SQL prompt but how to get it's O/S value?

49@@

or in SQL*Plus

50@@

That got me thinking… if this just gets stuff from the environment, it can fetch any exported variable?!?!<br /> From the shell:

51@@

and now in SQL*Plus:

52@@

Wow!

Depends on where you look but taking the minimum here as “safe”, it should still be limited to 8 characters…

53@@

This is 11gR2

54@@

55@@

or

56@@

57@@

If database is created without dbca (datafile and controlfile copy), no entry will be automatically made in /etc/oratab.<br /> So the problem is that you need to find out which of the ORACLE_HOMEs is being used by the running instances.

• Solaris, Linux

58@@

• AIX

59@@

or<br /> This command (ps eww) gives lots of information about the given process (pmon in this case). Tells you where the instance was started, whether it was started from SQL*Plus or RMAN, the http_proxy and loads more useful bits!

60@@

The underscore matches any single character so to return data containing an underscore means having to use an escape character.<br /> Here I use the backslash(\) so it is easy for Unix people to understand the mechanism.

61@@

62@@

63@@

For one host

64@@

On all hosts at the same time

65@@

If the database is in mount mode, most tables are unavailable. This query uses the x$ (c based) tables and are always available

66@@

• Script to Detect Tablespace Fragmentation ( Doc ID 1020182.6 )
• How to shrink or reduce the datafile size by finding the high water mark (HWM) ( Doc ID 1600774.1 )
• How to find Objects Fragmented below High Water Mark ( Doc ID 337651.1 )

67@@

Runup to this was…

68@@

69@@

70@@

• Using the Oracle Shrink Command - lots of good stuff at this site

Written by Tom Kyte<br /> Depending on the Oracle version, this procedure may or may not work! It does not include the compact clause (neither does it re-analyse to prove it worked).<br /> Here is a worked example that shows the complete process - oracle-wiki.net

71@@

From pouwiel.com

72@@

Be aware that the support document 159377.1 does not speak of the rollback force. If you don’t execute that particular command it will not work. <br />

Permissions problem. Make sure the user has write access to oraclehomeproperties.xml file!

73@@

Change permissions as appropriate. A different approach which should give the same end result would be to grant the orabase executable the setuid bit.

74@@

This allows any user to set the environment as the orabase executable will be run with the permissions of its owner.

Are you getting errors due to partitions belonging to a different tablespace and you want to drop the current tablepace?<br /> ORA-14404: partitioned table contains partitions in a different tablespace<br />

75@@

See which tables have partitions across multiple tablespaces…

76@@

Generate statements to move the partitions from one tablespace to another…

77@@

78@@

Only works from 12c

79@@

Needs a bit of work. Won't work pre-12c obviously and also not on Standby databases if they are in MOUNT mode

80@@

version 2

81@@

This query specifically lists after login triggers

82@@

The network_name column shows what you should find in tnsnames.ora for this db connection

83@@

or

84@@

85@@

86@@

87@@

By default pluggable databases in a container remain in a MOUNT state when the container starts up.

88@@

To modify this, open it and save its state

89@@

To see a log of issues with pluggable databases

90@@

CDB$ROOT is container id 1. User containers start from 2.

91@@

92@@

or just

93@@

94@@

These must be made using a service (defined in tnsnames.ora). Each pluggable database automatically registers a service with the listener (v$services).

95@@

or using ezconnect

96@@

Could be useful for handling line endings…

97@@

98@@

If the answer is 1,7,10,15,16 or 17, then it is 32bit, everything else should be 64bit.

99@@

Before converting to Standard Edition, check the features here - some may be Enterprise specific.

100@@

101@@

or a bit fancier version…

102@@

103@@

Example usage: echo “`ts`: Checking backup status”

104@@

Dropping a database including backups should be considered criminal in a production environment!

105@@

or

106@@

Inline views can be used to update base table data

107@@

A different way to delete rows in base tables, using Inline views or subselect

108@@

109@@

These instructions are for Redhat but other versions will be very similar

• Download rlwrap from http://dl.fedoraproject.org/pub/epel/5/x86_64/repoview/rlwrap.html or http://dl.fedoraproject.org/pub/epel/6/x86_64/repoview/rlwrap.html
• sudo yum install rlwrap
• build a dictionary file for autocomplete on pressing Tab

110@@

111@@

or for general command use…

112@@

Run from customer's management server

113@@

or

114@@

Older systems

115@@

Newer systems

116@@

117@@

Scan the database table version of the alertlog for errors without reporting what was already found.

118@@

Sometimes you need to inject error messages into the alertlog to test your monitoring system. This generates the entries in the alertlog and in x$dbgalertext table.

119@@

This additionally creates a trace file.

120@@

If an ADR error is displayed, then ORACLE_SID is probably not set

121@@

122@@

or

123@@

124@@

or

125@@

Real world example

126@@

• Inspired by oradbatips.blogspot.co.uk

It uses a clever package, dbms_sys_sql.<br /> Also useful for executing anything on behalf of another user.<br /> Here is an example on how to create private database link for a user.

127@@

Here we can generate SQL to rebuild the links for future use. Note the password is no longer stored in this column.

128@@

129@@

Method 1:

130@@

or

131@@

Method 2 (undocumented and cannot therefore be relied on to continue working in the same manner):

132@@

Need to quickly share/copy a file or read an html file on Linux? Start a web server!

133@@

and point your browser to http://localhost:8000<br /> or

134@@

• official guide

One way to do it… use -m(arkup) option to specify:<br /> html on/off - specifies whether to output html output or not head - specify your own customised head contents<br /> spool off - as a part of the -m tag means do not print the default &lt;html&gt;, &lt;head&gt; and &lt;body&gt; tags<br />

135@@

or

136@@

besides html and head, you can also specify:<br /> body - specify your own customised body attributes<br /> table - override the default table options<br /> entmap - turn on or off the html replacement characters (&lt, &gt, etc…)<br /> preformat - uses the &lt;pre&gt; tag to format output exactly as required<br />

• another little gem…

137@@

138@@

Using Perl

139@@

Depending on which way around the divs are, you get different interpretations

140@@

• stackoverflow.com
• A whole page showing how to do it in all versions back to 7!