Subscribe
Accepted Solution

DB credentials for profile creation in Snapmanager Oracle

[ Edited ]

Hi ,


I am deploying Snapmanager for Oracle in my environment what type of user i need to use while creating a profile for a DB Instance.


Example:- I have DB called TestDB with ASM and i am creating profile and i was prompted to provide credentials so do i need to use a user account which access to bothe DB and ASM or just O/S authentication with DB access will do ???

                     

Thanks,

Nayab                                                                                                                                                              

Re: DB credentials for profile creation in Snapmanager Oracle

The user smo is looking for is an account with Sysdba access.

This is usually sys, or some other account that you have granted sysdba access to.

Some customers use OS authentication or db auth....

Hope that helps!

Sent from my iPhone

Re: DB credentials for profile creation in Snapmanager Oracle

Thanks for the reply freddy , So if i choose with OS authentication it will not cause any issue accessing my DB ?? and in the second screen shot i can see if we are using ASM we shoudl provide a account with ASM access so what if my OS account doen't have access to ASM ??

Re: DB credentials for profile creation in Snapmanager Oracle

Nope shouldn't cause any issues with accessing your db...the user you are using should be a part of the sysdba group within unix...

If it's not, then you may have connectivity problems.

The same should apply for the ASM user....it shouldn't cause issues accessing the ASM db. Remember smo is only accessing the db to place it into hot backup mode and potentially take it in/out of the different states (if you do cold backups vs hot backups).

Sent from my iPhone

Re: DB credentials for profile creation in Snapmanager Oracle

I am getting the below error now

--[ERROR] FLOW-11019: Failure in Discover: SD-00021: Error discovering storage resources for all system devices: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive storage show -dev": 0001-185 Command error: storage show failed: no NETAPP devices to show or add the host to the trusted hosts (options trusted.hosts) and enable SSL on the storage system or retry after changing snapdrive.conf to use http for storage system communication and restarting snapdrive daemon.

--[ERROR] FLOW-11008: Operation failed: SD-00021: Error discovering storage resources for all system devices: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive storage show -dev": 0001-185 Command error: storage show failed: no NETAPP devices to show or add the host to the trusted hosts (options trusted.hosts) and enable SSL on the storage system or retry after changing snapdrive.conf to use http for storage system communication and restarting snapdrive daemon.

--[ERROR] SMO-05075: Profile create failed: SMO-13527: Error performing fast restore check: FLOW-11019: Failure in Discover: SD-00021: Error discovering storage resources for all system devices: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive storage show -dev": 0001-185 Command error: storage show failed: no NETAPP devices to show or add the host to the trusted hosts (options trusted.hosts) and enable SSL on the storage system or retry after changing snapdrive.conf to use http for storage system communication and restarting snapdrive daemon..

Re: DB credentials for profile creation in Snapmanager Oracle

Also I would suggest you read some of the oracle docs around OS auth vs db auth...if you have any doubts about setup etc.

Sent from my iPhone

Re: DB credentials for profile creation in Snapmanager Oracle

So there are many reasons why that error might be happening.

When you start/stop sdu...do you get a warning message that says something about not being able to see a SAN stack?

If so, then your configuration is not setup properly...

Sent from my iPhone

Re: DB credentials for profile creation in Snapmanager Oracle

One thing you could try as well is to verify you have the proper settings in the snapdrive.conf

There is a wizard located in:

/opt/NetApp/snapdrive/setup

There is a file (can't remember the name)...setup_wizard I think...but it will run through some selections that will help you configure sdu properly...

Sent from my iPhone

Re: DB credentials for profile creation in Snapmanager Oracle

You are correct Freddy , I was able to see Unable to find SAN storage stack.....

# snapdrived restart

Successfully stopped daemon

WARNING!!! Unable to find a SAN storage stack. Please verify that the appropriate transport protocol, volume manager, file system and multipathing type are installed and configured in the system. If NFS is being used, this warning message can be ignored.

Successfully started daemon

Can help me How to fix this issue.

Re: DB credentials for profile creation in Snapmanager Oracle

So my previous comment about the config wizard might help.

If not then we may want to consider opening a case with support to help you triage/fix the issue.

How does that sound?

Sent from my iPhone