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
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.
    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
      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
    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 ...