windows authentication/local system logon - Oracle XA

I am fairly new, and a little confused.
If we want to allow applications such as oracle-xa to log on via dtcc etc, and the user login is currently set to use the local system account, does that user have to have an entry in ora_dba group to be allowed to connect to the database
Can you not use windows authentication without the user being in that group.
I thought that group allowed any specified user to basically connect as SYS and with DBA priviledges. We don't really want the user to have dba priviledges, but do want them to be able to log on to select things from the database.
We are getting errors because the XA transaction manager is attempting to perform recovery with XA resource manager unsuccessfully. It cannot log on to get the in-doubt transactions I believe. But everything else that needs to be in place is in place, just that the windows user is not in the ora_dba group, but he is set to use the local system account to log in.

Posted On: Monday 12th of November 2012 12:06:51 AM Total Views:  718
View Complete with Replies

Related Messages:

view Oracle database installed on HP-UX from windows   (231 Views)
How can i view this database from windows - will Win SQL work If yes then how to create DSN for oracle database - which type of driver should be added - on a windows machine
unable to install oracle 8.1.7 EE on windows 200 prof   (334 Views)
I have an intel p 4 1.3 GHz with 40 GB and 128 MB RDRAM. I attempted to install oracle 8.1.7 EE on it and the OUI fails (or dies) as I select install/Deinstall. I am using windows 2000 professional SP 1. What could be the problem Geo.
Why personal 8.1.7 for win 98 does not install in windows milenium edition?   (232 Views)
I am trying to install the personal for tests in my house. I have windows milenium edition , and after you vary attempts I did not obtain.
Slow access to v$ views from windows SQL*Plus   (218 Views)
RDBMS Version: Operating System and Version: SunOS 5.8 I'm trying to run the following query against Oracle database using different clients (this is just an example,actual queries are different, but suffer from the same problem): select count(*) from v$sesstat; It takes more than a second if I use windows SQL*Plus ( If I use Linux(client version or Sun box(same machine as a server, to run the same query against the same database I'm recieving the answer right away. I traced two sessions one from windows machine and another from linux box. Linux machine; ******************************************************************************** select count(*) from v$sesstat call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.23 0.23 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.23 0.24 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 32 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=0 r=0 w=0 time=239699 us) 3523 FILTER (cr=0 r=0 w=0 time=237001 us) 3640 FIXED TABLE FULL X$KSUSESTA (cr=0 r=0 w=0 time=229674 us) 1 FIXED TABLE FULL X$KSUSGIF (cr=0 r=0 w=0 time=10 us) ******************************************************************************** Windows machine: ******************************************************************************** select count(*) from v$sesstat call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 1.58 1.57 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 1.58 1.57 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 32 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=0 r=0 w=0 time=1572900 us) 3252 FILTER (cr=0 r=0 w=0 time=1570315 us) 3360 FIXED TABLE FULL X$KSUSESTA (cr=0 r=0 w=0 time=1563156 us) 1 FIXED TABLE FULL X$KSUSGIF (cr=0 r=0 w=0 time=129 us) ******************************************************************************** Why such a big difference How to fix it
unable to install oracle 8.1.6 on pentium 4 ,windows 2000 enterprise edition   (405 Views)
hi, i am not able to install oracle 8.1.6 on pentium 4 wondows 2000 enterprise edition machine. Nothing happens..... any ideas
PO816 & windows Me   (183 Views)
Does PO8 work win me I am geting error in installations. says error in staging area or destination. Any info or link or do I have to revert to win 98 Kailash Pareek
OS image copy (windows) to move database and oracle binary (8, 9i) to another server   (215 Views)
OS image copy (windows) to move database and oracle binary (8, 9i) to another server with new server name and ip address. Any one have been done this before OS is windows 2000 or 2003. database version is 8i and 9i. As for server name /ip address change, for oracle database, I only need to change tnsnames.ora and listener.ora. May need to make sure init file don't have any server name. May also need to delete OEM agent file. May need to update C:\WINDOWS\system32\drivers\etc\hosts file. Anything else I have to do for change server name and IP address Any one know is there anywhere hard-coded server name in windows registry Any need to delete , then, create oracle services I don't think we need to do this since database instance and database name are same, no change. I know after change server name. OEM will not work. It used to have utility to change servername for OEM. but since it is not in my scope. I jusr ignore this for now. In Unix, there is oracle utility relink(make) to relink oracle binary. Any one know is there any similar oracle utility on windows don't know much about oracle on windows. Thank you for your help. xyz2000
Two instances for a single database targeting Oracle 10g on windows platform   (464 Views)
Hi all, Database: Oracle 10g (Server) Operating system: Windows XP SP2 Now, i want to create two instances for a single database, is that possible With RAC yes, of course that is possible....but normally working on: Steps i followed: 1. Created one more instance with ORADIM utility. 2. The same is displayed appropriately in services.msc 3. Copy/pasted the init.ora file and updated the new copy/pasted db_name to 'ORCL2' where in by default the original init.ora file had db_name as 'ORCL' Instance ORCL2 is not recongized..... Please help,
Scheduling a Job in windows??   (208 Views)
How do you in the Windows enviornment automate a script to run at some predetermined time. I looked at the SCHEDULED TASKS folder in the control panel but the setup wizard is only accepting an .EXE. What if I just want to run a .TXT file script.
router issue windows xp   (282 Views)
I want to access oracle from the internet. I have a netgear router and the PC is connected to the router. The router has an external ip address. I have opened port 1521 on the router and forwarded to the PC that has oracle. What else is needed to connect to the db In the tns names for4 the client the ip address I believe is that of the router. The port is 1521 since that is the port I have opened.
RAC (10.2) with OCFS on windows 2003   (189 Views)
Can some point me to step by step installation of Oracle 10.2 RAC with OCFS on 2 nodes (2 Windows 2003 server). I got one for Oracle 9i with patches from metalink note: 178882.1 but I need for 10.2 version. I have no prior experince with RAC and need step by step info/document/details.
problems of oracle 8i with windows 2000   (247 Views)
What is the problems of oracle 8i with windows 2000
startup /shutdown on windows 2000 scripts   (193 Views)
does any body have a small scripts to shutdown and startup on windows 2000
oracle8.1.7 on windows2000- client can't connect   (356 Views)
Hi all, I am testing client side connection. Client side: window2000, oracle 8.1.7 client Server: oracle 4.0 -sp6 I can connect from my laptop to my production DB using sqlplus user/password@Servicename. then I go to registry and set LOCAL=ServiceName (under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/) now I can use user/password to connect to my remote server, and don't have to provide my service name (my laptop is window2000 professional) I have another machine (windows2000 server) and I did the same thing, but I can not make use user/password work. It returned ORA-12560: TNSrotocol adapter error. Do anyone of you know how to fix it I deinstall and re-install again, same thing. Please help... Thank you
convert text latin2(iso-8859-2/mysql/unix) to windows unicode   (412 Views)
Hi I am struggeling for long time to convert text get from mysql database (unix) in latin2 encoding (iso-8859-2) to unicode on windows environement. I read data from db: string title = ""; using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(connString)) { using (MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand(query, conn)) { conn.Open(); MySql.Data.MySqlClient.MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int ndx1 = reader.GetOrdinal("Title"); title = reader.GetString(ndx1); } conn.Close(); } } thetitle string containiso-8859-2, how to convert it to Unicode for instance Is possible the read bytes by reader (but the column which is not binary type - for typical varchar)
Populate windows form from Dataset   (298 Views)
Can someone please point me out to the correct way to retrieve data from a dataset and populate a windows form I have an Oracle Dataset which retrieves a table but I am unsure of the correct method to populate the windows form fields. There may be another post I made similar to this which I dont know if it posted correctly. If so, sorry for the repost.
problems with windows XP and Win 2003   (389 Views)
Hi Guys, I've been using MySqlDriverCS to connect to mysql on a Win 2000 machine and everything was working fine. But now we need to move to a Win 2003 machine. The ASP.NET andWindows applicationsrun fine at the start but after a while when too many queries are made it refuses to connect to mysql. After I leave it idle for a while it goes back to running fine but then crashes again when too much load is put on. Its the same problem with Win XP but runs fine on Win 2000 machines. I thought it might have been the MySqlDriverCS so I tried using MySql Connector .NET but still have the same problem with XP and 2003. Anyone know what might be the problem Any ideas
Can not connect oracle db from vb dot net application in 64 bit windows 7   (266 Views)
My dot net windows application (visual studio 2008, is running fine on 32 bit windows XP. But in 64 bit windows 7 it can not connect the oracle 10g database. The application was originally on vb6. It was converted into I am using the following connection string. StrConn = "Provider=MSDAORA.1; Data Source=ABC;User Id=XYZ;Password=XYZ123;"
Can't connect to Oracle via windows service .. but CAN via regular app   (252 Views)
I have a weird problem: My app makes it possible to sychronize two databases (an Sql Server one and an Oracle one). This can be done by both an script and a Windows Service. The ASP.NET script and the .NET windows service use the SAME code. The ASP.NET script is able to do what I want The windows service CAN connect to the SQL server but NOT to the Orace client. (See error of the event viewer below) Do I have to do something in the windows service the ASP.NET does automatically Does anyone know why he doesn't want to connect /////ERROR: Service cannot be started. System.Data.OracleClient.OracleException: ORA-12154: TNS:servicenaam kon niet worden herleid. at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() at be.vintage.PMECSynchro.Synchro.doSync() at ECPMSynchroService.ECPMSynchroService.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state) For more information, see Help and Support Center at
Is windows xp prof supports Oracle 8i...?   (233 Views)
I succeeded in installation of oracle 8i enterprise edition on windows xp professional. It worked fine. But I failed to start Oracle 8i, when I restarted the system... why it is Is there any solution.... ThanQ..... Rajasekhar Pediredla