Tips: Minimum install for Oracle

I'm working currently from my six year old laptop. I needed access to Oracle but I don't have much space, here's what I figure out.

Download Oracle Instant Client, which I found at:
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

To complete the install you'll need to register with Oracle (it's free), if you haven't already.

Unzip the files into c:\oracle, total size about 84 meg.

Modify your PATH environment variable to point to c:\ORACLE.

Add TNS_ADMIN environment variable to point to C:\ORACLE.

Create a text file called C:\ORACLE\SQLNET.ORA with the following contents:
NAMES.DEFAULT_DOMAIN = world
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Create (or copy from someplace) a text file called c:\ORACLE\TNSNAMES.ORA with contents like:
ABC123.WORLD=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(COMMUNITY= tcp.world)
(PROTOCOL= tcp)
(HOST= site.com)
(PORT= 1521)
)
)
(CONNECT_DATA= (SID= abc123))
)
Now, in my minimum install I'm going to use Python, so I'll need cx_Oracle.

Write a program like this (say select.py):
import cx_Oracle

aTSN = 'abc123'
user = 'scott'
password = 'tiger'
conn = cx_Oracle.connect(user, password, aTSN)

cur = conn.cursor()

cur.execute("SELECT * from MYTABLE")
for row in cur:
print row


From what I've gathered cx_Oracle uses the oci.dll which is found via the PATH environment variable. This dll looks at TNS_ADMIN and loads up the SQLNET.ORA file looking for NAMES.DIRECTORY_PATH line, which basically says to use TNSNAMES. Then it knows to look for TNSNAMES.ORA in the same directory and parse that.
Piece of cake.

Comments

Anonymous said…
...molte, molte, molte grazie.

Cosimo
11:12 am
Post a Comment

Popular posts from this blog

Shortest Sudoku solver in Python

Mark Byer's site has some more Sudoku solvers here's a short one in Python that's only 178 bytes long: def r(a):i=a.find('0');~i or exit(a);[m in[(i-j)%9*(i/9^j/9)*(i/27^j/27|i%9/3^j%9/3)or a[j]for j in range(81)]or r(a[:i]+m+a[i+1:])for m in'%d'%5**18] from sys import*;r(argv[1]) On the site is also shown a longer Perl version at 185 bytes: use integer;sub R{for$i(grep!$A[$_],@x=0..80){%t=map{$_/27-$i/27|$_%9/3-$i%9/3&&$_ /9-$i/9&&($_-$i)%9?0:$A[$_]=>1}@x;R($A[$i]=$_)for grep!$t{$_},1..9;return$A[$i]=0} die@A}@A=split//, ;R I think the Python version is slightly easier to understand, although they are both quite cryptic. I'm not sure why I find these programs fascinating. I think it reminds me that any program can be written in such a way that it's cryptic, even in Python. In addition, the code is small enough that you should be able to figure out how it works, and may learn something the process. Related is: how t...
Read more

wny am I happy about the death of some people?

Unfortunately, I'm staring to be happy that certain people have died.  Like Fred Koch and, more recently, Donald Rumsfeld.. Frankly these are both people that should be celebrated for dying and not continuing the evil they perpetrated. More succinctly, they should be remembered for doing more evil than good during their lifetime and it is overall better that they have died than live a minute longer on this earth. These people can't repent but others (like Mitch) should link about their legacy. How many of us will be so happy that they are dead. Donald isn't the worst of them, but should be remembered for all of the evil that they have committed.
Read more