1,440 reputation
32848
bio website
location
age
visits member for 3 years, 3 months
seen 51 mins ago

Apr
5
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
I also removed (commented out) SQLNET.AUTHENTICATION_SERVICES=(NTS) from the sqlnet.ora file. Same result, ORA-01031 error remains.
Apr
5
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
I deleted Oracle client directory and all the subdirectories. Then I removed client from the PATH variable. Then I deleted the client registry entry using regedit. After this, I rebooted the server. Now, when running splus / as sysdba, I get the same error.
Apr
4
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
No, there is no "deinstall" directory in the oracle client directory. There seems to be no way to deinstall oracle client?
Apr
4
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
Yes, but there is not this Universal Installer. I installed instant client from the installation media, and as the documentation says, instant clinet installation does not install oui.exe. But running oui.exe from the installation media does not give me a choice to uninstall. I'll have to check that deinstall directory.
Apr
3
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
Where I can find the Uninstall-option. When I follow this guide (docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm) it says to use oui.exe. Tried to use it from the unzipped client folder, but it does not give an option to choose 'uninstall'. How to uninstall the client?
Mar
29
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
Yes, UAC is on the lowest level, and I always run cmd as admin.
Mar
27
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
Yes, I know that now, but the question is how to solve the problem at hand.
Mar
27
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
No, I don't have that variable on my environmental variables list. Does it have to be? This worked before the client installation, and I did not have that variable at that time either.
Mar
27
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
I added those files into the question.
Mar
27
comment How to resolve ORA-01031: insufficient priviledges error on Windows installation?
Yes, my account is also in the Administrator group.
Mar
13
comment how do I insert a default row?
Yes, GO 1000 seems to be much easier. Thanks for that.
Sep
26
comment How to debug deadlocks in SQL Server 2008 R2?
Maybe you could try using Activity monitor and sp_who2 to find what are the locking processes.
Sep
26
comment How to document Oracle database?
Thanks for this answer but I think you misunderstood my question. I know that I can query these objects, but how can I write my own metadata e.g for columns? If if have a column CustomerID I might want to add 'Surrogate id generated by ETL-process`. See for example this link
Sep
9
comment Does Oracle server installation include client components?
@Phil: I can accept your comment as an answer if you post is as an answer...
Aug
29
comment Why should a CTE start with a semi-colon?
I asked the same question in SO awhile ago: stackoverflow.com/questions/6938060/…
Aug
26
comment Correlated subquery and join: still the same exectution plan?
Well, yes, but why they yield the same execution plan?
Aug
25
comment Why database diagrams are not working when domain account is attached to database owner?
Thanks, very good answer! Now I understand how it works.
Aug
25
comment Why database diagrams are not working when domain account is attached to database owner?
Yes it is......
Aug
25
comment Why database diagrams are not working when domain account is attached to database owner?
The Compatibility Level is set to 100, I'm using SQL Server 2008 R2.
Jun
6
comment Release SQL Server Memory usage
Please see this question: dba.stackexchange.com/questions/6691/…