Skip to main content
Solved

Oracle multiple SID tnsping ? V2

  • January 3, 2024
  • 3 replies
  • 150 views
S
Forum|alt.badge.img+10

 Hi, i follow this post for managing multiple SID :

But I have some issues. First, the test Invalid-Object didn’t work and show me this error:
Status information
UNKNOWN: Cannot execute query: ORA-00936: expression absente (DBD ERROR: error possibly near <*> indicator at char 258 in '
SELECT
O.object_type||' '||O.owner||'.'||O.object_name||' is '|


Second the most of the other tests didn’t show me the command. I have this error:
Unable to hide passwords in command (Reason: Macro passwords cannot be detected)
Any Idées ?

 

 

j'ai suivi ce post pour gérer les multi SID :

Mais j'ai des dysfonctionnement. Premièrement, le test Invalid-Object ne fonctionne plus et me renvoi l'erreur :
Status information
UNKNOWN: Cannot execute query: ORA-00936: expression absente (DBD ERROR: error possibly near <*> indicator at char 258 in '
SELECT
O.object_type||' '||O.owner||'.'||O.object_name||' is '|


Ensuite la plupart des tests ne présente plus les commandes et m'indique :
Unable to hide passwords in command (Reason: Macro passwords cannot be detected)
Avez-vous des idées ?

Best answer by SavCent

Hi @omercier ,

thanks but we have find the answer for the second problem.

we don’t know why but in the host extra option, there is the --verbose parameter and it’s work for almost every service but some service need to specify --verbose in the extra option of the service.

thanks

My forum signature

3 replies

S
Forum|alt.badge.img+10
  • SavCent
  • Author
  • Builder *
  • January 3, 2024

I found the problem for invalid-object test. 

The macro RETENTIONOBJECTS is mandatory. So i put 5 for 5 days and now it’s work.

First problem solved.

Now, does anyone have an idea for the command problem ?

My forum signature
omercier
Centreonian
Forum|alt.badge.img+13
  • omercier
  • Centreonian
  • January 5, 2024

Hi @SavCent, 

It is the current behaviour when you set EXTRAOPTIONS as a password with several words in the macro.

I love it when a plan comes together!
S
Forum|alt.badge.img+10
  • SavCent
  • Author
  • Builder *
  • Answer
  • January 8, 2024

Hi @omercier ,

thanks but we have find the answer for the second problem.

we don’t know why but in the host extra option, there is the --verbose parameter and it’s work for almost every service but some service need to specify --verbose in the extra option of the service.

thanks

My forum signature
Terms & ConditionsCookie settingsAccessibility statement