#SC 4.8P1 can't discover Oracle Database 12.2 on SLES 12 SP4 for SAP after moving from SC 4.3P2

1 messages · Page 1 of 1 (latest)

indigo pagoda
#

Hello dear NetApp support friends!

I'm struggling with this weird case # 2009871405 after I migrated a couple of hosts from an old SC 4.3P2 to a new SC 4.8P1.

You can find details in the case. I will appreciate a lot if you point me out to KB articles or community posts to zeroing the root cause of the issue so I can solve it.

Thanks and have a nice day!

KR
Ben

#
#

To me it seems like a permission issue, but I don't know which ones to fix them.

elder dock
#

No idea about that case (I can't see it as I'm not NetApp) but when you upgraded, did you upgrade to all intermediate 4.x versions (SC server and host plug-ins) in between? SC doesn't like it at all if you skip versions

indigo pagoda
#

It was a migration, not an upgrade, from an old SC 4.3P2 to a fresh SC 4.8P1 (AFAIK the last version with support for Oracle DB 12.2).

#

Un a nutshell, the process was:

  1. Delete the host from the old SC server 4.3P2.
  2. Ensure there is not "left behind" directories nor files from the previous plug-ins installed in the host.
  3. Add the host to the new SC server 4.8P1.
#

The host was added from the GUI without errors. But then fails in the database discovery job.

#

Both plug-ins (SCU, SCO) were installed without complaints. SC services in host (spl, scc) are running green.

#

Looking into the log of the discovery job, the first time something seems to be not OK is this...

#

2023-12-11T17:17:00.0000691-06:00 DEBUG Execution Monitor Thread [export SC_PWD=/opt/NetApp/snapcenter/spl/lib PATH=<oracle_sid_home>/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin ORACLE_SID=<oracle_sid> ORACLE_HOME= <oracle_sid_home> LD_LIBRARY_PATH= <oracle_sid_home>/lib: <oracle_sid_home>/lib32: <oracle_sid_home>/bin: <oracle_sid_home>/rdbms/lib; /opt/NetApp/snapcenter/spl/plugins/sco/.././../plugins/sco/bin/launch-java com.netapp.common.remote.RemoteObjectFactoryImpl 127.0.0.1 27216 af54269b4d30a0d68148af4a97ece416] c.n.c.e.ShellResult - EXE-00001: Shell result [0:00:00.351] (Exit Value: 1):
export: Command not found.
/opt/NetApp/snapcenter/spl/plugins/sco/.././../plugins/sco/bin/launch-java: Permission denied.

#

The same error happen when running the "launch-java" script with the Oracle DB account "ora<sid>", but no error happen with the SC host service non-root account...

#

snapcenter@<hostname>:~> sudo su - ora<sid> -c /opt/NetApp/snapcenter/spl/plugins/sco/bin/launch-java
/opt/NetApp/snapcenter/spl/plugins/sco/bin/launch-java: Permission denied.

ember salmon
#

Based on this error: "export: Command not found." I'd say you aren't running bash and the unix plug-in only plays nicely with bash.

indigo pagoda
#

Hi Scott,
John Leahy already noted that. Now the shell is bash, but still is not working.

ember salmon
#

Then the error should have changed. What's the error that is happening now? Did you send new logs to John? What's the case#?

indigo pagoda
#

The case number is 2009871405. I just sent the last log to the email chain of the case.

#

Has been two weeks with this P2 case and still not solved. 😢

#

By the way, in the SnapCenter Server Web UI the error is the same.

#

Maybe is time to involve someone in the SnapCenter Server development team to look at this "Unexpected Operation" error.

#

Please let me know if you need anything to help with this issue. I'm available 24/7.

indigo pagoda
#

BINGO! It was a permission thing. You can find details in the case. Thank you for your support and kindness. 😄

ember salmon
#

Good to hear it's working now.