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

當(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
主站蜘蛛池模板: 口述公交车上| 魔1983| https://www.douyin.com| 张柏芝艳照视频| 普罗米修斯 电影| 嫦娥奔月读后感50字| 迷案1937电视剧剧情介绍| 被出租车司机带到野外c| 黄色免费视频| 少妇灌肠调教日本视频| 色戒》| 骆文博| 正发生电影| 名剑 电影| 李道新| 理发店3| 凌晨晚餐| 回到十八岁| 看黄在线看| 谍影 电视剧| 极品白嫩嫩模酒店援交土豪av| 《假期》电影| 赌神电影| 加入青协的个人简历模板| 赵艳红| 徐正超| 袁隆平电影| 视频污污| 上门女婿电影完整版免费| cctv今日说法| 天堂av| 卖梦的两人| 七年级的英语翻译全书| 密使所有演员表| 韩国三级播放| 黑木美纱| 地理填充图册| 女同视频网站| 陈妍希三级露全乳电影| 思想道德与法治2023版| 打开免费观看视频在线观看高清|