OraFAQ Forum: RAC & Failsafe » Inserts problem with Rac

Home » Server Options » RAC & Failsafe » Inserts problem with Rac

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Inserts problem with Rac [message #244918]

Thu, 14 June 2007 10:27

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

Report message to a moderator

Re: Inserts problem with Rac [message #244921 is a reply to message #244918]

Thu, 14 June 2007 10:33

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

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

Report message to a moderator

Re: Inserts problem with Rac [message #244959 is a reply to message #244950]

Thu, 14 June 2007 13:25

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.

Code: [Select all] [Show/ hide]

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)
    )
  )

Report message to a moderator

Previous Topic:	install Oracle rac 64 on sles 10 64bit
Next Topic:	Shared Oracle Binaries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 00:13:33 CDT 2025