Oracle8i installation under Linux (Chinese)
Sites from Flyfox
Published: January 4, 2001
Details: Preparation - Installing the Oracle Server I think Microsoft Windows is a nice operating system. It has received unprecedented success in the market, and it has also made Gates, Balmima, etc. Hundreds of millions. It is easy to use, it has been widely popular, almost every computer enthusiasts will operate Windows, almost every programmer will be programmed. Currently in order to occupy the market, the Windows2000 is excluded from the PC's pre-installed cost from the previous Windows 9X 65 $, but Sun's Solaris8 (support IA-64) is also airy! In short, the free software era The footsteps seem to be able to hear! The engineers in the computer industry are mainly earned by the technology. My article is to summarize some simple experience based on "free / free" Oracle On Linux. If you like it, I admitted my labor. If you have time to give me a supplementary suggestion, then I am more happy. Disclaimer: This article can be reproduced, but the author should be ascertained. The version number: Oracle8i HowTo V.66 Published: 2000.2.9 Author: Jiangsu Taicang Poly Ding Gang uudingju@public1.sz.js.cn -------------------- -------------------------------------------------- ---------- Now, you have to install Oracle servers on Linux, please pass the following 5: System Requirements Hard Drive Creating User Creating Directory Settings Parameters 1. System Requirements Prerequisites are capable of installing Linux, The following hardware requirements should then be met: Memory Requirements Memory minimum 128 MB RAM. More (256MB ) Memory can improve performance, more options (jserver ..), more users need more memory !! Swapspace suggestion 2 times memory CD-ROM Oracle uses ISO 9660 format CD-ROM, download and installation can be omitted. Hard disk requirements - Oracle8i EE Oracle8i Client Minimum 660 MB N / A Typical 811 MB 306 MB Operating System Linux Kernel 2.2 Operating System Library - Glibc Package V2.1 2. Planning Hard Disks For 10 or less, you can use a hard disk To establish an Oracle partition (or directory), just ensure that the remaining disk space is 1500MB , you can install Oracle8 (without Intermediate, JServer, etc.). However, if Oracle8i is selected, I am afraid to support a larger application. The best Intel hardware combination with Oracle8i should be: 2XCPU PIII (L440GX motherboard), 512MB ECC, 3 SCSI hard drive (assembly reference price: 40,000 yuan) 3 SCSI hard disk planning should be: # 1 operating system Access, life long # 2 Oracle Software System Data System, Tools, RBS, TEMP, USER, etc. Space Read more, change, no big change # 3 User Data Read / write frequent, often backup About fault tolerance: three log files, control Documents should be distributed separately on three hard drives, or have a backup server, regularly update the data over the network over the network through FTP, Samba, etc.
The usual database application is such a structure: all of the data is made by DBO. In this user development program, create a variety of read and write roles, authorize the synonym of the table to create a table, usually a batch of data for public synonym Users, teach some kind of read and write role, therefore, an Oracle application data is usually in a table space -> 1-2 data files -> 1 hard disk !! If there is another application to add hard drives. 3. Creating a user and user group recommending the Kuser tool using the graphical interface, namely: KDE - User Manager first built group DBA, Oper, then built users "Oracle", shell = / bin / sh, group = dba, set passwd = ** **** Usually, users "Oracle" have database software installation, upgrade and other administrative privileges. On your Oracle8i server, it is even more important than root users !!! You can log in to Linux from the character interface, then run Oracle Database Services! This saves memory. 4. Create a directory Recommend the home DIR or KDE of the graphical interface Gone, which will make it easier to complete the following features.
Root Create Oracle Dibratory Point: Root $ MKDIR / U01 or directly to make a hard disk partition / U01 Authorized others read and write: root $ chmod 755 / u01 or change the owner directly: root $ chown oracle.dba / u01 Oracle Continue to create a directory , According to Oracle habits: Oracle $ MKDIR / U01 / App Oracle $ MKDIR /U01/app/oracle/Product/8.1.5 Tips: Create a directory alias (symbolic connection) to quickly and good memory: root $ ln -s / u01 / App / ORACLE / PRODUCT / 8.1.5 / ORA ROOT $ ln -s / home / oracle / ORAME 5. Setting parameters Edit. Bash_profiile, saved as .profile [Oracle @ Lin Oracle] $ more .profile #. Bash_profile # get the aliases and functions if [-f ~ / .bashrc]; Then. ~ / .bashrc Fi # user specific Environment and Startup Program Path = $ PATH: / ORA / BIN: $ HOME / BIN BASH_ENV = $ HOME / .bashrc USERNAME = "oracle" ORACLE_HOME = / ora; export ORACLE_HOME LD_LIBRARY_PATH = / ora / lib; export LD_LIBRARY_PATH ORACLE_BASE = / u01 / app / oracle; export ORACLE_BASE ORACLE_SID = ora8; export ORACLE_SID ORACLE_TERM = 386; export ORACLE_TERM TMPDIR = / var / TMP; Export Tmpdir # umask 022 (Only if umask does not default to 022) Export usrname bash_env path Check the parameter setting: [Oracle @ Lin ORAINST0] $ env username = Oracle Oracle_sid = ORA8 LD _Library_Path = / ORA / LIB ORACLE_BASE = / U01 / App / Oracle Bash_ENV = / Home / Oracle / .bashrc Oracle_Term = 386 Display = 172.17.2.22: 0.0 Oracle_Home = / ORA Next to perform installer (KDE or ANOTHERLEVEL) Can't install from Gone!) First installed JRE, Java Runtime Environment, version = JRE116V5, with / usr / local / jre => point to the JRE116V5 you install, then Oracke815 patch. Pay attention to the "Display" setting problem when installing.
Don't worque, 40 minutes after installation of basic parts, 10 minutes to install the patch, and finally create the database! Preparation Software 1) CD Installation First To load the disc, you can simply execute the command: mount / mnt / cdrom or use the KDE graphical interface, execute fsconf ==> acsee local driver ==> / dev / cdrom ==> mount !! Here, you must first install JRE (Jave Run Environment) 116V5, ready Oracle815Patch_ee (Enterprise Edition Patch 8/27/99 6, 4M). 2) Download method: a total of 3 files to download (reference: detailed download address) JRE 116V5, Java operating environment (6M jre_1.1.6-v5-glibc-x86.tar.gz) Oracle815 EE, Enterprise Edition (07/19 / 99 256M 815Ship.tgz) Oracle815Patch_ee, Enterprise Version Patch (08/27/99 6, 4M Linux_81501Patch_ee.tgz) Copy the downloaded compressed file into an empty folder, then decompress it: JRE: Try FTP: //ftp.progsoc.uts.edu.au/pub/linux/java/jdk-1.1.6/i386/glibc/v5/6,292,578 jre_1.1.6-v5-glibc-x86.tar.gz copied to the empty directory, then Unlock, tar-xvzf jre_1.1.6-v5-glibc-x86.tar.gz connection / copy / renamed new JRE116V5 directory for / usr / local / jre Oracle815 EE, Enterprise CP 815Ship.tgz / Home / Oracle / ORAINST0 / Cd / home / oracle / orap.tgz. Oracle815patch_ee, Enterprise version Patch CP Linux_81501patch_ee.tgz / home / oracle / patche / cd / home / oracle / patche / tar -xvzf Linux_81501patch_ee.tgz. 4. Execution Installer (requires KDE or ANOTHERLEVEL, can't install from Gone!) First installed JRE, Java Runtime Environment, version = jre116v5 with / usr / local / jre => point to your installed JRE116V5 million, don't worry, 40 minutes finished Basic part, 10 minutes to install the patch, and finally create the database! Installation Process: From the Setting XWindow Start Installation Recommended KDE interface, if the Oracle user is also logged in to install on the server, root makes XWindow display, I have encountered a "Display" setting problem during installation.
[root @ Lin / root] $ XHOST 172.17.2.22 172.17.2.22 Being added to access control list See the added information above, Oracle users can install this: [Oracle @ lin ORAINST0] $ ./runi* Initializing Java Virtual Machine From / usr / local / jre / bin / jre. please wait remote to log in to the server, such as executing from 172.17.2.21, should [Oracle @ lin ORAINST0] $ XHOST 172.17.2.21 172.17.21 Being of course, added to access control list previously defined in claim DISPLAY = 172.17.2.22: 0.0 a: [oracle @ lin orainst0] $ DISPLAY = 172.17.2.22: 0.0 [oracle @ lin orainst0] $ export DISPLAY is also performed runInstaller [oracle @ lin orainst0] $ ./runi* initializing java virtual machine from / usr / local / jre / bin / jre. please wait ... Installation option is typically installed, and finally prompts the DBCA database assistant to install "imperfect", but you can continue to use; Minimize Installation, do not try to generate a database from the DBCA database assistant, as you can also install "patch" in advance; custom installation, if you are very skilled, you can pick parts, you can also install "patch" first. Installing patch [Oracle @ Lin Patche] $ ./linux* here also has a lot of error prompts, which determines if it continues to install by checking the number of subdirectory files, so you must not move its files. Several questions ---- If you encounter a installation problem, please contact my parameter table, then look at my parameter file "Environment Variables .profile", it is changed from .bash_profile editing.
[Oracle @ lin orainst0] $ env USERNAME = oracle HISTSIZE = 1000 HOSTNAME = lin.tcyy.com LOGNAME = oracle ORACLE_SID = ora8 HISTFILESIZE = 1000 MAIL = / var / spool / mail / oracle LD_LIBRARY_PATH = / ora / lib ORACLE_BASE = / u01 / App / Oracle Term = ANSI HostType = i386 Path = / usr / bin: / usr / local / bin: / bin: / usr / bin: / usr / x11r / bin: / ora / bin: / home / ora Cle / Bin Kdedir = / usr home = / home / oracle INPUTRC = / etc / inputrc shell = / bin / sh ps1 = [/ u @ / h / w] / $ user = Oracle TmpDir = / VAR / TMP BASH_ENV = / HOME / Oracle / .Bashrc Oracle_Term = 386 Display = 172.17.2.22: 0.0 Oracle_Home = / ORA OSTYPE = Linux SHLVL = 1 _ = / usr / bin / ENV Settings "Environment Variables Profile .profile" It is called from .bash_profile editing . [Oracle @ lin oracle] $ more .profile # .bash_profile # get the aliases and functions if [-f ~ / .bashrc]; Then. ~ / .bashrc Fi # user specific Environment and startup programs path = $ PATH: / ORA / bin: $ HOME / bin BASH_ENV = $ HOME / .bashrc USERNAME = "oracle" ORACLE_HOME = / ora; export ORACLE_HOME LD_LIBRARY_PATH = / ora / lib; export LD_LIBRARY_PATH ORACLE_BASE = / u01 / app / oracle; export ORACLE_BASE ORACLE_SID = ora8; Export Oracle_sid Oracle_Term = 386; Export Oracle_Term Tmpdir = / var / tmp; Export TmpDir # umask 022 (Only if umask does not default to 022) Export username bash_env path installation process, it requires root users to perform root.sh, you must first Modify read and write permissions: [root @ Lin / Ora] $ chmod 750 root.sh [root @ Lin / Ora] $ ./root.SH program execution result, generated one of the following files / etc / oracab: [Oracle @ lin Oracle ] $ more / etc / oracab # *: / u01 / orahome1: n # Orcl8: / u01 / orahome1: y ora8: / ora: y it means defining the name of the automatic startup (ORA8), DBSTART, DBSHUT also wants this Parameters, otherwise you have to use svrmgrl to startup.
Note To simplify the name of the directory, I tried symbol join: / ora-> /u01/app/oracle/product/8.1.5 / orame -> / home / oracle, Oracle software installation, you can try assistant from DBCA Database Generate a database: [Oracle @ Lin / Ora] $ ./bin/dbass* Create Database Description: The experience here is to reload the Oracle -> Jian Library -> WebDB, carefully conclude, and installation software is very At the time of time, more than 6 hours. Here, talk about the explanation of several terms first. Online transaction processing OLTP / decision support, the former is used for small and more real-time processing, the latter is used in a large statistical query. Concurrent user / concurrent connection, the number of users connected to the same / the same user is connected at the same time. Log file, redolog, used to redo database control files, Control, record the running status. Table space / file / table / data indicates the database structure of Oracle. Creating a database According to ORACLE, creating three ways: 1) Installing 2) After installing 2) After installing DBCA Create 3) Use Manual Command Details (Personal Experience): Method 1 No, Oracle also said that the installation process does not create a database , Just start the database to create the assistant DBCA, but you don't believe it, it will not pass, because you must install the patch before you create the database, that hates the thing. Method 3 is too difficult; method 2 is best! Method 2 Use a graphical tool: Database Create a Assistant DBCA, you can enter or select parameters step by step, minimize the installation of 40 minutes, standard size is completely installed for 90 minutes (Run 3-500 / 192MB memory), usually More than 2 hours. Tool usage: Start DBCA [Oracle @ Lin / ORA] BIN / DBAS * Note: Customize the location, size, and growth mode of the parameter database file of the database. For example: system = /u01/app/oracle/oradata/ora8/oSys01.dbf 188M Next 100K users = /Home/oracle/oradata/ora8/orausr01.dbf 20M next 128k Reset character set default = US7ASCII, request Windows The client registry corresponds to the corresponding, otherwise garbled, hkey_local_machine /software/oracle/nls_lang=american.America.us7ascii is actually, and most of the Oracle client supports Chinese, even as the default value. And, if Oracle WEBDB develops a Chinese e-commerce site, your English is not a problem; but to promote webDB as a management tool to a small company Oracle DBA, it is not always the English face, so you should choose China's Chinese standard character set zHS16GBK (China's simplified Chinese characters 16 national labels), the corresponding client is configured to: hkey_local_machine / software / oracle / nls_lang = Simplified Chinese_China.zHS16GBK, National Chartset is a national language, preparing for Nchar.
Server Successful Case Server Minimize Installation, Compatible = 8.0.5, do not choose (option); minimize installation, change compatibility = 8.1.0, start DBCA to modify the database, add 4 parts other than InterMedia (because Intermediate needs to be pre-loaded into a single product in /ora/ord/adu ,. Otherwise, * .sql, *. plb can't find it, if you have these InterMedia products, you can use DBCA to modify the database, add these Option, and need to change compatibility = 8.1.5 in advance), installation success; custom installation, software system and database files are installed on different hard disks, and change file size, growth mode, character set = zhs16GBK, (Oracle suggestion " Character set = zhs16cgb231280), successful installation; WebDB success case server character set = US7ASCII, the client is zhs16GBK or WE8ISO8859P1, WebDB is also successful, but only operates with Opera3.6, attached Simplified Chinese in Microsoft IE5 browser For ????? I was garbled, so I was judged because windows.zhs16GBK ==> Oracle.us7ascii7bit) error. Minimize installation, is compatible with 8.0.5, language is zhs16GBK, but do not choose any additional language, this time the browser can only display English, will not display Chinese according to the default language of the browser; WebDB's ideal realm: Server is medium installation (ie, compatible 8.1.0), C / S language is zhs16GBK, add additional language for your browser, and browser language display / English is completely normal. Some empirical character sets are consistent, either US7ASCII, or ZHS16GBK. Remember: Oracle for Windows English character set is WE8ISO8859P1, not the default character set for Oracle Server for Linux / UNIX US7ASCII. Similarly, Oracle for Windows's recruit character set is zhs16GBK, not the default character set of Oracle Server for Linux / UNIX zhs16cgb231280, but zHS16GBK is compatible with zhs16cgb231280. Chinese / English character set conversion will affect efficiency, it is best to choose complete Chinese. When you install webDB, be sure to create a new directory and home, and if you select the additional language (simplified chinese), the character set is required. For example, your WebDB for Winnt4 is WE8ISO8859P1, then you can't add additional language Simplified Chinese to the Oracle.us 7ASCII server, because US7ASCII and WE8ISO8859P1 can only exchange 7-bit character sets such as English or French. The following ideas is also inventory: custom installation WebDB2.1, after installing SQLPlus, SupportFiles, and Net8, modify the character set as the database server, then install WebDB2.1 and Listener to add additional language simplified Chinese. However, each When you start the installer, you have to set a character set and simultaneously use the variable for the entire installation process, so it is impossible to change the character set in the middle and make it effective.
Transplanting a product: Your Windows NT4 has WebDB2.1, but there is a Navigator in Personal Oracle is very easy, then you can find Nav8.exe, Nav8cmd.dll, NavrSus.dll (English support), Navrszhs.dll (Chinese Support) A total of 4 files are copied to the current [ORAWEB21] / bin, you can use the "Oracle8 Navigator": Add Nav8.exe shortcut to the desktop or menu directory. Think about it: Your Windows NT4 has Personal Oracle (just part of the product or other), can you load a web service in its directory? Even if you don't choose additional language support. Hand-building library focus discussion method 3: You need better Linux and Oracle foundations, or to be happy, increase confidence.
Please refer to the help literature: [Oracle @ Lin Oracle] $ more / oracle @ Lin Oracle] $ more / read * First define parameters such as Oracle_SID, Oracle_Home, write parameter file $ Oracle_home / dbs / init.ora to db_name, instance_name and service_name Slightly modify SET compatible = "8.1.5" sequentially perform the following command script: crdb1.sh | crdb2.sh | - to create Database Files, Data Dictionary Views crdb3.sh | and add pl / sql support replicate.sh - - Advanced Replication Option ORDINST.SH | __ Oracle Intermediate IMEDIA.SH | DRSYS.SH | __ Oracle Intermediate Text Context.sh | java.sh --- Oracle JSerVer Spatial.sh - ORACEL Spatial TimeSeries.sh - ORACEL TimeSeries Virage.sh --- Oracle Visual Information Retrieval Sqlplus1.sh | Sqlplus2.sh | - Demos and SQL * Plus Help Tables SQLPLUS3.SH | You don't have to perform all in turn, I am in the database to create assistant DBCA is only 1) 2) ) 1) The first three scripts (crdb1.sh, crdb2.sh and crdb3.sh) would create a database and 2) the scripts sqlplus1.sh, sqlplus2.sh and sqlplus.sh would create some demo tables. Once the database is Created, You Could Run Other Scripts Mentioned Above To Use the Respective 8i Feature, 3) EG, for Jserver, run the java.sh script 4) To enable Oracle Intermedia Text, run the scripts -.. drsys.sh and context.sh, in this order only 5) Similarly, for Oracle Intermedia, run ordinst.sh followed by imedia Below is a parameter file I generated by "Database Creating Assistant DBCA": [Oracle @ Lin / ORA] $ More DBS / Initora8.ora Instance_name = ORA8 Control_Files = ("/ U01 / App / Oracle / ORADATA / Ora8/control01.ctl "," /u01/app/oracle/roadata/ora8/control02.ctl ") Processes = 50 log_buffer = 163840 # audit_trail = false # Audit and Intermediate software system has vulnerability rollback_segments = (R01, R02 , R03, R04) // Remember to remove "#" compatible = "8.0.5" // According to the content, Compatible can be 8.1.0, 8.1.5,
Modify the database method: DBCA [Oracle @ Lin / ORA] BIN / DBAS * Database System Management ---- Start / Close Oracle This article tells one of the three core tools of Oracle: SVRMGRL, one, first introduce a simple method : Using the System Command Switch Database 2, detail the server management core tool SVRMGRL three, SQL * Plus section management task, test database Oracle Normal work requires startup two services: Database server instance, database SQL * Net8 service. For information on SQL * NET8 services, please refer to the associated superpariance of LSNRCTL (Net8). I. Simple and method: Using the System Command Switch Database 1) Starting Server DBSTART 2) Close Server DBSHUT 3) Network Listening Services (please join) LSNRCTL 1) Start Server [Oracle @ Lin / ORA] $ dbstart This command verifies user identity After calling the SVRMGR tool, complete the process: Enable the default parameter file INIT
2) Close the server [Oracle @ Lin / ORA] $ dbshut This command checks the user identity, calls the SVRMGR tool, completes the process: SVRMGR> Connected. SVRMGR> Database Closed. Database Dismounted. Oracle Instance Shut Down. SVRMGR> Server Manager Complete Database "ORA8" SHUT DOWN. 3) Network Listening Service Start: LSNRCTL Start Stop: Lsnrctl Stop 2, Advanced Tools: Detail SVRMGRL Startup Method: [Oracle @ Lin / Ora] $ SVRMGRL Oracle Server Manager Release 3.1.5.0.0 - Production Oracle8i Enterprise Edition Release 8.1.5.0.1 - Production with The Partitioning and Java Options PL / SQL Release 8.1.5.0.0 - Production How to get help to add HELP, get: The following is a simple grammatical description, please please look Oracle Server Manager User's Guide SVRMGR> help STARTUP [DBA] [FORCE] [PFILE = filespec] [EXCLUSIVE | SHARED] [MOUNT dbname | OPEN dbname] [NOMOUNT] SHUTDOWN [NORMAL | IMMEDIATE | ABORT] MONITOR For graphical modes only , Bring Up A Monitor Archive Log [Start] [STOP] [List] [Next] [
/ora/dbs/initora8.ora open ora8 ORACLE instance started. Total System Global Area 23670160 bytes Fixed Size 64912 bytes Variable Size 6656000 bytes Database Buffers 16777216 bytes Redo Buffers 172032 bytes Database mounted. Database opened. test you, take a look at the database System file: SVRMGR> Select * from system.sysfiles; tsname fname blocks ------------------------------------------------------------------------------------------------------------ --------------------------------------------- System / U01 / App / ORACLE / ORADATA / ORA8 / System01.dbf 89600 OEM_Repository /u01/App/Orcle/oradata/ora8/oemrep01.dbf 2560 RBS / Yu01/app/oRacle/Ordata/ora8/RBS01.DBF 6144 TEMP / U01 / App / Oracle / ORADATA / ORA8 / TEMP01.DBF 5120 Users /u01/app/oracle/radata/ora8/Users01.dbf 5120 Indx /u01/app/oracle/oradata/ora8/indx01.dbf 5120 6 Rows SELECTED. Well, it feels good , I will, thank you. Let's take a break now. SVRMGR> EXIT Server Manager Complete. 3, SQL * Plus section management task, test database When you use the database for the first time, it has at least two administrator accounts: sys / change_on_install, don't be like the previous, give one yourself I don't know the password. Remember: When you install WebDB, you need it. The default administrator of the System / Manager system, remember to build a tooltural table, as a provincial space: Tools. Now try sqlps: [Oracle @ Lin / Ora] $ SQLPLUS System / Manager SQL * Plus: Release 8.1.5.0.0 - Production on Sun Nov 7 10:08:30 1999 SQL> Select * from Tab; SQL> Select * from sys.tab; sql> EXIT finally mentioned, Oracle Linux requires memory 128MB, If you run the Apache web process, you need memory.
[Oracle @ Lin / ORA] $ free Total Used Free Shared Buffers Cached Mem: 192984 116904 78064 - / Buffers / Cache: 33188 159796 SWAP: 530104 0 530104 Oracle Net8 Network Configuration and Joint 1) Server-side Configuration Listener: Add Listener, Settings Select Database Name Mode, Fill in 2 Parameters {HomeDir = / ORA /, SID = ORA8} 2) Start NET8 Services LSNRCTL START 3) Stop NET8 Services LSNRCTL Stop 4) Parameter File Summary 5) Client Configuration: Add Net Service Name, same format as Windows client 1) Server-side configuration listner: Execute / ORA / BIN / NetAsst fill in the description -> preferred Oracle service:. Protocol = TCP. Host = 172.17.2.22.
Port = 1521 View generated net8 server configuration file: listener.ora [Oracle @ Lin admin] $ more listener.ora # listener.ora configure file: /ora/neetwork/admin/listener.ora # %ated by Oracle Net8 Assistant Listener = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.17.2.22) (PORT = 1521)) (PROTOCOL_STACK = (PRESENTATION = TTC) (SESSION = NS))) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME = / ora) (SID_NAME = ORA8)) ### If the "global name" of the monitor service is specified, there is this line: (Global_DBNAME = ORA8) 2) Start net8 service lsnrctl start First you can help: [Oracle @LIN / ORA] $ lsnrctl lsnrctl> Help Start start: Start [Oracle @ Lin bin] $ lsnrctl Start couples, the machine will gradually tell you that you are starting ..., just join ..., already connected, and finally he said successed. The following is some of the brief information: lsnrctl for Linux: Version 8.1.5.0.0 - Production on 19-Nov-99 22:02:54 (c) Copyright 1998 Oracle Corporation. All Rights Reserved. Starting / ORA / BIN / TNSLSNR: PLEASE WAIT ... TNSLSNR for Linux: Version 8.1.5.0.0 - Production System Parameter File is /ora/network/admin/listener.ora/neetwork/log/listener.log listening ON: (DESC Ription = (Protocol = TCP) (host = 172.17.22) (PROT = 1521)) (protocol_stack = (presection = ttc)) Connecting to (deSCription = (protocol = tcp (Host = 172.17.2.22) (port = 1521)) (protocol_stack = (presentation = ttc) (session =
NS)))) ------------------------ Alias Listener Version TNSLSNR for Linux: Version 8.1.5.0.0 - Production Start Date 19 -Nov-99 22:02:54 uptime 0 days 0 hr. 0 min. 0 Sec TRACELEVEL OFF Security Off SNMP off listener parameter file /ora/neetwork/admin/listener.ora listener log file / ora / network / LOG / Listener.log Services Summary ... ORA8 HAS 1 Service Handler (s) The Command Complated SuccessFully Tip said that 1 service is processed, the command is successful. 3) Stop Net8 Services LSNRCTL Stop The easiest way is [Oracle @ Lin / Ora] $ LSNRCTL Stop Sometimes, the process has an error, TNSLSNR does not respond, like the frequent mistakes of Windows, there is a tough means: first Find out its process number, then kill! [Oracle @ Lin / ORA] $ PS - EF | Grep TNS Oracle 1331 1 0 15:51? 00:00:00 / ORA / BIN / TNSLSNR LISTENER -INHER or use less parameters can also find TNSLSNR: [Oracle @ Lin / Ora] $ PS -E PID TTY TIME CMD 1331? 00:00:00 TNSLSNR Now kill PID = 1331 Processes: [Oracle @ Lin / Ora] $ KILL 1331 LSNRCTL Like SVRMGRL, it is a server manager, There are a lot of parameters, or the subroutine, the star is an external program. [Oracle @ Lin bin] $ LSNRCTL Stop Lsnrctl for Linux: Version 8.1.5.0.0 - Production On 19-Nov-99 22:02:50 (C) Copyright 1998 Oracle Corporation. All Rights Reserved. Connecting To (Description = ADDRESS = (PROTOCOL = TCP) (HOST = 172.17.2.22) (PORT = 1521)) (PROTOCOL_STACK = (PRESENTATION = TTC) (SESSION = NS))) The command completed successfully Listeners = DataBase Name = Global DB Name = ora8, HomeDir = / ORA /, SID = ORA8 [ORACLE @ Lin Oracle] $ CD / ORA / NET * / AD * [ORACLE @ Lin Admin] $ Ls listener.ora namesini.sql samples sqlnet.ora namesdrp.sql namesupg.sql sqlnet .fdf tnsnames.ora The following is a situation in which TNSLSNR is remotely controlled on WindWos NT / 98 (Figure).
4) Parameter file summary [Oracle @ Lin admin] $ more /u01/app/oracle/admin/ora8/pfile/initora8.ora DB_Name = ORA8 Instance_name = ORA8 ## "Example Name" is a keyword service_names = ORA8 control_files = ( "/u01/app/oracle/oradata/ora8/control01.ctl", "/u01/app/oracle/oradata/ora8/control02.ctl") db_block_buffers = 8192 shared_pool_size = 4194304 log_checkpoint_interval = 10000 log_checkpoint_timeout = 1800 processes = 50 log_buffer = 163840 log_archive_start = true log_archive_dest_1 = "location = / u01 / app / oracle / admin / ora8 / arch" log_archive_format =% t_% s.dbf # Important open rollback rollback_segments = (r01, r02, r03, r04) # global_names = false ### monitoring service without having to specify a "global name" # oracle_trace_enable = true # define directories to store trace and alert files background_dump_dest = / u01 / app / oracle / admin / ora8 / bdump core_dump_dest = / u01 / app / oracle / admin / ora8 / cdump user_dump_dest = / u01 / app / oracle / admin / ora8 / udump db_block_size = 2048 remote_login_passwordfile = exclusive os_authent_prefix = "" compatible = "8.1.5" ## may be compatible with "8.0.5" 5) client network Configuration [Oracle @ Lin Ad Min] $ more tnsnames.ora # tnsnames.ora configuration file: /ora/neetwork/admin/tnsnames.ora # generated by Oracle Net8 Assistant Using Net8 Assistant, the result is automatically saved in tnsnames.ora, [Oracle @ Lin / ORA] $ Netass * Add Service: Name ORA8, parameters are as follows: protocol = TCP host = 172.17.2.22 port = 1521 Oracle_sid = ORA8 machine Explain as an Oracle server address package: (Description = (protocol = TCP) (Host = 172.17 .2.22) (PROT = 1521)) (protocol_stack = (session = ttc))) Generally, the client uses Windows9x / NT / 2000 because software development is easy, programmers and tools are more popular.
Windows client network configuration is similar to this, and its content is seen in: /oant/net80/admin/tnsname.ora8.World = (deScription = (protocol = TCP) (Host = 172.17.22) (port = 1521) (Connection_data = (sID = ora8))) --------------------------------------- ---- When installing Personal Oeacle8.05 in Windows2000 (Beta3 Professional), the monitoring service installation failed, as long as it understands the above Oracle structure principle, you can manually copy the net8 file, modify the configuration: Copy CD-ROM /./ NT_X86 / Server /lsnrctl80.exe ,tslsnr80.exe ,tsping80.exe c: / orant / bin copy cd-rom /./ listener.ora C: / ORANT / NET80 / Admin C: / ORANT / NET80 / Admin Me I have had such a experience. <> Delphi / C , PowerBuilder Develop Oracle Apps Why do you need multiple versions? Because you may develop new applications, you may also maintain an old application.
Delphi / C Develops a variety of versions of the Oracle Application Control Table PowerBuilder Develops Oracle Applications (Take PB6 as an Example) Oracle8, MSSQL7 What is the advantage? The following features For more than 10 clients / The number of users is important! Features / Platform Oracle8 MSSQL7 Portable Multi-platform: Unix, Linux, Windows Lock in Windows !!! Synonyms Create Public Synonym Emp for System.emp;? /// System Date Select Sysdate from Dual; SELECT GETDATE (); select current_timestamp; system user select user from dual; select user_id; select user_name; select suser; host id ?? / select host_id; [char8] SEQ ID NO create sequence regist7 start with 10000; select regsit7.nextval into: orderid from Dual //, you can take Currval, authorize other uses ??? -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------- Delphi / C Develop Oracle Application Multiple Versions Configuration Tools: Borland BDE Administrator Profile: Borland Shared / BDE / Idapi.cfg Newly built an alias in SQL Explorer: Object ===> New ... ===> Oracle ===> myoracle8 key parameter parameter value Oracle version DLL32 SQLORA8.DLL SQLORA32.DLL ORA8.X ORA7.X / 8.X Vender Init Ora805.dll OCI.DLL OCIW32.dll ORANT.DLL ORA80X.DLL ORA8X ORA8X for Win32 <= ORA7X.DLL Other Parameters: If the supplier has problems, copy ORA7X.DLL to: ORANT.DLL Try again !! Net protocol sql * net1, sql * Net2, Net8 Server Name See Tnsname.ora, Create by Netasst User Name Exmple: Scott / Tiger, ------------------------------------------------------------------------------------------------------------------- ---------------- PowerBuilder Develops a variety of versions of the various versions of the Oracle application: (as an example of PB6) PowerBuilder6 Quick installation path: CDROM: / PB6 / setup SQL * NET version PB Dynamic Library Profile Name Parameter Values Applicable Oracle Version SQL * NET16 ORA7.2 Previous PBOR760.DLL PROFILE NAME Server Login ID Password Oracle70 @t: Ora8 Scott Tiger Ora7.0 ORA7.X / 8.x ORA7.X / 8. X SQL * Net32 ORA7.X / 8.X PBO7260.DLL PBO7360.DLL PROFILE NAME Server Login ID Password Oracle73 @
TNS: ORA8 Scott Tiger Ora7.0 Ora7.x / 8.x Ora7.x / 8.x Ora8.x Net8 Pbo8060.dll Profile Name Server Login ID Password Oracle8 ORA8 Scott Tiger Other Parameters: If the supplier has problems, Copy Ora7x.dll to: ORANT.DLL Try again !! Net protocol sql * net1, sql * net2, net8 server name see tnsname.ora, create by Netasst User Name Exmple: Scott / Tiger, -------- -------------------------------------------------- --------------------- Upgrade / Patch Installation Instructions for Oracle 8i Enterprise Edition for Intel-Linux -------------- -------------------------------------------------- ---------------- 1. Shutdown any running database instances 2. Get the patch file linux_81501patch_ee.tgz 3. Create a directory and extract the patch file mkdir orapatch cd orapatch tar xvzf linux_81501patch_ee. tgz 4. Set the environment varibale ORACLE_HOME to the location of your Oracle 8i Enterprise Edition installation and run the script linux_81501patch_ee.sh to apply the patch. 5. Startup your database instances 6. Please read the FAQ provided along wi TH The Patch 7. This PATCH FIXES The FOLLOWING Problems: 955067 - libskgsp8.so NOT FOUND AS All Users But Oracle 941530 - Use of the support reelink shellscript fails 960290 - 8.0.5->
8.1.3 SQL * NET Connection Attempt Dumps Core 962324 - Netasst Doesnt Run Run Run Runs To The Unix Prompt with no errros * Last Updated 9/03/99 I. Installation Issues --------------- ------ 1. Which JRE VERSION IS Required for Running The Oracle Universal Installer (OUI) AND WHERE I this available? Use jre 1.1.6 v5 from http://www.blackdown.org. The JRE 1.1. 7 v3 (green threads) also should work, though not tested, which is also availble from this site. Download and install the above mentioned JRE in any location where thereis enough disk space and create a symbolic link from / usr / local / jreto the location where JRE was installed. 2. On what window managers was OUI tested? OUI runs on fvwm and KDE. There is a bug in the Enlightenment package used with GNOME on Red Hat 6.0that causes the Oracle Universal Installer (OUI) to fail. You May Downloadthe RPM Upgrade for the Enlightenment Package, Enlightenment-0.15.5-37.i386.rpm from the red hat Erww.Redhat.com/corp/support/errata/ RH60-Errata-general.html. 3. Could Not Locate Gmake In The Installed Linux Distribution. make / usr / bin / gmake as symbolic link to / usr / bin / make. $ su - root $ cd / usr / bin $ ln -s gmake make $ exit 4. OUI could not determine the free disk space though there is enough spaceand instead displayed some warnings. It's a bug in the installer. Please ignore the warnings andcontinue the installation. 5. When OUI reached installing protocol support , an empty list boxis displayed where the network protocols should have been listed.Unable to select any protocol. Only the TCP / IP adapter is supported which is default and built-in, andso the screen is blank. 6. Just before the DB Assistant Is Launched, a Dialog Is Displayed withthe Warning: "
. JNLS Exception:.. Oracle.ntp.jnls.JNLSException Unable to find anyNational Character Sets Please check your Oracle installation "This is a known problem (884001) Ignore the warning 7. Which one do we install to launch dbassist - JDK or JRE ? Download and install JRE 1.1.6 v5 as mentioned above, before launchingthe dbassist. 8. While adding PL / SQL support, the DB Assistant complained thatdbmssml.sql script was missing. Apply patch 8.1.5.0.1 or above and launch dbassist. 9. While testing the database creation using the dbassist, we haveobserved that, on a 4-way SMP system, it took more than 4 hours tocreate the database, if all the options are enabled. This may affectthe performance of the machine during this time . You could either select the option to create scripts and run them ORuse the scripts provided in $ ORACLE_HOME / rdbms / install / create to createthe database. The scripts in $ ORACLE_HOME / rdbms / install / createtake ORACLE_SID as the parameter. Before running these scripts Copy theinit .ora available in this directory as $ ORACLE_HOME / dbs / init