Oracle12C的安装错误

Oracle12C的安装错误,第1张

1. 先弄好c$ share的问题

2. 测试一下 c$ share 是否成功. 方法是在cmd里打net use \\localhost\c$ 失败会是这样子...: 系统错误53

The network path was not found. 成功是这样子: 命令成功完成。

3. 如果第2步失败, 检查"服务"里的"TCP/IP NetBIOS Helper"服务是否已开启, 没有的话启动它即可. 解决系统错误53的经过:

使用命令net usenet use \\localhost\c$时,发生错误53,找不到网络路径。我在虚拟机中输入:net share命令,发现只有一个IPC$(原来默认共享被关闭了),经过一翻百度后,找到了解决办法:第一步:检查AutoShareServer和AutoShareWks注册表值,以确保未将它们设置为0。依次点击“开始→运行”,输入regedit,然后按回车键进入注册表编辑器。

第二步:找到并单击HKEY_LOCAL_MACHINESystemCurrent ControlSetServicesLanmanServerParameters。 第三步:如果LanmanServerParameter

s子项中的AutoShareServer 和AutoShareWks DWORD值配置的数值为0,则将该值更改为1

打字不易,如满意,望采纳。

前提回现

修改了主机名,由hyldb修改为hyl。

问题现象

配置监听,警告提示,如下所示:

解决方法

1、检查1521端口

[root@hyl ~]# netstat -a

--查看端口占用情况,查明1521端口并未被占用

[plain] view plain copy 在CODE上查看代码片派生到我的代码片

Active Internet connections (servers and established)

Proto Recv-Q Send-Q Local Address Foreign Address State

tcp0 0 localhost.localdomain:2208 *:* LISTEN

tcp0 0 *:sunrpc*:* LISTEN

tcp0 0 *:pftp *:* LISTEN

tcp0 0 localhost.localdomain:ipp *:* LISTEN

tcp0 0 localhost.localdomain:smtp *:* LISTEN

tcp0 0 localhost.localdomain:2207 *:* LISTEN

tcp0 0 *:ssh *:* LISTEN

getnameinfo failed

getnameinfo failed

tcp0132 [UNKNOWN]:ssh [UNKNOWN]:51492 ESTABLISHED

udp0 0 *:spmp *:*

udp0 0 *:659 *:*

udp0 0 *:37437 *:*

udp0 0 *:mdns *:*

udp0 0 *:sunrpc*:*

udp0 0 *:ipp *:*

udp0 0 *:mdns *:*

udp0 0 *:32372 *:*

Active UNIX domain sockets (servers and established)

Proto RefCnt Flags Type State I-Node Path

unix 2 [ ACC ] STREAM LISTENING 4226 @ISCSIADM_ABSTRACT_NAMESPACE

unix 2 [ ACC ] STREAM LISTENING 4938 /var/run/dbus/system_bus_socket

unix 2 [ ACC ] STREAM LISTENING 7578 @/tmp/fam-root-

unix 2 [ ACC ] STREAM LISTENING 5021 /var/run/sdp

unix 2 [ ACC ] STREAM LISTENING 5102 /var/run/pcscd.comm

unix 2 [ ACC ] STREAM LISTENING 5127 /var/run/acpid.socket

unix 2 [ ACC ] STREAM LISTENING 6197 /var/run/cups/cups.sock

unix 2 [ ACC ] STREAM LISTENING 6633 /var/run/avahi-daemon/socket

unix 2 [ ACC ] STREAM LISTENING 6473 /dev/gpmctl

unix 2 [ ACC ] STREAM LISTENING 4212 @ISCSID_UIP_ABSTRACT_NAMESPACE

unix 2 [ ] DGRAM1102 @/org/kernel/udev/udevd

unix 2 [ ACC ] STREAM LISTENING 6509 /tmp/.font-unix/fs7100

unix 2 [ ACC ] STREAM LISTENING 7135 /tmp/.gdm_socket

unix 2 [ ACC ] STREAM LISTENING 7165 /tmp/.X11-unix/X0

unix 2 [ ] DGRAM5161 @/org/freedesktop/hal/udev_event

unix 17 [ ] DGRAM4527 /dev/log

unix 2 [ ACC ] STREAM LISTENING 5152 @/var/run/hald/dbus-R5ibTGYpjn

unix 2 [ ACC ] STREAM LISTENING 5153 @/var/run/hald/dbus-1m4p21ErfG

unix 2 [ ACC ] STREAM LISTENING 4482 /var/run/audispd_events

unix 2 [ ] DGRAM7618

unix 3 [ ] STREAM CONNECTED 7581 @/tmp/fam-root-

unix 3 [ ] STREAM CONNECTED 7580

unix 3 [ ] STREAM CONNECTED 7571 /var/run/dbus/system_bus_socket

unix 3 [ ] STREAM CONNECTED 7570

unix 3 [ ] STREAM CONNECTED 7448 /tmp/.X11-unix/X0

unix 3 [ ] STREAM CONNECTED 7447

unix 3 [ ] STREAM CONNECTED 7364 /tmp/.X11-unix/X0

unix 3 [ ] STREAM CONNECTED 7363

unix 3 [ ] STREAM CONNECTED 7261 /tmp/.font-unix/fs7100

unix 3 [ ] STREAM CONNECTED 7260

unix 3 [ ] STREAM CONNECTED 7217 /var/run/pcscd.comm

unix 3 [ ] STREAM CONNECTED 7216

unix 3 [ ] STREAM CONNECTED 7264 /tmp/.X11-unix/X0

unix 3 [ ] STREAM CONNECTED 7190

unix 3 [ ] STREAM CONNECTED 7177 /var/run/acpid.socket

unix 3 [ ] STREAM CONNECTED 7176

unix 2 [ ] DGRAM7163

unix 3 [ ] STREAM CONNECTED 6636 /var/run/dbus/system_bus_socket

unix 3 [ ] STREAM CONNECTED 6635

unix 3 [ ] STREAM CONNECTED 6630

unix 3 [ ] STREAM CONNECTED 6629

unix 2 [ ] DGRAM6627

unix 2 [ ] DGRAM6467

unix 2 [ ] DGRAM6426

unix 2 [ ] DGRAM6379

unix 2 [ ] DGRAM6324

unix 2 [ ] DGRAM6109

unix 2 [ ] DGRAM6068

unix 2 [ ] DGRAM5958

unix 3 [ ] STREAM CONNECTED 5930 /var/run/dbus/system_bus_socket

unix 3 [ ] STREAM CONNECTED 5929

unix 3 [ ] STREAM CONNECTED 5903 @/var/run/hald/dbus-R5ibTGYpjn

unix 3 [ ] STREAM CONNECTED 5902

unix 3 [ ] STREAM CONNECTED 5896 @/var/run/hald/dbus-R5ibTGYpjn

unix 3 [ ] STREAM CONNECTED 5893

unix 3 [ ] STREAM CONNECTED 5738 @/var/run/hald/dbus-R5ibTGYpjn

unix 3 [ ] STREAM CONNECTED 5737

unix 3 [ ] STREAM CONNECTED 5714 /var/run/acpid.socket

unix 3 [ ] STREAM CONNECTED 5713

unix 3 [ ] STREAM CONNECTED 5708 @/var/run/hald/dbus-R5ibTGYpjn

unix 3 [ ] STREAM CONNECTED 5707

unix 3 [ ] STREAM CONNECTED 5156 @/var/run/hald/dbus-1m4p21ErfG

unix 3 [ ] STREAM CONNECTED 5155

unix 2 [ ] DGRAM5101

unix 3 [ ] STREAM CONNECTED 5016 /var/run/dbus/system_bus_socket

unix 3 [ ] STREAM CONNECTED 5015

unix 2 [ ] DGRAM4987

unix 2 [ ] DGRAM4977

unix 3 [ ] STREAM CONNECTED 4942

unix 3 [ ] STREAM CONNECTED 4941

unix 3 [ ] STREAM CONNECTED 4900

unix 3 [ ] STREAM CONNECTED 4899

unix 2 [ ] DGRAM4798

unix 2 [ ] DGRAM4543

unix 3 [ ] STREAM CONNECTED 4473

unix 3 [ ] STREAM CONNECTED 4472 <span style="font-size:14px"></span>

2、检查hosts

[root@hyl ~]# vi /etc/hosts

修改前:

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 hyldb localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

192.168.56.101 hyl

~

~

~

--由于修改了主机名(hyldb修改为hyl),将之前配置中hyldb内容删除

修改为:

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

192.168.56.101 hyl

~

~

~

~

3、检查network

# vi /etc/sysconfig/network

--确认添加了如下信息

NETWORKING=yes

HOSTNAME=hyl

4、检查ipv6是否关闭

查看ipv6状态,查看其是否被关闭

[root@hyl ~]# lsmod |grep ipv6

ipv6 435105 17 cnic

xfrm_nalgo 43333 1 ipv6

[plain] view plain copy 在CODE上查看代码片派生到我的代码片

补充:关闭ipv6方法

1) # vim /etc/modprobe.conf

在其中加入下面这一行,

install ipv6 /bin/true

保存并退出。

2)# vim /etc/sysconfig/network

在其中加入下面配置项:

NETWORKING_IPV6=no

IPV6INIT=no

重启后查询:

[root@hyl ~]# lsmod |grep ipv6

--没有显示ipv6相关信息,表示ipv6已经关闭

5、重启系统后,查看hostname

[root@hyl ~]# hostname

--查询主机名

hyl

6、再次执行netca

配置监听、dbca建库成功。

通过配置本地数据库的tns配置文件实现:

去oracle安装目录下oracle\product\10.2.0\db_2\NETWORK\ADMIN\ 找到tnsnames.ora,用记事本打开,里边有远程数据库的tns连接配置串如下

ORCL23 =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SID = ORCL)

)

)

添加好ip、端口和目标数据库的实例名(SID),然后确保tns名称(ORCL23)在整个文档中唯一,保存后打开数据库连接工具,输入远程数据库上的用户名密码,选择数据库对象为你配置的连接名就可以了


欢迎分享,转载请注明来源:内存溢出

原文地址:https://54852.com/sjk/10099440.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2023-05-05
下一篇2023-05-05

发表评论

登录后才能评论

评论列表(0条)

    保存