Home » Server Options » RAC & Failsafe » Inserts problem with Rac
Inserts problem with Rac [message #244918] Thu, 14 June 2007 10:27 Go to next message
salvadormier
Messages: 2
Registered: June 2007
Location: Mexico
Junior Member

Hi

I was working with oracle 10g in a OS solaris 9 and powerbuilder 8 application apparently without problems, however when i change to Oracle Rac with OS AIX started to experience inserts problems with the same application, the developers think that is a problem of the database.

Thanks
Re: Inserts problem with Rac [message #244921 is a reply to message #244918] Thu, 14 June 2007 10:33 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you change your application requirements according to the Rac.
Did you bind your application to the node??

[Updated on: Thu, 14 June 2007 10:34]

Report message to a moderator

Re: Inserts problem with Rac [message #244950 is a reply to message #244921] Thu, 14 June 2007 12:56 Go to previous messageGo to next message
salvadormier
Messages: 2
Registered: June 2007
Location: Mexico
Junior Member

what kind of requirements need an application with rac ?

and by the second question i send the tnsnames configuration


PRODUCTION =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.82)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.83)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.84)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER=ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PRODUCTION)
(FAILOVER_MODE = (BACKUP=PSCORP.FAIL1) (TYPE=SELECT) (METHOD = basic))
)
(RETRIES=20)(DELAY=15)
)


THANKS

Re: Inserts problem with Rac [message #244959 is a reply to message #244950] Thu, 14 June 2007 13:25 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
From where you insert data into ur database through your application or sqlplus?
And is that web-based application?
Because we have the same situation with our web-based application beacuse when we moved from single node to 2-nodes then you must change some parameters for your aplication.
Heres the sample tnsnames.ora which we used.
UCHOOSE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
    )
  )

LISTENERS_UCHOOSE =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
  )

UCHOOSE2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
      (INSTANCE_NAME = UCHOOSE2)
    )
  )

UCHOOSE1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
      (INSTANCE_NAME = UCHOOSE1)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
Previous Topic: install Oracle rac 64 on sles 10 64bit
Next Topic: Shared Oracle Binaries
Goto Forum:
  


Current Time: Sun Dec 04 06:26:13 CST 2016

Total time taken to generate the page: 0.10571 seconds