Subscribe
Accepted Solution

Problem to create Backup with SMO

[ Edited ]

Error

smo backup create -profile SMQ5 -full -online

[ERROR] SMO-20017: User "orasmq" has credentials for repository "system@XE/SNAPMGTORA:1521" but validity could not be checked.  Error: SMO-09032: Failed  to connect to repository: No more data to read from socket: [ORA-17410].

[ERROR] SMO-01104: Error invoking command: SMO-20017: User "orasmq" has credentials for repository "system@XE/SNAPMGTORA:1521" but validity could not be checked.  Error: SMO-09032: Failed  to connect to repository: No more data to read from socket: [ORA-17410].

Q0KIOSM:/opt/NetApp/smo/bin # su - orasmq

Q0KIOSM:orasmq 50> smo credential list

Credential cache for OS user "orasmq":

Repositories:

  system@XE/SNAPMGTORA:1521

Profiles:

  SMQ (Repository: system@XE/SNAPMGTORA:1521)

  SMQ5 (Repository: system@XE/SNAPMGTORA:1521)

Hosts:

Q0KIOSM:orasmq 51>

Q0KIOSM:orasmq 53> smo system verify

Operation Id [N0c9d4cd36a494e2bb0481fbe7edec2f6] succeeded.

ls the BIN

Q0KIOSM:/opt/NetApp/smo/bin # ls -ltra

total 36

-rwxrwxr-x  1 root   bin  816 Dec  2 16:07 smogui

-rwxrwxr-x  1 root   bin 6275 Dec  2 16:07 smo_setup

-rwxr--r--  1 root   bin 2128 Dec  2 16:07 smo_server

-rwxrwxr-x  1 orasmq dba  749 Dec  2 16:07 smo

-rwxrwxr-x  1 root   bin  676 Dec  2 16:07 launch-java

-rwxrwxr-x  1 root   bin 1436 Dec  2 16:07 .smo_remove_init_links

Re: Problem to create Backup with SMO

Hello Cristian,

Can you please check the status of the listener of the repository database. Also, sometimes when multiple parallel operations are run on various profiles in a single repository, a few of operations might fail due to "time out" in connecting to the repository database. User should be authenticated within a time range specifically set by SQLNET.INBOUND_CONNECT_TIMEOUT parameter in the sqlnet.ora file ( if unset, default i guess is 30 seconds).

Can you please try out the below steps and see if it resolves the issue:

  • Edit the sqlnet.ora file located at $ORACLE_HOME/network/admin. If the file does not exists, create a new one.
  • Update the SQLNET.INBOUND_CONNECT_TIMEOUT parameter with higher value than the default or existing value.
  • Restart the listener.

Thanks,

Himanshu

Re: Problem to create Backup with SMO

Hello Himanshu

execute the changes and run backup smo

thank very much