| 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
|
|
|
|
|
|
| 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
|
|
|
|
| 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.
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)
)
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
