Author Topic: Lookup failed for 'jdbc/SPECDB',specvirt fail to run.  (Read 46417 times)

xxltomail

  • Newbie
  • *
  • Posts: 19
  • Karma: +0/-0
Re: Lookup failed for 'jdbc/SPECDB',specvirt fail to run.
« Reply #15 on: March 12, 2015, 03:04:20 AM »
[root@appserver config]# ping specdb
PING dbserver1-int (10.10.1.5) 56(84) bytes of data.
64 bytes from dbserver1-int (10.10.1.5): icmp_seq=1 ttl=64 time=2.53 ms
64 bytes from dbserver1-int (10.10.1.5): icmp_seq=2 ttl=64 time=1.82 ms
^C
--- dbserver1-int ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1308ms
rtt min/avg/max/mdev = 1.822/2.177/2.532/0.355 ms
[root@appserver config]#

[root@appserver config]# psql -h specdb -U spec -d SPECDB
psql: FATAL:  database "SPECDB" does not exist
[root@appserver config]# psql -h specdb -U spec -d specdb
psql (9.2.5)
输入 "help" 来获取帮助信息.

specdb=# \d
                     关联列表
 架构模式 |         名称         |  型别  | 拥有者
----------+----------------------+--------+--------
 public   | c_customer           | 资料表 | spec
 public   | c_customerinventory  | 资料表 | spec
 public   | c_parts              | 资料表 | spec
 public   | c_site               | 资料表 | spec
 public   | c_supplier           | 资料表 | spec
 public   | m_bom                | 资料表 | spec
 public   | m_inventory          | 资料表 | spec
 public   | m_largeorder         | 资料表 | spec
 public   | m_parts              | 资料表 | spec
 public   | m_workorder          | 资料表 | spec
 public   | o_item               | 资料表 | spec
 public   | o_orderline          | 资料表 | spec
 public   | o_orders             | 资料表 | spec
 public   | s_component          | 资料表 | spec
 public   | s_purchase_order     | 资料表 | spec
 public   | s_purchase_orderline | 资料表 | spec
 public   | s_site               | 资料表 | spec
 public   | s_supp_component     | 资料表 | spec
 public   | s_supplier           | 资料表 | spec
 public   | txn_log_table        | 资料表 | spec
 public   | u_sequences          | 资料表 | spec
(21 行记录)

specdb=# \q

AnoopGupta

  • Jr. Member
  • **
  • Posts: 60
  • Karma: +0/-0
Re: Lookup failed for 'jdbc/SPECDB',specvirt fail to run.
« Reply #16 on: March 15, 2015, 11:58:42 PM »
I have not spotted anything out of order. The only thing remaining to be checked seems to ensure that the firewall is disabled on the VMs.

Other than that, please ensure that you have the following in the domain.xml:
- upper case SPECDB when referring to jdbc/SPECDB in all places
- lower case specdb in all other places

If the issue persists, Please provide OS version on the VMs.

xxltomail

  • Newbie
  • *
  • Posts: 19
  • Karma: +0/-0
Re: Lookup failed for 'jdbc/SPECDB',specvirt fail to run.
« Reply #17 on: March 22, 2015, 09:36:16 PM »
thank you ,i reinstall the dbserver,this issue disappeared.But I met with some other problems...