Problem to create Backup with SMO

[CRISTIAN_MOYANO]

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

[himanshp · Accepted solution]

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

[CRISTIAN_MOYANO]

Hello Himanshu

execute the changes and run backup smo

thank very much