Solved

Oracle multiple SID tnsping ? V2

  • 3 January 2024
  • 3 replies
  • 86 views

Userlevel 1
Badge +8

 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 ?

icon

Best answer by SavCent 8 January 2024, 13:57

View original

3 replies

Userlevel 1
Badge +8

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 ?

Userlevel 4
Badge +12

Hi @SavCent

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

Userlevel 1
Badge +8

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

Reply