8 Replies Latest reply: Feb 13, 2013 8:16 PM by ashwath RSS

User "oracle" has credentials for repository but validity could not be checked.

morgan.wigge Novice
Currently Being Moderated

I have this issue where one of all hosts don't want to connect to the smo repository and do normal operations..

 

when i try a regular operation:

 

[ERROR] SMO-01104: Error invoking command: SMO-20017: User "oracle" has credentials for repository "smo@smorep/repohost:1521" but validity could not be checked.  Error: SMO-09032: Failed  to connect to repository: Io exception: Connection reset: [ORA-17002].

 

When i use smo diag jdbc:

 

smo diag jdbc -sid repos -host repohost -port 1521 -username smo -password manager
    SMO-15301: Trying to connect to...
    SID: repos
    Host: repohost
    Port: 1521
    Username: smo
    Password: ******
    As Sysdba: No
    SMO-15302: JDBC URL: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = repohost)(PORT = 1521)))(CONNECT_DATA = (SID = repos)))
    SMO-15303: Attempting connection ...
    SMO-15305: Error occurred while attempting connection: Io exception: Connection reset
    SMO-15307: JDBC Connected: No

 

 

All other hosts this operation works fine on, and i can connect with the same user via sqlplus from this host.

 

We have even tried to clear and reinstall both the host and oracle binaries + snapdrive and smo binaries with the same result.

 

And it's just happening on this particular host, but we use the exact same setup on multiple hosts and they work like a charm.

 

Anyone run into this before?

 

//Morgan

  • Re: User "oracle" has credentials for repository but validity could not be checked.
    NetApp Employee Cyclist
    Currently Being Moderated

    well,

     

    here you're trying to connect to SID smorepo

     

     

    repository "smo@smorep/repohost:1521" but validity could not be checked.  Error: SMO-09032: Failed  to connect to repository: Io exception: Connection reset: [ORA-17002].

     

    but here,

    you connect to a sid called repos

     

     

    smo diag jdbc -sid repos -host repohost -port 1521 -username smo -password manager
        SMO-15301: Trying to connect to...
        SID: repos
    try to remove the .smo directory and set the credentials again.
    • Re: User "oracle" has credentials for repository but validity could not be checked.
      morgan.wigge Novice
      Currently Being Moderated

      Sorry for that one, it was me manually anonymizing the actual connectstring and made a typo..  so just think of it as conceptual instead of exact

       

      i tried to remove the .ontap where i could find the smo directory  but the same issue remains.

       

      from the log:

       

      2010-10-18 18:16:03,392 [main] [ERROR]: SMO-01104: Error invoking command: SMO-20017: User "oracle" has credentials for repository "smoadmin@XXXX" but validity could not be checked.  Error: SMO-09032: Failed  to connect to repository: Io exception: Connection reset: [ORA-17002].
      com.netapp.dlm.repository.common.RepositoryException: SMO-20017: User "oracle" has credentials for repository "smoadmin@XXXX" but validity could not be checked.  Error: SMO-09032: Failed  to connect to repository: Io exception: Connection reset: [ORA-17002].
              at com.netapp.dlm.auth.CredentialManager.createAndVerifyRepoDescriptor(CredentialManager.java:758)
              at com.netapp.dlm.auth.CredentialManager.repositoryDescriptorFromPasswordlessConnectionInfo(CredentialManager.java:342)
              at com.netapp.dlm.ui.facade.BaseFacade.showRepository(BaseFacade.java:1393)
              at com.netapp.dlm.ui.facade.SmoFacade.showRepository(SmoFacade.java:468)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at com.netapp.common.cli.binding.CommandBinding.execute(CommandBinding.java:97)
              at com.netapp.dlm.ui.cli.SMOMainCLI.main(SMOMainCLI.java:93)
      Caused by: com.netapp.dlm.repository.common.RepositoryException: SMO-09032: Failed  to connect to repository: Io exception: Connection reset: [ORA-17002].
              at com.netapp.dlm.repository.schema.RawRepository.<init>(RawRepository.java:103)
              at com.netapp.dlm.auth.CredentialManager.createAndVerifyRepoDescriptor(CredentialManager.java:740)
              ... 9 more
      Caused by: com.netapp.oracle.common.OracleException: Io exception: Connection reset
              at com.netapp.dlm.repository.schema.RawRepository.<init>(RawRepository.java:87)
              ... 10 more
      Caused by: java.sql.SQLException: Io exception: Connection reset
              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:494)
              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
              at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
              at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
              at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
              at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474)
              at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
              at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
              at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:156)
              at com.netapp.dlm.process.common.RepositoryDescriptor.createRawJdbcConnection(RepositoryDescriptor.java:197)
              at com.netapp.dlm.repository.schema.RawRepository.<init>(RawRepository.java:83)
              ... 10 more

  • Re: User "oracle" has credentials for repository but validity could not be checked.
    AKOS.KUCZI Certified Novice
    Currently Being Moderated

    Try to look for errors in listener.log and alert.log on repository host. &

    Check the processes and sessions parameters on repository database.

    Maybe SMO exceeds the process/session limit.

     

    regards,

    akos

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points