Jump to Navigation

284 - How to fix ORA-01652

You encounter ORA-01652 while rinning a long SQL.

ORA-01652: unable to extend temp segment by string in tablespace string.

Cause: Failed to allocate an extent of the required number of blocks for a temporary
segment in the tablespace indicated.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

1. Add a new file to the tablespace.

283 - IP Masquerade

IP Masquerade is also known as Network Address Translation (NAT) and Network Connection Sharing some other popular operating systems.
It is basically a method for allowing a computer that doesn't have a public Internet wide IP address communicate with other computers on the Internet
with the help of another computer sitting inbetween it and the Internet.

282 - NAT configuration on iptables

Iptables is used to set up, maintain, and inspect the tables of IPv4 packet filter rules in the Linux kernel.
Several different tables may be defined. Each table contains a number of built-in chains and may also contain user-defined chains.

Each chain is a list of rules which can match a set of packets. Each rule specifies what to do with a packet that matches.
This is called a 'target', which may be a jump to a user-defined chain in the same table.

1. Configure NAT PREROUTING by command.

281 - Create Private CA (Certificate Authority)

For a web-server to be able to accept 'https://' requests, a private/public key-pair (for Apache2 w/ mod_ssl) needs to be generated
and stored in the proper location(s). To create a self-signed private/public 1024 bit key-pair that will be valid for 365 days...

1. Create a private CA

280 - CUPS Cancel Print Jobs

If you are using CUPS, sometimes you want to cancel some print queues. So "lprm" is a useful command for that.

lprm will remove a job, or jobs, from a printer’s spool queue. Since the spooling directory is protected from users, using lprm is normally the only method by
which a user may remove a job. The owner of a job is determined by the user’s login name and host name on the machine where the lpr(1) command was invoked.

 lprm [-Pprinter] [-] [job # ...] [user ...]

Options and arguments :

Shell Script:

279 - Monitor Open File

It is easy to remember lsof command if you think of it as “ls + of”, where ls stands for list, and of stands for open files.
It is a command line utility which is used to list the information about the files that are opened by various processes. In unix, everything is a file,
( pipes, sockets, directories, devices, etc.). So by using lsof, you can get the information about any opened files.

Simply typing lsof will provide a list of all open files belonging to all active processes.


278 - DMZs and iptables

iptables rules can be set to route traffic to certain machines, such as a dedicated HTTP or FTP server, in a demilitarized zone (DMZ) - a special local
subnetwork dedicated to providing services on a public carrier such as the Internet.

For example, to set a rule for routing incoming HTTP requests to a dedicated HTTP server at (outside of the range of the LAN),
NAT calls a PREROUTING table to forward the packets to their proper destination :

277 - Configure Apache Reverse Proxy Server

Apache can be configured in both a forward and reverse proxy (also known as gateway) mode.

A reverse proxy (or gateway) appears to the client just like an ordinary web server.
No special configuration on the client is necessary. The client makes ordinary requests for content in the name-space of the reverse proxy.
The reverse proxy then decides where to send those requests, and returns the content as if it was itself the origin.

276 - Apache Version on Oracle EBS

Here is a quick way out to find the Apache version on EBS R12, Oracle HTTP Server (OHS) 10gAS and 11g.

You can get it on the Apache installed in Linux server like the following.

# httpd -version

Server version: Apache/2.2.3
Server built:   Jan  5 2012 10:06:14

* Oracle EBS R12


275 - Apache 301 How to redirect

Search engines consider http://mydomain.com and http://www.mydomain.com different websites.
As a result, if your website has been linked to from other websites using a mix of the two URLs you are effectively
splitting the potential benefit of valuable link popularity.


Subscribe to LAMP, Database and Cloud Technical Information RSS

Main menu 2