精华内容
下载资源
问答
  • 1,问题描述,dbca最后 finish的时候报错 ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address ‘(ADDRESS=(PROTOCOL=TCP)(HOST=pldb236)(PORT=1521))’ ,...

    1,问题描述,dbca最后 finish的时候报错
    ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address ‘(ADDRESS=(PROTOCOL=TCP)(HOST=pldb236)(PORT=1521))’ ,如下图所示

    在这里插入图片描述

    在这里插入图片描述

    2,去hosts里面添加hostname
    [root@pldb236 data]# cat /etc/hosts

    127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4pldb236

    ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

    [root@pldb236 data]#

    然后再重新dbca,就可以顺利创建oracle库了。

    报错原因是因为创建的是找不到hostname名字,所以报错。安装软件的第一步 就会去检测你的host里有没有对应的自己的主机名,安装oracle软件的时候可能这个忽略了,但是dbca建库就需要仔细验证,dbca建好库后执行netca操作就会报错的。

    原文链接:https://blog.csdn.net/csdnhsh/article/details/94280257

    展开全文
  • dbca建库报错

    2021-05-07 13:59:08
    Stack: [0xffe0b000,0xffffd000), sp=0xffff9db8, free space=1979kNative frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)C [libc.so.6+0x62b69] __libc_free+0x49C [libclntsh.so...

    Stack: [0xffe0b000,0xffffd000),  sp=0xffff9db8,  free space=1979k

    Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)

    C  [libc.so.6+0x62b69]  __libc_free+0x49

    C  [libclntsh.so.10.1+0x4bc2b2]  snlinFreeAddrInfo+0x5e

    C  [libnjni10.so+0x5e59]  Java_oracle_net_common_NetGetEnv_getLocalHostName+0xe3

    j oracle.net.common.NetGetEnv.getLocalHostName()Ljava/lang/String;+0

    j  oracle.net.config.Config.systemName()Ljava/lang/String;+36

    j  oracle.net.config.DirectoryService.getSystemObjectPath(Loracle/net/config/Config;)Ljava/lang/String;+6

    j  oracle.net.config.DirectoryService.qualifyObjectName(Loracle/net/config/Config;Ljava/lang/String;Z)Ljava/lang/String;+36

    j  oracle.net.config.Listener.(Loracle/net/config/Config;Ljava/lang/String;)V+37

    j  oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(Ljava/lang/String;Ljava/lang/String;)Loracle/net/config/AddressConfig;+9

    j  oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(Ljava/lang/String;)Loracle/net/config/AddressConfig;+3

    j  oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddressForPort(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;+2

    j  oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddress(Ljava/lang/String;)Ljava/lang/String;+4

    j  oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddresses([Ljava/lang/String;)[Ljava/lang/String;+25

    j  oracle.sysman.assistants.util.NetworkUtils.needLocalListener([Ljava/lang/String;)Z+2

    j  oracle.sysman.assistants.util.step.StepContext.setListenersToUpdate([Ljava/lang/String;)V+28

    展开全文
  • 安装oracle发现/etc/profile和.bashrc环境变量设置有冲突,oracle用户的$ORACLE_HOME没生效 Question: After increasing by "processes" parameter (processes 3000), I got the following ORA-00838 error...
    安装oracle发现/etc/profile和.bashrc环境变量设置有冲突,oracle用户的$ORACLE_HOME没生效
     
     
    Question:  After increasing by "processes" parameter (processes 3000), I got the following ORA-00838 error at database startup time.  Note that I am on 12c and I have not set my sga_target or pga_aggregate_target parameter.  After re-setting processes=1000 the ORA-00838 error disappeared.  Why?
     
    ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3072M
    ORA-01078: failure in processing system parameters
    How do I correct the ORA-00838 error?
     
    Answer:  The oerr utility  shows the cause and action for the ORA-02097:
     
    ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least string
     
    Cause: The specified value of MEMORY_TARGET was less than the sum of the specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.
     
    Action: Set MEMORY_TARGET to at least the recommended value.
     
    In this case the increase of your processes parameter was the root cause of the ORA-00838 error.  As we my know the processes parameter determines the sessions parameter that this must, in turn, indicate to Oracle that additional RAM is required to support the extra sessions.
     
    As a workaround, of course, you can increase your memory_target parameter value.
     
    由于安装过程中将进程数量由初始值300调到5000导致所需内存增加,保持初始值不变即可顺利安装



    转载于:https://www.cnblogs.com/syyap/p/7143156.html

    展开全文
  • linux dbca启动报错

    千次阅读 2018-06-08 00:12:19
    花了我大半天的时间一直在找原因。...我也配置了下export DISPLAY=192.168.247.100:0.0 启动过后还是报错,最后我在/home/oracle下配置export DISPLAY=:0.0然后启动dbca尽然成功了,记下来方便其他人找错误。...

    花了我大半天的时间一直在找原因。网上查了很多,说什么DISPLAY配置不对。我也配置了下export DISPLAY=192.168.247.100:0.0 启动过后还是报错,最后我在/home/oracle下配置export DISPLAY=:0.0然后启动dbca尽然成功了,记下来方便其他人找错误。

    展开全文
  • 之前参考视频和Oracle的官方文档成功安装好了11g,为了巩固一下学到的知识,又重新在虚拟机上安装Oracle9i,从安装CentOS4.8开始一步一步安装下来还算顺利,只是软件安装完成后,准备运行netca和dbca的时候出现错误...
  • An unexpected exception has been detected in native code outside the VM....at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94) at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)
  • Linux DBCA 报错ORA-00119 ORA-00130

    千次阅读 2014-02-28 13:23:36
    错误来源: 将一个EXPDP导出的库导入到现在服务器,发现字符集有问题,服务器安装的是西欧字符,然后DMP包确实简体中文; 于是删掉实例,重新安装,在安装的时候就出现了ORA-00119与ORA-00130错误,无法继续了。...
  • 在安装oracle12C RAC时,无任何报错,db的安装同样都是ok的,但是在使用dbca创建数据库时报错如下图:个人部分配置如下:limits.conf:oracle soft nproc 16384oracle hard nproc16384oracle soft nofile 65536...
  • 有个AIX单实例的环境dbca无法创建数据库,后来发现dbca -help都报错 nzo2pdb:/u01/app/oracle/product/11.2.0/db_1/bin>dbca -help Exception in thread "main" java.lang.NoClassDefFoundError: ...
  • 执行dbca创建数据库运行到2%的时候,报如下错误:ORA-27504 IPC error creating OSD contextORA-27300 OS system dependent operation sendmsg failed with state 59ORA-27301 OS failed message ...
  • $ dbca UnsatisfiedLinkError exception loading native library: njni11 java.lang.UnsatisfiedLinkError: /opt/app/oracle/product/11.2.0/dbhome_1/lib/libnjni11.so: /opt/app/oracle/product/11.2.0/dbhome_1/...
  • 最近朋友安装oracle的时候,给我留言说:执行dbca的时候报错,ORA-12532:TNS:invalid argument错误,如下图所示: 我让他去看下图片中的日志详细内容,他查了详细日志,如下所示: 我大概从以下几个...
  • AIX7.1创建数据库实例报错:PRCR-1079 CRS-2674 CRS-2632一、权限问题:1、尝试手动启动数据库服务:2、grid用户添加到dba组二、psu-bug导致数据库实例启动...但是在dbca创建数据库96%时报错:没有其他服务器可以尝试放
  • 朋友安装oracle的时候,执行dbca的时候报错,ORA-12532:TNS:invalid argument错误,如下图所示: 我让他去看下图片中的日志详细内容,他查了详细日志,如下所示: 我大概从以下几个方面去排查问题: ...
  • DBCA报错, ORA-15045 ORA-17502 ORA-15081 ERROR at line 1: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /u02/app/oradb/product/11.2.0/db_1/assistants/dbca/...
  • oracle dbca启动报错

    千次阅读 2013-09-02 11:44:17
    今天在AIX操作系统上安装Oracle 11.1时,遇到在执行runInstaller后无法启动安装图像化界面,甚是郁闷。 问题现象: 使用Xmanager2.0软件登陆AIX桌面,root用户可以启动xclock钟表,在使用“xhost +”命令后su...

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 5,041
精华内容 2,016
关键字:

dbca报错