Displaying keyword search results 1 - 10
Created by Dr. Xi on February 06, 2012 12:14:11 Last update: February 07, 2012 15:39:35
Oracle sqlplus command line tools does not support command line editing out-of-the-box. But on Linux there's a handy utility that enables command line editing with any command line tool: rlwrap - readline wrapper. Install rlwrap:
$ sudo apt-get install rlwrapCreate a keywords file .sql.dict (optional, but convenient):
false null true access add as asc begin by chec...It would be nice to add the tables names also. Create an alias for sqlplus (put it in .bashrc ):
alias sqlplus='rlwrap -f $HOME/.sql.dict sqlplus'
Created by Dr. Xi on February 06, 2012 09:20:20 Last update: February 06, 2012 09:20:20
This is the error message:
Error 6 initializing SQL*Plus SP2-0667: Message...It might be that the ORACLE_HOME environment variable is not properly set or a missing sp1<lang>.msb (for example sp1us.msb ) file. But for my Ubuntu system, there was no such thing as sp1<lang>.msb , and it wasn't caused by a missing ORACLE_HOME . The error was resolved after I restored the shared library file libsqlplusic.so .
Created by Dr. Xi on February 06, 2012 09:19:27 Last update: February 06, 2012 09:19:27
These are the steps to install the Oracle sqlplus command line utility on Ubuntu Linux: Get Oracle instant client packages from Oracle (you'll need basic or basiclite + sqlplus). Install the RPM files with alien :
$ sudo alien -i oracle-instantclient11.2-basic-11....Install Oracle shared libraries: create file /etc/ld.so.conf.d/oracle.conf and add this line:
Created by Fang on September 07, 2009 20:44:15 Last update: November 03, 2011 14:43:19
Step 1: Repackage a web app as EAR A Java EE application is a multimodule Maven project. At the very least you'll need to package a WAR and an EAR. To get started, I'll simply re-package the simple webapp as an EAR. Create a directory named javaee-app Copy the webapp from here to javaee-app . Rename struts1app to webapp . Create pom.xml under javaee-app :
<project> <modelVersion>4.0.0</modelVersion>...Create a directory named ear under javaee-app . Create pom.xml under ear :
<project> <modelVersion>4.0.0</modelVersion>...Modify pom.xml in the webapp directory so that it looks like this:
<project> <modelVersion>4.0.0</modelVersion> ...Build with " mvn package " in the javaee-app directory. You can see that ear-1.0.ear is successfully generated in javaee-app/ear/target . Maven successfully resolves dependencies between the sub-projects....
Created by Dr. Xi on August 11, 2007 15:56:47 Last update: July 19, 2011 08:15:55
Here's a list of common TCP ports. You can find a more complete list here: http://www.gasmi.net/docs/tcp.html . Port Number Service Description 21 FTP File Transfer Protocol 22 SSH Secure Shell 23 Telnet Telnet remote login 25 SMTP Simple Mail Transfer Protocol 70 gopher Gopher 79 finger Finger 80 HTTP Hyper Text Transfer Protocol (WWW) 88 Kerberos Kerberos authentication 94 tivoli Tivoli Object Dispatcher 110 pop3 Post Office Protocol Version 3 123 ntp Network Time Protocol 137 netbios NetBIOS Name Service 138 netbios NetBIOS Datagram 139 netbios NetBIOS Session 143 imap Internet Message Access Protocol 161 snmp Simple Network Management Protocol 162 snmptrap SNMP trap 194 irc Internet Relay Chat Protocol 389 ldap Lightweight Directory Access Protocol 443 https Secure HTTP 445 SMB MS Server Message...
Created by Dr. Xi on January 07, 2010 23:40:28 Last update: February 09, 2010 03:24:35
This is a utility to generate SQL insert statements for Oracle for one table, or a set of tables. It doesn't cover all possibilities but should be good enough for most cases.
import java.io.*; import java.sql.*; import ...To generate insert statements for multiple tables, simply put the table names in a file, one per line, and use the -f switch.
Created by Dr. Xi on February 06, 2010 00:38:29 Last update: February 06, 2010 00:39:01
From Oracle doc: DBA_FREE_SPACE describes the free extents in all tablespaces in the database. Note that if a datafile (or entire tablespace) is offline in a locally managed tablespace, you will not see any extent information. If an object has extents in an online file of the tablespace, you will see extent information about the offline datafile. However, if the object is entirely in the offline file, a query of this view will not return any records.
SQL> select tablespace_name, count(*) free_extends...
Created by Dr. Xi on December 16, 2008 21:17:15 Last update: December 16, 2008 21:19:04
The -h switch prints file or directory sizes in human readable format:
# disk usage for current directory $ du -ks...
Created by Dr. Xi on October 15, 2008 19:49:31 Last update: October 15, 2008 19:49:31
<?xml version="1.0"?> <project name="OC4JDe...Deployment properties:
# Deployment properties targetenv=Development ...
Created by Dr. Xi on October 08, 2008 19:33:21 Last update: October 08, 2008 20:17:42
In sqlnet.ora , there's a parameter named NAMES.DEFAULT_DOMAIN that usually contains the value world . If you remove this parameter then you don't need to append .world . My sqlnet.ora contains three lines:
# sqlnet.ora Network Configuration File: C:\wo...To force a lookup without NAMES.DEFAULT_DOMAIN appended, append a dot to the tnsname: