日韩精品中文字幕一区二区-日韩精品中文字幕一区-日韩精品中文字幕视频-日韩精品在线一区二区三区-第一页在线-第一福利视频

當(dāng)前位置:首頁文章首頁 IT學(xué)院 IT技術(shù)

初學(xué)安裝oracle全部過程圖文教程

作者:  來源:  發(fā)布時間:2012-2-16 10:59:09  點擊:
SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))

)

)

B:sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

C:tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

SHZQ =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = shzq)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

-----------------------------------------------------------------------------------------

5.如果安裝Oracle發(fā)現(xiàn)swap分區(qū)過小的情況,則可以手動去擴展swap分區(qū)的大小

//使用root用戶

#dd if=/dev/zero of=/home/swap bs=1024 count=1024000

//創(chuàng)建/home/swap分區(qū)文件。大小為1024000個block,一般情況下1個block為1K,所以這里空間是1024M(1G);

//指定分區(qū)類型為swap

//使用mkswap命令把分區(qū)變成swap分區(qū)如下

#/sbin/mkswap /home/swap

//讓配置的swap生效

#/sbin/swapon /home/swap

//free -m 查看swap和內(nèi)存大小

#free -m

//修改/etc/fstab文件讓其自動掛載

#/home/swap swap swap defaults 0 0

6.讓另一臺客戶端或者應(yīng)用服務(wù)器連接本服務(wù)器的oracle數(shù)據(jù)庫

//前提:客戶端或者應(yīng)用服務(wù)器必須至少安裝oracle客戶或者oracle數(shù)據(jù)庫

錯誤提示:

>sqlplus /nolog

SQL> conn '/as sysdba'

請輸入口令: ******

ERROR:

ORA-12560: TNS: 協(xié)議適配器錯誤

 

SQL> connect system/manager

ERROR:

ORA-12560: TNS: 協(xié)議適配器錯誤

//說明:從客戶端或者應(yīng)用服務(wù)器(linux或WIN)

#tnsnping 192.168.1.11

#tnsping oracle10g //需要做好解析

//以Windows為例:

C:\Documents and Settings\Administrator>tnsping 192.168.1.11

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-2月 -

2012 14:16:18

Copyright (c) 1997, 2005, Oracle. All rights reserved.

已使用的參數(shù)文件:

D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 EZCONNECT 適配器來解析別名

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.168.1.11))(AD

DRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521)))

OK (20 毫秒)

-----------------------------------------------------------------------------------------

7.客戶端連接oracle配置文件實例:(見附件)

A:listener.ora

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))

)

)

B:sqlnet.ora

# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to

# install "Software Only", this file wont exist and without the native

# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

C:tnsnames.ora

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

SHZQ =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = shzq)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

-----------------------------------------------------------------------------------------

8.oracle安裝完成,系統(tǒng)自帶的用戶和密碼

//internal/oracle

// sys/change_on_install

//system/manager

//scott/tiger

//sysman/oem_temp

三、使用PLSQL Developer 管理linux Oracle服務(wù)器

1.登陸

2.使用

首頁 上一頁 [1] [2] [3]  下一頁 尾頁

文章評論

軟件按字母排列: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
主站蜘蛛池模板: 十一码复式中奖表图片| 姐姐的秘密电影| 《禁忌2》在线观看| 全国精神病查询系统官网| 中国天黑最晚的地方| 别董大古诗一首| bob hartman| 老爸回家 电视剧| 人口高质量发展形势与政策论文| 速度与激情9| busty milf| 欧美成熟| 我和我的父辈 电影| 土壤动植物的乐园教学反思| 成人在线| 电视节目预告表| 挨打的视频| 闺蜜之夏 电影| 写现代诗| 恋爱症候群| 母鸡评课| 养小动物的作文| 火花 电影| 你是我的玫瑰花简谱| 性的视频| 爱情公寓海报| 如意电视剧| 你让我感动| 搜狐手机网首页新闻| 被抛弃的青春1982| 日本电影家庭教师| 天猫店铺运营| cctv体育频道5| 声入人心| 怀秋| 错爱徐帆电视剧28集| 欧美一级在线视频| 林东升| 二胡独奏北国之春| 王尧演员| 章家瑞|