How to Fix: The trust relationship between this workstation and the primary domain failed

Some time trust between workstation and primary domain faile so I cant log on as domain user or map network drive or share. When I try to map shared folder from such server or workstation I usually get error: windows error 0x80004005.
There are few solutions but most popular is to remove server or workstation from domain, restart and join again.
Microsoft gave us some tools to do that without removing server from a domain.

1. Use Powershell: Start Windows Powershell as administrator than write:

Reset-ComputerMachinePassword -Server <Name of any domain controller> -Credential <domain admin account>

2. Use netdom: Start command prompt as administrator than write:

netdom resetpwd /Server:<name of any domain controller> /UserD:<domain admin account> /PasswordD:<password>

I usually reboot server after to be completely sure that server joined domain.

Weblogic - Change locale for ADF Server

Recently on a project i had an ADF application which was using date and sort formats in en/GB regional settings. Since i need to use Croatian date formats i need to change it in Weblogic server.

• Login to Weblogic Administration Console
• Choose Servers
• Choose ADFServer (the name it gets from installation)
• Select Configuration à Server Start tab
• Select Lock&Edit to be able to insert new values
• Insert into Arguments field: -Duser.language=hr -Duser.country=HR with space between or multi line
• Save Configuration
• Restart ADF Server

Language and Territory Values could be found on: http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e15524/ui_localize.htm#CACFBBIE

Setting Toad NLS_LANG when using Oracle Instant client in Windows

When I use Toad (any version) with the Oracle Instant client i usually get mixed up session NLS parameters. When i have some kind of Oracle development tools i need to edit just NLS_LANG registry key in my preferred home.
When i use instant client easiest way is to edit directly through Toad:

First step is to click on the 3 dots near Oracle home used. If NLS_LANG is empty double click on it and answer "Yes" to "Are you sure" question, Enter the preferred NLS_LANG and Toad will populate required Oracle keys in the registry.

BI Publisher OC4J as a Windows service

To install Bi Publisher as a Windows service and forgot about OC4Jstart.cmd skript You need to do following:

• Download Java service

                     http://forge.ow2.org/projects/javaservice/

• Copy Java service to a folder on Oracle Application server (OAS)

         C:\oracle\javaservice

• Install Java JDK 1.6u45 on OAS

•  Go to BI Publisher OC4J folder  c:\ORACLE\Bipublisher\oc4j_bi\bin and check oc4j.cmd for JVMARGS :

         Set JVMARGS=-XX:MaxPermSize=128m  –Xmx512m  %OC4J_JVM_ARGS

•  Go to c:\oracle\javaservice in command prompt and run

javaservice -install "ORACLE BIP OC4J" "C:\Program Files\Java\jdk1.6.0_45\jre\bin\client\jvm.dll" -XX:MaxPermSize=128m -Xmx512m "-Djava.class.path=C:\ORACLE\BIPUBLISHER\oc4j_bi\j2ee\home\oc4j.jar" -start oracle.oc4j.loader.boot.BootStrap -out "C:\bip.log.txt" -err "C:\bip.err.txt" -description "Oracle BI EE OC4J Service"

• Go to sevices.msc and start ORACLE BIP OC4J service

Restricting users from some components in Apex 4.2 application

• Create Groups to differentiate users:

• Edit users and add them to Groups. If a user is Administrator than put it in Admin group.
• Go to Application builder  -> Application -> Shared Components -> Authorization Schemes and create a new Authorization Scheme.
• Select From Scratch
• In Authorization Scheme put following PL/SQL

• Go to the Application page that you want to prevent all users seeing (only Admin group)  and in Security choose the scheme you want:

How to create test user in test database from production database with impdp

Some time ago i had a need to create identical user on a test database every hour. To solve that i used impdp ability to use transfer over database link.
I have two databases . Production "db_prod" and test database "db_test". User that i am transferring has to preserve its name for easier testing.

1. Create public database link on db_test as SYSTEM:
 create a public database link DB_PROD connect to system identified by xxxxx using ‘DB_PROD_ALIAS’;

2. Insert data (create users and all) from db_prod to db_test with impdp:
impdp system/xxxxxx@db_test schemas=user_prod network_link=db_prod_alias

This way there is no need to use remap_schema since both user names are the same. There is no need to use data_pump_dir because all transfer is done by database link.
There is some more job to be done. I ran script by hand at first to see what objects are giving me warning (Roles, references to another user) and to create a script to prepare test database for fresh injection of a test user. That means usually to drop existing user from db_test, create roles if needed (impdp will fill them with appropriate grants).

Install Oracle Developer 6i on Windows 7 x64

I have a need to install Oracle Forms and Reports Developer suite 6i  with patch 14 on much newer WIndows 7 Professional 64-bit. At first attempt i tried and succeeded to install it all in 64 bit environment using Compatibility options but when i started to work with the tools i encountered many problems.
Next step was to install it in Windows Virtual PC )XP Mode). Steps to do so are:

1. Install Windows XP mode and Virtual PC as in instructions: http://windows.microsoft.com/en-us/windows7/install-and-use-windows-xp-mode-in-windows-7
2. Download and install XP mode : http://www.microsoft.com/en-us/download/details.aspx?id=8002
3. Download and install VirtualPC : http://www.microsoft.com/en-us/download/details.aspx?id=3702
4. Create default XP machine and edit settings (i usually get RAM to 1GB):

After that i started XP mode, set up initial password for XPMode (this is required. Windows XP mode remembers this password, but in later actions it can ask for it. Sometimes when that password is blank, XPmode throws an error. On this site there is a manual how to reset: http://www.mydigitallife.info/resetand-fix-incorrect-or-wrong-password-for-windows-xp-mode-xpmuser/) and install Developer 6i. After that i put valid tnsnames.ora and sqlpnet.ora at %ORACLE_HOME%\network\admin directory.

Now Developer tools could be run directly in XPmode machine (some people find it easier) or from Windows 7 Start menu: