Oracle 9i for Linux

1. Run the following command to check whether the development kit has been installed:
Rpm-qa | grep gcc cpp compat-libstdc ++ glibc-devel glibc-kernheaders binutils
2. decompress the package
Zcat Linux9i_Disk1.cpio.gz | cpio-idmv
Zcat Linux9i_Disk2.cpio.gz | cpio-idmv
Zcat Linux9i_Disk3.cpio.gz | cpio-idmv
3. Set Kernel Parameters
Vi/etc/sysctl. conf, add the following parameters
Kernel. shmmax = 4294967295 memory 512 M
Calculation method: kernel: shmmax = 1024*1024 * RAM (M)/2
Run sysctl-p.
4. Create a data directory and user
Groupadd dba
Groupadd oinstall
Useradd-g oinstall-G dba Oracle
Passwd oracle

Mkdir/opt/oracle
Mkdir/opt/oracle/product
Mkdir/opt/oracle/product/9.2.0
Chown-R oracle. oinstall/opt/oracle
Mkdir/var/opt/oracle
Chown oracle. dba/var/opt/oracle
Chmod 755/var/opt/oracle
5. vi. bash_profile setting Variables
Export LD_ASSUME_KERNEL = 2.4.1
Export ORACLE_BASE =/opt/oracle
Export ORACLE_HOME =/opt/oracle/product/9.2.0
Export ORACLE_SID = ora9i
Export ORACLE_TERM = xterm
Export TNS_ADMIN =/network/admin
Export NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Export ORA_NLS33 =/ocommon/nls/admin/data
LD_LIBRARY_PATH =/lib:/usr/lib
LD_LIBRARY_PATH =:/usr/local/lib
Export LD_LIBRARY_PATH

Export PATH =/usr/local/bin:/usr/bin:/bin
CLASSPATH =/JRE:/jlib:/rdbms/jlib
CLASSPATH =:/network/jlib
Export CLASSPATH

 

###############
Change or disable the ftp and http ports of Oracle XDB
Starting from Oracle 9i, XDB features are included by default during database creation. Once the database and Listener are started, the http service of Oracle XDB occupies port 8080, which is in conflict with default ports such as JBoss and Tomcat. Therefore, there must be one change. It's easy to change Tomcat, but I don't know how to change the XDB configuration at the moment.
Search on Google and find the answer. The port settings of Oracle XDB are not in the configuration file, but in the database. There are three methods to modify the http and ftp service ports of XDB:
1. Use sys to log on to Oracle and use dbms_xdb to modify port settings
SQL> -- Change the HTTP/WEBDAV port from 8080 to 8081
SQL> call dbms_xdb.cfg_update (updateXML (
2 dbms_xdb.mongo_get ()
3, '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text ()'
(4, 8081 ))
5/
Call completed.
SQL> -- Change the FTP port from 2100 to 2111
SQL> call dbms_xdb.cfg_update (updateXML (
2 dbms_xdb.mongo_get ()
3, '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text ()'
(4, 2111 ))
5/
Call completed.
SQL> COMMIT;
Commit complete.
SQL> EXEC dbms_xdb.mongo_refresh;
PL/SQL procedure successfully completed.
2. Use the OEM console and select Database, XML Database, and Configuration. Modify the settings of XDB.
3. Removing the database initialization parameter: dispatchers = '(PROTOCOL = TCP) (SERVICE = XDB)' will disable the http and ftp services of XDB.