ITPUB论坛-中国最专业的IT技术社区

 找回密码
 注册
查看: 802|回复: 6

静默安装数据库软件和数据库的问题

[复制链接]
论坛徽章:
32
优秀写手
日期:2014-07-23 06:00:13秀才
日期:2016-08-05 10:34:04秀才
日期:2016-08-05 10:34:04秀才
日期:2016-08-05 10:28:31秀才
日期:2016-08-05 10:33:40技术图书徽章
日期:2016-08-05 10:29:11秀才
日期:2016-08-05 10:28:57秀才
日期:2016-08-05 10:28:57秀才
日期:2016-08-05 10:28:57秀才
日期:2016-09-27 15:16:21
发表于 2017-11-27 15:30 | 显示全部楼层 |阅读模式
现在做静默安装时,发现的问题是,一连接sqlplus 就报
[oracle@iZ2zehy7gff0kpg1swp1czZ ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 27 15:28:46 2017
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
我把sqlplus的执行过程打印出来如下
[oracle@iZ2zehy7gff0kpg1swp1czZ bin]$ vi /tmp/sqlplus.log
26980 execve("/u02/oracle/product/11.2.0/dbhome_1/bin/sqlplus", ["sqlplus", "/", "as", "sysdba"], [/* 25 vars */]) = 0
26980 brk(NULL)                         = 0xabc000
26980 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe6df332000
26980 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
26980 open("/u02/oracle/product/11.2.0/dbhome_1/lib/tls/x86_64/libsqlplus.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
26980 stat("/u02/oracle/product/11.2.0/dbhome_1/lib/tls/x86_64", 0x7ffe74e2b800) = -1 ENOENT (No such file or directory)
26980 open("/u02/oracle/product/11.2.0/dbhome_1/lib/tls/libsqlplus.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
26980 stat("/u02/oracle/product/11.2.0/dbhome_1/lib/tls", 0x7ffe74e2b800) = -1 ENOENT (No such file or directory)
26980 open("/u02/oracle/product/11.2.0/dbhome_1/lib/x86_64/libsqlplus.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
26980 stat("/u02/oracle/product/11.2.0/dbhome_1/lib/x86_64", 0x7ffe74e2b800) = -1 ENOENT (No such file or directory)
26980 open("/u02/oracle/product/11.2.0/dbhome_1/lib/libsqlplus.so", O_RDONLY|O_CLOEXEC) = 3
26980 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\366\1\0\0\0\0\0"..., 832) = 832
26980 fstat(3, {st_mode=S_IFREG|0644, st_size=1470768, ...}) = 0
26980 mmap(NULL, 1993888, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe6df14b000
[oracle@iZ2zehy7gff0kpg1swp1czZ bin]$ cat /tmp/sqlplus.log|grep error
26982 execve("/u02/oracle/product/11.2.0/dbhome_1/bin/oracle", ["oracleorcl", "(DESCRIPTION=(LOCAL=YES)(ADDRESS"...], [/* 26 vars */]) = -1 ENOEXEC (Exec format error)
26980 write(9, "\nFatal NI connect error 12547, c"..., 310) = 310
26980 write(9, "  Tns error struct:\n", 20) = 20
27092 execve("/u02/oracle/product/11.2.0/dbhome_1/bin/oracle", ["oracleorcl", "(DESCRIPTION=(LOCAL=YES)(ADDRESS"...], [/* 26 vars */]) = -1 ENOEXEC (Exec format error)
26980 write(10, "\nFatal NI connect error 12547, c"..., 310) = 310
26980 write(10, "  Tns error struct:\n", 20) = 20
27095 execve("/u02/oracle/product/11.2.0/dbhome_1/bin/oracle", ["oracleorcl", "(DESCRIPTION=(LOCAL=YES)(ADDRESS"...], [/* 26 vars */]) = -1 ENOEXEC (Exec format error)
26980 write(10, "\nFatal NI connect error 12547, c"..., 310) = 310
26980 write(10, "  Tns error struct:\n", 20) = 20

还请帮忙看下,到底什么问题,现在静默安装总是安不上啊
论坛徽章:
0
发表于 2017-11-27 15:48 | 显示全部楼层
/u02/oracle/product/11.2.0/dbhome_1/lib/  (No such file or directory) 如果确定那些路径正确的话,看看权限是不是出了问题

使用道具 举报

回复
论坛徽章:
116
现任管理团队成员
日期:2011-05-07 01:45:08娜美
日期:2017-08-29 10:15:28
发表于 2017-11-27 18:04 | 显示全部楼层
chrisguy1031 发表于 2017-11-27 15:48
/u02/oracle/product/11.2.0/dbhome_1/lib/  (No such file or directory) 如果确定那些路径正确的话,看看 ...

它上面那些No such file or directory错都是正常的。

LZ,把你的strace输出贴全了~

使用道具 举报

回复
论坛徽章:
116
现任管理团队成员
日期:2011-05-07 01:45:08娜美
日期:2017-08-29 10:15:28
发表于 2017-11-27 18:15 | 显示全部楼层
本帖最后由 zergduan 于 2017-11-27 18:21 编辑

从“Exec format error”上来看,应该是oracle做编译的时候就有问题,你静默安装后没有看看日志么?应该也有类似的错误吧?

我初步认为你应该是没有吧必要的安装包装全,静默安装本身就报错了,被忽略了~

你把你静默安装前,安装的系统包都发出来我看看

使用道具 举报

回复
论坛徽章:
32
优秀写手
日期:2014-07-23 06:00:13秀才
日期:2016-08-05 10:34:04秀才
日期:2016-08-05 10:34:04秀才
日期:2016-08-05 10:28:31秀才
日期:2016-08-05 10:33:40技术图书徽章
日期:2016-08-05 10:29:11秀才
日期:2016-08-05 10:28:57秀才
日期:2016-08-05 10:28:57秀才
日期:2016-08-05 10:28:57秀才
日期:2016-09-27 15:16:21
 楼主| 发表于 2017-11-28 09:19 | 显示全部楼层
本帖最后由 flzhang 于 2017-11-28 09:24 编辑
zergduan 发表于 2017-11-27 18:15
从“Exec format error”上来看,应该是oracle做编译的时候就有问题,你静默安装后没有看看日志么?应该也 ...

看了下日志,应该是少包,但好像少的是不是32位的包啊,我都安了这些包
oracle下的软件地址如下
下载地址:wget  http://v.yingsun.net/cobra/downl ... 2_database_1of2.zip
下载地址:wget  http://v.yingsun.net/cobra/downl ... 2_database_2of2.zip
之前安得包
1开始安装的包
yum -y install binutils compat-libstdc++ compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ glibc-devel glibc-headers ksh libaio-devel libstdc++-devel make sysstat unixODBC-devel binutils-* compat-libstdc++* elfutils-libelf* glibc* gcc-* libaio* libgcc* libstdc++* make* sysstat* unixODBC* wget unzip

比如查看包是否安装
[root@iZ2zehy7gff0kpg1swp1czZ ~]# yum -y install libaio-0.3*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package libaio-0.3.109-13.el7.x86_64 already installed and latest version
Nothing to do
但这个包日志里告诉我没安装 日志提示"Package "libaio-0.3.105 (i386)" is missing",但yum说是最新的是怎么回事呢

日志文件如下
[oracle@iZ2zehy7gff0kpg1swp1czZ logs]$ cat installActions2017-11-27_10-54-08PM.log | grep Error
INFO: Error Message:PRVF-7530 : Sufficient physical memory is not available on node "iZ2zehy7gff0kpg1swp1czZ" [Required physical memory = 1GB (1048576.0KB)]
INFO: Error Message:PRVF-7575 : Encountered an internal error. The range of reference data for verifying swap size has not been correctly defined
INFO: Error Message:PRVF-7543 : OS Kernel parameter "semopm" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "100" ; Found = "32"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "semmni" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "128" ; Found = "0"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "shmmax" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "536870912" ; Found = "0"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "shmall" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "2097152" ; Found = "0"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "file-max" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "6815744" ; Found = "6553600"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "ip_local_port_range" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "between 9000 & 65500" ; Found = "between 32768 & 60999"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "rmem_default" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "262144" ; Found = "212992"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "rmem_max" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "4194304" ; Found = "212992"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "wmem_default" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "262144" ; Found = "212992"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "wmem_max" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "1048576" ; Found = "212992"].
INFO: Error Message:PRVF-7543 : OS Kernel parameter "aio-max-nr" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "1048576" ; Found = "65536"].
INFO: Error Message:PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "glibc-2.3.4-2.41 (i686)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "compat-libstdc++-33-3.2.3 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "libaio-devel-0.3.105 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "libgcc-3.4.6 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "libstdc++-3.4.6 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "unixODBC-2.2.11 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "unixODBC-devel-2.2.11 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "pdksh-5.2.14" is missing on node "iZ2zehy7gff0kpg1swp1czZ"


安装时的日志,这是最后50行的输出
[oracle@iZ2zehy7gff0kpg1swp1czZ logs]$ tail -100 installActions2017-11-27_10-54-08PM.log
INFO: Actual Value:libstdc++-devel-4.8.5-16.el7 (x86_64)
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Package: sysstat-5.0.5: This is a prerequisite condition to test whether the package "sysstat-5.0.5" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:SUCCESSFUL
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
INFO: Expected Value:sysstat-5.0.5
INFO: Actual Value:sysstat-10.1.5-12.el7
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Package: unixODBC-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-2.2.11" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
INFO: Expected Value:unixODBC-2.2.11 (i386)
INFO: Actual Value:missing
INFO: Error Message:PRVF-7532 : Package "unixODBC-2.2.11 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: Action: Ensure that the required package is installed and available.
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Package: unixODBC-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-2.2.11" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:SUCCESSFUL
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
INFO: Expected Value:unixODBC-2.2.11 (x86_64)
INFO: Actual Value:unixODBC-2.3.1-11.el7 (x86_64)
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Package: unixODBC-devel-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-devel-2.2.11" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
INFO: Expected Value:unixODBC-devel-2.2.11 (i386)
INFO: Actual Value:missing
INFO: Error Message:PRVF-7532 : Package "unixODBC-devel-2.2.11 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: Action: Ensure that the required package is installed and available.
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Package: unixODBC-devel-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-devel-2.2.11" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:SUCCESSFUL
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
INFO: Expected Value:unixODBC-devel-2.2.11 (x86_64)
INFO: Actual Value:unixODBC-devel-2.3.1-11.el7 (x86_64)
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Package: pdksh-5.2.14: This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
INFO: Expected Valuedksh-5.2.14
INFO: Actual Value:missing
INFO: Error Message:PRVF-7532 : Package "pdksh-5.2.14" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: Action: Ensure that the required package is installed and available.
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Package: expat-1.95.7: This is a prerequisite condition to test whether the package "expat-1.95.7" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:SUCCESSFUL
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
INFO: Expected Value:expat-1.95.7 (x86_64)
INFO: Actual Value:expat-2.1.0-10.el7_3 (x86_64)
INFO: -----------------------------------------------
INFO: *********************************************
INFO: Users With Same UID: This test checks that multiple users do not exist with user id as "0".
INFO: Severity:CRITICAL
INFO: OverallStatus:SUCCESSFUL
INFO: -----------------------------------------------
INFO: Verification Result for Node:iZ2zehy7gff0kpg1swp1czZ
WARNING: Result values are not available for this verification task
INFO: All forked task are completed at state performChecks
INFO: Completed background operations
INFO: Moved to state <performChecks>
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Validating state <performChecks>
INFO: Using default Validator configured in the Action class oracle.install.ivw.db.action.PrereqAction
INFO: Adding ExitStatus PREREQUISITES_NOT_MET to the exit status set
SEVERE: [FATAL] [INS-13013] Target environment do not meet some mandatory requirements.
   CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /home/oracle/oraInventory/logs/installActions2017-11-27_10-54-08PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: /home/oracle/oraInventory/logs/installActions2017-11-27_10-54-08PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
INFO: Advice is ABORT
INFO: Adding ExitStatus INVALID_USER_INPUT to the exit status set
INFO: Completed validating state <performChecks>
INFO: Terminating all background operations
INFO: Terminated all background operations
INFO: Finding the most appropriate exit status for the current application
INFO: Exit Status is -3
INFO: Shutdown Oracle Database 11g Release 2 Installer

使用道具 举报

回复
论坛徽章:
116
现任管理团队成员
日期:2011-05-07 01:45:08娜美
日期:2017-08-29 10:15:28
发表于 2017-11-28 09:31 | 显示全部楼层
glibc-2.3.4-2.41 (i686)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
这个包当时你都没装?sysctl.conf也没修改?


你把所有需要的依赖包都安装好,然后relink all吧

使用道具 举报

回复
论坛徽章:
32
优秀写手
日期:2014-07-23 06:00:13秀才
日期:2016-08-05 10:34:04秀才
日期:2016-08-05 10:34:04秀才
日期:2016-08-05 10:28:31秀才
日期:2016-08-05 10:33:40技术图书徽章
日期:2016-08-05 10:29:11秀才
日期:2016-08-05 10:28:57秀才
日期:2016-08-05 10:28:57秀才
日期:2016-08-05 10:28:57秀才
日期:2016-09-27 15:16:21
 楼主| 发表于 2017-12-4 15:51 | 显示全部楼层
zergduan 发表于 2017-11-28 09:31
glibc-2.3.4-2.41 (i686)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
这个包当时你都没装?sysctl.co ...


我重新定义了sysctl.conf 再安装检查时,系统中报的问题是
[oracle@iZ2zehy7gff0kpg1swp1czZ database]$ cat /home/oracle/oraInventory/logs/installActions2017-12-04_03-19-22PM.log|grep Error
INFO: Error Message:PRVF-7530 : Sufficient physical memory is not available on node "iZ2zehy7gff0kpg1swp1czZ" [Required physical memory = 1GB (1048576.0KB)]
INFO: Error Message:PRVF-7575 : Encountered an internal error. The range of reference data for verifying swap size has not been correctly defined
INFO: Error Message:PRVF-7543 : OS Kernel parameter "semmni" does not have proper value on node "iZ2zehy7gff0kpg1swp1czZ" [Expected = "128" ; Found = "0"].
INFO: Error Message:PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "glibc-2.3.4-2.41 (i686)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "compat-libstdc++-33-3.2.3 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "libaio-devel-0.3.105 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "libgcc-3.4.6 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "libstdc++-3.4.6 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "unixODBC-2.2.11 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "unixODBC-devel-2.2.11 (i386)" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
INFO: Error Message:PRVF-7532 : Package "pdksh-5.2.14" is missing on node "iZ2zehy7gff0kpg1swp1czZ"
我的系统是centos7
对于semmni 已经设置成128,单检查仍然报错
对于glibc-2.3.4-2.41 (i686) 这个包,系统里现在有最新的glibc-2.17包,pdksh-5.2.14网上说也是老包可以忽略。
于是我忽略这些问题安装后的界面提示
[oracle@iZ2zehy7gff0kpg1swp1czZ database]$ ./runInstaller  -ignorePrereq -silent -force -responseFile  /home/oracle/etc/db_install.rsp
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 24670 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 199 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-12-04_03-22-27PM. Please wait ...[oracle@iZ2zehy7gff0kpg1swp1czZ database]$ You can find the log of this install session at:
/home/oracle/oraInventory/logs/installActions2017-12-04_03-22-27PM.log

[oracle@iZ2zehy7gff0kpg1swp1czZ database]$ The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root scripts to run

/u02/oracle/product/11.2.0/dbhome_1/root.sh
To execute the configuration scripts:
         1. Open a terminal window
         2. Log in as "root"
         3. Run the scripts
         4. Return to this window and hit "Enter" key to continue

Successfully Setup Software.
这样是不是说明安装没问题了呢??

安装监听的信息如下
[oracle@iZ2zehy7gff0kpg1swp1czZ database]$ $ORACLE_HOME/bin/netca /silent /responsefile /home/oracle/database/response/netca.rsp

Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /home/oracle/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control:
      /u02/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@iZ2zehy7gff0kpg1swp1czZ database]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-DEC-2017 15:49:13

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1523)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-DEC-2017 15:49:07
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u02/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u02/oracle/diag/tnslsnr/iZ2zehy7gff0kpg1swp1czZ/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=iZ2zehy7gff0kpg1swp1czZ)(PORT=1523)))
The listener supports no services
The command completed successfully
[oracle@iZ2zehy7gff0kpg1swp1czZ database]$

然后 我sqlplus / as sysdba 和 安装了数据库以后,都报
ERROR:
ORA-12547: TNS:lost contact

本机hosts文件内容如下
[oracle@iZ2zehy7gff0kpg1swp1czZ database]$ cat /etc/hosts
#127.0.0.1   localhost
#::1         localhost
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
172.17.225.197 iZ2zehy7gff0kpg1swp1czZ

所以能否帮忙分析下现在问题在哪,如何静默安装上数据库啊 谢谢




使用道具 举报

回复

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

本版积分规则

TOP技术积分榜 社区积分榜 徽章 电子杂志 团队 统计 虎吧 老博客 知识索引树 读书频道 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档 | IT博客
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛 | SAP ERP系统
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 网站律师 隐私政策 知识产权声明
京ICP备16024965号 北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表