Browsed by
Month: June 2016

Oracle secure backup. It DOES work on windows

Oracle secure backup. It DOES work on windows

A while ago I was asked to implement a filesystem backup on a windows server. How hard could it be and basically it’s not too difficult. Only one minor thing is not too well documented and I would like to highlight this here.

In this particular setup the service was running under the local system account. Personally I would like to see it under a local user account.

In order to be able to perform a succesfull filesystem backup, we need to teach oracle secure backup how to log on to this system.

Two methods can be chosen.

  • adapt the current configured admin user
  • create an extra user for the windows filesystem backups

In this case the second option was chosen for clarity to split the windows filesystem backups from the linux ones. It’s a choice.

osb_configure_user01

 

And in the users screen click “add”.

Choose a username and enter a password and change “NDMP server user” from yes to “no” and click “Apply”

You will be redirected to following screen:

osb_add_user01

2 buttons at the top/bottom are needed now.

First choose the windows-domains button and you see the default:

osb_add_user02

In this case we don’t have a domain account, so we need to teach him to use the local administrator account:

osb_add_user03

Domain name is the hostname of the windows guest and the Administrator is the local administrator and the password is the password for the local administrator.

Then click add and go back to the user configuration.

Click on the “Preauthorized Access” button and edit accordingly

osb_add_user04

 

Then it’s just configuring this client as you would configure another one.

It took me some windows-like thinking while I was expecting this to be in the documentation.

 

As always, questions, remarks? find me on twitter @vanpupi

 

 

mac os x + 12c thin client

mac os x + 12c thin client

Sometimes it’s time to upgrade. So the I decided to add the oracle 12c thin client to my mac a couple of weeks ago. Yes I know, I was very happy with the oldy-but-goodie 10g version, but ok.

The 12c instant client is very easy to install. I remember it took quite some time to install the 10g version, so happy about that. Unzipping the zipfiles, 2 symlinks and then a bit personal config in my .profile. So far so good.

But as soon as I started to use it, I was unable to connect to databases which had the SEC_CASE_SENSITIVE_LOGON parameter on true (the default) and I recommend keeping it that way. 2 weeks ago Oracle released a new version of their instant client and this problem is fixed!
The error which was thrown to you was:

Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:

So if you encounter the same, check if your client was released before 14th of june 2016.
Only thing which still bothers me is that the thin client is missing a tnsping utility.

It works if you copy it over from the 10g version, but it’s not that nice.

 

As always, questions, remarks? find me on twitter @vanpupi