The ora_chpwd results in error "can't log into Oracle as SYSTEM" and "perhaps SID is not correct" (4301061)

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

The ora_chpwd results in error "can't log into Oracle as SYSTEM" and "perhaps SID is not correct"
Descrição

The below errors are observed when running ora_chpwd:
Please enter the SID where SharePlex is installed [OracleSID] : OracleSID
In order to change the password for the SharePlex user account,
we must connect to the database as DBA user.
Enter a DBA user name : SYSTEM
Enter password for the DBA account, which will not echo :
connecting--This may take a few seconds.
(null): can't log into Oracle as SYSTEM,
/ora_chpwd: perhaps SID is not correct
Causa

The password specified has not been appended with the tnsalias
Resolução

When running ora_pwd in a sql*net environment, it is required to append the password with the tnsalias (or connect string) whenever entering the password for DBA user or Shareplex user.
For example:
Enter:
<password>@<connect string>
Just entering the password without appending it with connect string will result in the above mentioned error.
Starting with SharePlex 8.6.2, it is no longer required to append the password with the connect string in SQL*net environment. During running of ora_setup, SharePlex is able to gather info on connect string and is able to append the value of connect string to the password field specified by the user. Please refer to the knowledgebase article 184662 for details.

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título