le@lin /ora]$ lsnrctl
LSNRCTL> help
然后开始启动：start
[oracle@lin bin]$ lsnrctl start
联接时，机器会逐步告诉你正在启动…,正在联接…,已经联接的状态,最后他说成功啦! 下面是一些简要信息：
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
Log messages written to /ora/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521))
(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521))
(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
STATUS of the LISTENER
------------------------
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
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /ora/network/admin/listener.ora
Listener Log File /ora/network/log/listener.log
Services Summary...
ora8 has 1 service handler(s)
The command completed successfully
以上提示说，1个服务被处理，命令成功完成。
３）停止Net8服务lsnrctl stop
最简单的方法是 [oracle@lin /ora]$ lsnrctl stop
有时侯，进程出了差错，tnslsnr没有响应，像WindowsNT常犯的毛病一 样，
这里有一个强硬的手段：先找出它的进程号，然后 kill掉！
[oracle@lin /ora]$ ps -ef|grep tns
oracle 1331 1 0 15:51 ? 00:00:00 /ora/bin/tnslsnr LISTENER -inher
或使用更少的参数也能找到tnslsnr:
[oracle@lin /ora]$ ps -e
PID TTY TIME CMD
1331 ? 00:00:00 tnslsnr
现在杀死PID = 1331的进程：
[oracle@lin /ora]$ kill 1331
LSNRCTL象 SVRMGRL一样，是一个服务器管理程序，有不少参数，或者说是 子程序，带星号的是一个外部程序。
[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
下面是在 Windwos NT/98 上远程控制 TNSLSNR 的情形(图略)。
４）参数文件摘要
[oracle@lin admin]$ more /u01/app/oracle/admin/ora8/pfile/initora8.ora
db_name = ora8
instance_name = ora8 ## "事例名"是关键字
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
# 切记打开回滚段
rollback_segments = (r01, r02, r03, r04)
# global_names = false ### 监听服务无需指明"全局名"
# 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" ## 也可以兼容 "8.0.5"
5)客户端网络配置
[oracle@lin admin]$ more tnsnames.ora
# TNSNAMES.ORA Configuration File:/ora/network/admin/tnsnames.ora
# Generated by Oracle Net8 Assistant
使用net8助理,结果自动保存在 tnsnames.ora 中，
[oracle@lin /ora]$ netass* 添加Service: 名称ora8，参数如下：
PROTOCOL=TCP HOST=172.17.2.22 PORT=1521 Oracle_SID=ora8
机器解释成一个Oracle服务器地址包：
( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521))
(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))
)
一般说来，客户端采用Windows9x/NT/2000,因为这里软件开发容易，程序员和工具较为普及。
Windows 客户端网络配置与此类似，其内容见于: \OraNT\net80\Admin\tnsname.ora
ORA8.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.2.22)(PORT = 1521))
(CONNECT_DATA = (SID = ora8))
)
-------------------------------------------
在Windows2000(beta3专业版)中安装Personal Oeacle8.05时，监听服务安装失败，
只要理解以上oracle结构原理，可以手工复制Net8文件，修改配置：
copy CD-ROM\.\NT_x86\server\lsnrctl80.exe,tnslsnr80.exe,tnsping80.exe C:\orant\bin
copy CD-ROM\.\listener.ora C:\orant\net80\admin
我不久前有这么一次经历。
<=>
Delphi/C++, PowerBuilder开发Oracle应用
为什么需要多个版本? 因为可能开发新应用，也可能维护一个旧的应用。
Delphi/C++ 开发Oracle应用的多种版本的参数对照表
PowerBuilder开发Oracle应用的多种版本的参数对照表(以PB6为例)
Oracle8, MSsql7各有什么优势?
以下特性对于10个以上的客户端/用户数很重要!
特性\平台 Oracle8 MSSQL7
可移植性
多平台: Unix, Linux,Windows 锁定在Windows!!!
同义词 create public synonym emp for system.emp; ?///
系统日期 select sysdate from dual; select getdate();
select current_timestamp;
系统用户 select user from dual; select user_id;
select user_name; select suser;
主机id ??/ select host_id; [char8]
序列号 create sequence regist7 start with 10000;
select regsit7.nextval into :orderid from dual
//,可以取currval,授权其他用 ???
-----------------------------------------------
Delphi/C++ 开发Oracle应用的多种版本的参数对照表
配置工具：borland BDE Administrator
配置文件：borland Shared\BDE\idapi.cfg
在 SQL Explorer 中新建一个别名：
Object ===> New ... ===> ORACLE ===>myORACLE8
关键参数 参数值 Oracle版本
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
其他参数 :
如果提示供应商有问题，就复制ORA7x.dll 到: ORANT.DLL再试!!
NET PROTOCOL SQL*Net1, SQL*Net2, Net8
SERVER NAME see TNSNAME.ORA , create by netasst
USER NAME exmple: SCOTT/tiger,
-----------------------------------------------
PowerBuilder开发Oracle应用的多种版本的参数对照表：(以PB6为例)
PowerBuilder6快速安装路径：CDROM:\pb6\setup
SQL*net版本 pb动态库 Profile参数名 参数值 适用Oracle版本
SQL*net16
ora7.2以前 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
其他参数 :
如果提示供应商有问题，就复制ORA7x.dll 到: ORANT.DLL再试!!
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 with the patch
7. This patch fixes the following problems:
955067 - LIBSKGSP8.SO NOT FOUND AS ALL USERS BUT ORACLE
941530 - USE OF THE SUPPLIED RELINK SHELLSCRIPT FAILS
960290 - 8.0.5->8.1.3 SQL*NET CONNECTION ATTEMPT DUMPS CORE
962324 - NETASST DOESNT RUN RETURNS 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 is 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 Errata site at http://上一页 [1] [2] [3] [4] 下一页 |
