菜鳥問題,緊急求救!!!

[复制链接]
查看11 | 回复5 | 2014-9-12 22:37:43 | 显示全部楼层 |阅读模式
SIZE=3]為什么我成功安裝了ORACLE軟體,并且也用DBCA重新成功創建了database,但是在/data/u01/ora9i/network下卻找不到listener.ora及tnsname.ora文件,用netca倒是重新創建了listener,但是,還是沒找到tnsname.ora,各位大哥們,可否告知小弟原因,不勝感激!!![/SIZE]
回复

使用道具 举报

千问 | 2014-9-12 22:37:43 | 显示全部楼层
应该在/data/u01/ora9i/network\admin\
如果没有的话,到
/data/u01/ora9i/network\admin\SAMPLE 下复制个tnsname.ora放在
/data/u01/ora9i/network\admin\ 下自己填上
回复

使用道具 举报

千问 | 2014-9-12 22:37:43 | 显示全部楼层
最初由 sdusun 发布
[B]应该在/data/u01/ora9i/network\admin\
如果没有的话,到
/data/u01/ora9i/network\admin\SAMPLE 下复制个tnsname.ora放在
/data/u01/ora9i/network\admin\ 下自己填上 [/B]

应该是/data/u01/ora9i/network/admin/
呵呵
回复

使用道具 举报

千问 | 2014-9-12 22:37:43 | 显示全部楼层
汗。。。是我打掉了,我的確在/data/u01/ora9i/network/admin/下面沒找到!!!~~~
并且我在/data/u01/ora9i/network/admin/sample下找到的tnsnames.ora是這樣的:
# This file contains the syntax information for
# the entries to be put in any tnsnames.ora file
# The entries in this file are need based.
# There are no defaults for entries in this file
# that Sqlnet/Net3 use that need to be overridden
#
# Typically you could have two tnsnames.ora files
# in the system, one that is set for the entire system
# and is called the system tnsnames.ora file, and a
# second file that is used by each user locally so that
# he can override the definitions dictated by the system
# tnsnames.ora file.
# The entries in tnsnames.ora are an alternative to using
# the names server with the onames adapter.
# They are a collection of aliases for the addresses that
# the listener(s) is(are) listening for a database or
# several databases.
# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.

= [ (DESCRIPTION_LIST =# Optional depending on whether u have

# one or more descriptions

# If there is just one description, unnecessary
]

(DESCRIPTION=

[ (SDU=2048) ]# Optional, defaults to 2048

# Can take values between 512 and 32K

[ (ADDRESS_LIST=# Optional depending on whether u have

# one or more addresses

# If there is just one address, unnecessary ]

(ADDRESS=

[ (COMMUNITY=)

)

[ (ADDRESS=

(PROTOCOL=ipc)

(KEY=)

)

]

...
# More addresses

[ ) ]
# Optional depending on whether ADDRESS_LIST

# is being used

[ (CONNECT_DATA=

(SID=)

[ (GLOBAL_NAME=) ]

)

]

[ (SOURCE_ROUTE=yes) ]

)

[ (CONNECT_DATA=

(SID=)

[ (GLOBAL_NAME=) ]

)
]

... # More descriptions
[ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not
回复

使用道具 举报

千问 | 2014-9-12 22:37:43 | 显示全部楼层
我是菜鸟,学习中
回复

使用道具 举报

千问 | 2014-9-12 22:37:43 | 显示全部楼层
自己可以按照sample中重新建立一个的
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行