Monday, May 23, 2005

Enterprise Security II: Finishing the database install

Right - teatime is over. The script ran to completion, only thing left is to set up the network; specifically listener.ora and tnsnames.ora (anyone wants an LDAP server instead?).

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /o/oracle10/10gR1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = o10gR1)
(ORACLE_HOME = /o/oracle10/10gR1)
(SID = o10gR1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS = (PROTOCOL = IPC)(KEY = o10gR1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = csdb01.cs.nl)(PORT = 1522))
)
)
)

The blue text signifies the additions and modifications to the listener.ora file; the only modification is the port, 1522, in setad of the standard 1521. Port 1521 is used by the oracle 9 Release 2 installation, and I wanted to keep those installations separated.
The tnsnames.ora has no entries (apart from an extproc, you may want to delete), so all this is new:

o10gR1 =
(description =
(address = (protocol=beq)(PROGRAM = oracle)
(ARGV0 = oracleo10gR1)
(ARGS = '(DESCRIPTION =(LOCAL = YES)(ADDRESS = (PROTOCOL = BEQ)))'))
(CONNECT_DATA = (SERVICE_NAME = o10gR1.csdb01.cs.nl))
)


I like the bequeth protocol, as it does not require a listener process running, and it is extremely fast - no overhead. I've demonstrated AIX 4.3 and 8i Release 1 with tcp and bequeth, and the tcp output could be seen pausing and resuming, where the bequeth connection just was a blur.
Anyway - tomorrow, I will install the Infrastructure in this database, and configure a repository.

No comments: