oracle的server_name,配置Oracle Name Server的完全步骤
安裝Oracle name server必須安裝net8和name server組件:
1.??First we must decide where the Oracle Names regional database will reside
and create a user??were the names tables will reside. Example:
create user oname identified by oname
default tablespace user_data
temporary tablespace temporary_data;
grant connect to oname;
1a. Connect as 'oname' and run the namesini.sql script.
2.??Run Net8 Assistant
3.??Create a new Names Server: Select the Names folder and click on the add
button. The Names Wizard should appear.
4.??Read the information that appears, then click Next.
5.??Read the information that appears, then click Next.
6.??Enter a name for this Oracle Names Server.
7.??Enter the Name Server listener details, then click Next.
For Example: Protocol? ?TCP
Host? ?? ? awhite-pc
Port? ?? ? 1575??(Note: 1575 is the default port
for Oracle Names)
8.??Click Next.
9.??Select "Use a region database." Click Next. Read the info. Click Next.
10. Specify the listener details of were the region database will reside
(IE - where the definitions are stored.) Click Next.
11. Specify a user that you want to use to store the region database
definitions: In this example, we will enter the user that we created in
step one - oname. Click Next.
12. Specify the password for the user. Click Next
13. Select "Yes" if this is the first name server for the region. Click Next.
14. Click Finish to save the entry.
15. At this point you can modify the Name Server you just created, If required.
Don t forget to save the changes.
NOTE: You must configure the Server side SQLNET.ORA as though it is a client
before the next steps will work correctly. See section "Configuring Net8
clients to Use Oracle Names".
16. Go to the Windows Control Panel. Select Services. Start the service named
OracleNamesService80.
縱觀整個步驟:我覺得關(guān)鍵步驟是
1、安裝name server組件(該組件并非缺省安裝),這樣你才能找到namesini.sql 腳本
2、在目標(biāo)數(shù)據(jù)庫的短口號為1575
3、配置完后還需重新啟動,然后啟動OracleNamerServer的服務(wù)
這三步缺一不可。
總結(jié)
以上是生活随笔為你收集整理的oracle的server_name,配置Oracle Name Server的完全步骤的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 电脑菜单隐藏怎么打开 怎么打开隐藏的电脑
- 下一篇: WSL安装Oracle,WSL安装JDK