[Spacewalk-list] fix oracle SID/HOST/tnsnames ?

Jan-Frode Myklebust janfrode at tanso.net
Tue Jul 27 07:33:57 UTC 2010


During the installation I pointed spacewalk against DB SPACEWALK1 running
on server1 on our Oracle RAC, and now that we're having some downtime on
server1 that's causing us some hopefully unneccessary downtime.

Could someone help us configure spacewalk talk to database "SPACEWALK",
as defined by this tnsnames.ora:

SPACEWALK =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb1-vip.example.net)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb2-vip.example.net)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = spacewalk)
    )
  )

SPACEWALK2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb2-vip.example.net)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = spacewalk)
      (INSTANCE_NAME = spacewalk2)
    )
  )

SPACEWALK1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb1-vip.example.net)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = spacewalk)
      (INSTANCE_NAME = spacewalk1)
    )
  )



  -jf




More information about the Spacewalk-list mailing list