10 Replies Latest reply on Feb 18, 2014 3:31 PM by Bill Robinson

    BSA 8.3.01 AppServer blasadmin SQLException error - Thoughts?

      AppServer OS: (Server 2008R2)

      Database: (Oracle 11g)

      State: Everything seems to work fine (with exception of live browsing of Windows patches)

      Situation: When NSH > blasadmin -a > into [blasadmin] utility on the appserver, I noticed that an error was thrown when using the [?] command to see the commands available. I have not idea what it's concerning. Any ideas?

       

      Error: "[27 Sep 2013 13:37:17,583] [main] [ERROR] java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

       

      (considerations)

      -AppServer configuration wizard works fine and does not give any errors.

      -AppServer, patching, compliance and everything else work fine.

      -When trying to run blcontent, I get the same error

       

      ############################# BLASADMIN - COMMAND OUTPUT FOR "SHOW ALL" ###############################

      bladmin:*>show all | more
      [ACLCopy]
      [27 Sep 2013 13:47:14,270] [main] [ERROR] java.sql.SQLException: Listener refuse
      d the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descript
      or

      [ACLCopy]
      UseDefaultAclOnObjectCopy:false
      [AccountConfig]
      AccountLockoutDuration:0
      AccountLockoutThreshold:0
      IsPasswordComplexityEnabled:false
      IsPasswordHistoryEnabled:false
      MaxPasswordAge:0
      MaxPasswordHistory:5
      MinPasswordLength:0
      UserAccountInactiveDisabling:false
      UserAccountInactiveTime:30
      [AgentConfig]
      EnableAgentRpc:false
      InterruptThreadIdleTime:10
      InterruptThreadPoolSize:5
      MaxConnectionRefusedAttempts:5
      SecureFilePath:
      [AppServer]
      AppServerInstrumentationFilePath:
      AppServerInstrumentationRolloverCount:10
      AppServerInstrumentationRolloverSize:10000
      AppServerName:stcsevphq052em
      AppSvcPort:9841
      AssetClassAclDelay:300000
      AssetClassGlobalCacheEnabled:null
      AssetClassHardReferenceMaximum:100
      AssetClassJobCacheEnabled:null
      AssetClassJobQueryCacheEnabled:null
      AssetClassSessionCacheEnabled:null
      AssetClassSessionQueryCacheEnabled:null
      AssetPathCacheMaxSize:5000
      AuditCacheMaxSize:50
      BlTargetJobManagerTimeout:90
      CLRProxyPort:
      CertPasswd:     <REMOVED FOR SECURITY REASONS>
      CertStore:bladelogic.keystore
      ComplianceResultMaxNumberOfAssets:100
      ComponentCacheMaxSize:100
      ComponentHeaderCacheMaxSize:500
      ConditionFormatLocaleCountry:
      ConditionFormatLocaleLanguage:
      ConditionFormatLocaleVariant:
      DaalPluginImportWaitTimeout:null
      DefaultRestVersion:8.1.02
      DisplayName:STCSEVPHQ052EM
      EnableARFAndASRExecution:false
      EnableAsyncExecution:
      EnableAtriumIntegration:false
      EnableIDRACService:false
      EnableInstrumentation:false
      EnableProxyInspection:true
      EnableSessionBasedCaching:true
      EnableTomcatService:true
      EnableWebServices:true
      FileSystemObjectCacheMaxSize:50000
      GMOCacheMaxSize:500
      HTTPProxyName:     <REMOVED FOR SECURITY REASONS>
      HTTPProxyPassword:
      HTTPProxyPort:     <REMOVED FOR SECURITY REASONS>
      HTTPProxyType:null
      HTTPProxyUser:
      Hostname:
      HttpsIDRACPortNumber:4433
      HttpsPortNumber:9843
      IdleConnectionPruneTime:120
      IdleNshProxyPruneTime:120
      JVMArgs:
      LauncherStatusRefreshInterval:30
      LogItemWriterQueueSize:10000
      MaxApprovalThreads:3
      MaxClientContexts:200
      MaxConnectionAttempts:10
      MaxHeapSize:
      MaxJMXConnections:20
      MaxJobThreads:5
      MaxJobWorkItemCacheMemorySizeInkB:8000
      MaxJobs:20
      MaxLightweightWorkItemThreads:0
      MaxNshProxyContexts:50
      MaxNshProxyThreads:15
      MaxPort:9899
      MaxRESTNotifyThreads:12
      MaxTimeForCancelToFinish:10
      MaxWorkItemThreads:50
      MaxWorkerThreads:10
      MemoryMonitorRefreshRate:60
      MinPort:9850
      NTLMProxyDomain:null
      NshProxyMaxThreadIdleTime:500
      NshProxySocketConnectTimeout:60
      NshProxySocketOperationTimeout:7200
      NumLogItemWriterThreads:5
      PSCCacheMaxSize:500
      PSICacheMaxSize:500
      PSIValueCacheMaxSize:1000
      PWDStore:
      PatternCacheMaxSize:500
      PropagateWorkItemTimeout:true
      ProxySvcPort:0
      RegistryPort:9836
      RemoteServerTimeout:300
      RequireClientAuthentication:true
      RestAssetAttributesUseInternalNames:false
      RestartIdleProvisionJobs:
      SSCOLoaderCacheMaxSize:25
      SSLPort:9831
      ServerMonitorInterval:20
      ServerSocketBacklog:50
      SnapshotCacheMaxSize:100
      SocketConnectTimeout:60
      SocketOperationTimeout:7200
      SocketTimeout:600
      SocketsBindAddress:all
      TemplateCacheMaxSize:100
      UseSSLSockets:false
      ValidateClientIpAddress:true
      ValidateRequestURL:true
      VersionCompatibilityCheck:minor
      XMLConfigFileTransferChunkSize:100
      [AssetThresholds]
      MaxAllowedLiveBrowseResults:
      MaxConfigRecords:50000
      [AuthServer]
      ActiveDirectoryLdapUrl:
      ActiveDirectorySearchBase:
      AppServiceURLs:
      AuthSvcKrb5Config:blappserv_krb5.conf
      AuthSvcKrb5LoginConfig:blappserv_login.conf
      AuthSvcPort:9840
      AuthSvcSocketTimeout:90
      IsADKAuthEnabled:false
      IsActiveDirectoryLdapCheckEnabled:false
      IsDomainAuthEnabled:false
      IsLdapAuthEnabled:false
      IsSRPAuthEnabled:true
      IsSSOCredRefreshEnabled:true
      IsSecurIdAuthEnabled:false
      IsSsoRefreshHostnameCheckEnabled:true
      LdapUserDnTemplate:
      LdapUserValidationFilter:
      MaxAuthSvcContexts:20
      MaxAuthSvcThreads:3
      MaximumSessionCredentialLifetime:
      ProxyServiceURLs:
      ReportServiceURLs:
      SessionCredentialLifetime:
      [BlExec]
      MaxSocketConnections:500
      NumWorkerThreads:20
      SubmissionQueueSize:10000
      [Cleanup]
      AutoGeneratedRetentionTime:0
      DatabaseCleanupFilterEnabled:true
      DefaultDatabaseCleanupDurationInMin:240
      DefaultFileServerCleanupDurationInMin:240
      DependencyGraphMaximumNodeCount:500
      EnableRetentionPolicy:false
      GroupsMustBeEmpty:false
      MaxObjectsPurgedPerTransaction:1000
      [ConfigManagerUI]
      AutoCreate:
      DefaultImportAndUpdateFolder:/importAndUpdate
      EnableRetentionPolicy:false
      GroupsMustBeEmpty:false
      InstrumentationEnabled:
      ShowNoAccessNodes:true
      [Database]
      AutoBatchEnabled:true
      ConnectionString:jdbc:oracle:thin:@<REMOVED FOR SECURITY>:<"PORT">:<"SID">
      DatabaseInstrumentationFilePath:
      DatabaseInstrumentationRolloverCount:10
      DatabaseInstrumentationRolloverSize:10000
      DatabaseVersion:8.3.00
      DriverClass:oracle.jdbc.driver.OracleDriver
      FetchSize:100
      IdleConnectionTestPeriod:600
      MaxClientConnections:100
      MaxGeneralConnections:100
      MaxIdleTime:600
      MaxJobExecutionConnections:100
      MaxWaitTime:
      MinClientConnections:0
      MinGeneralConnections:0
      MinJobExecutionConnections:0
      MinTimeToLog:0
      Password:     <REMOVED FOR SECURITY REASONS>
      SqlFiles:
          sql/sqlmap.properties
          sql/streamable_sqlmap.properties
      TransactionAttempts:10
      UserId:bladelogic
      [Deployment]
      LoadedAtStartup:true
      ServiceType:true
      [Diagnostics]
      AutomaticInterval:0
      AutomaticServers:
      MaxStoredResults:20
      MaxWaitTime:5
      [DistributionManager]
      AssignmentLoadFactor:5
      [EmailConfig]
      fromaddress:
      smtpserver:
      techsupport:Customer_Support@bmc.com
      [FileServer]
      location:/C/Program Files/BMC Software/BladeLogic/NSH/storage/
      name:     <REMOVED FOR SECURITY REASONS>
      [JCIFSConnection]
      connTimeout:30000
      logLevel:3
      responseTimeout:30000
      soTimeout:35000
      [JobFactory]
      GlobalDefaultJobParallelism:0
      UspJobSucceedsWhenAgentDown:
      [JobInfraManager]
      enableJobOutput:false
      [Ldap]
      ConnectionTimeoutMs:
      DefaultPassword:
      DefaultUser:
      IsHostValidationEnabled:
      LdapServerURLs:
      TrustStore:
      [Logging]
      ConsoleLogfileName:console.log
      LogfileName:
      Logformat:Default
      [ManagementService]
      EmailNotificationLevel:
      EmailRecipients:
      JMXManagementPort:9838
      JmxNotificationLevel:
      SnmpNotificationLevel:
      SnmpRecipients:
      [MountConfig]
      SnpAudPkgCrossMounts:false
      SnpAudPkgNetworkMounts:false
      [OCSP]
      IsEnabled:true
      IsFailoverEnabled:false
      IsNonceEnabled:false
      ResponderUrl:
      TruststorePassword:
      TruststorePathname:
      TruststoreType:JKS
      UseCustomResponder:false
      [Paging]
      MaxPageSize:1000
      [PatchConfig]
      AutoRemediate:false
      [PerlConfig]
      location:/c/Perl/bin/perl.exe
      [PkiAuth]
      IsEnabled:false
      TruststorePassword:
      TruststorePathname:
      TruststoreType:JKS
      UseCommonNames:false
      [ProcessSpawner]
      NshScriptJobCredentialTimeout:96
      RegistryPort:1067
      SpawnExternally:false
      [Pxe]
      [PxeServer]
      default_address:     <REMOVED FOR SECURITY REASONS>
      domain:default.com
      interface_to_bind:     <REMOVED FOR SECURITY REASONS>
      is_use_broadcast:false
      is_use_multicast:true
      listen_port:4011
      mtftp_address:null
      mtftp_client_port:0
      mtftp_server_port:0
      multicast_address:     <REMOVED FOR SECURITY REASONS>
      prompt_timeout:0
      tftpd_base_dir:c:\tftproot
      [RBAC]
      DisableRecurringTasks:
      mntWindowUpdateInterval:60
      [RoutingConfig]
      EvaluateJobRules:
      EvaluateRepeaterRules:true
      EvaluateSocksProxyRules:true
      [RoutingService]
      MaxNumberOfWaitCycles:0
      MaxWaitTimePerWaitCycle:60
      [SSHConnection]
      connectTimeout:30000
      defaultSshPort:22
      supportedCiphers:aes256-cbc,aes192-cbc,aes128-cbc,3des-cbc,aes256-ctr,aes192-ctr
      ,aes128-ctr
      [Scheduler]
      MaxJobTimeInSchedulerQ:60
      [SecurID]
      AgentHost:null
      ConfigFilePath:null
      LogFilePath:null
      LogLevel:OFF
      LogToFile:false
      NodeSecretFilePath:null
      OptionsFilePath:null
      ReadConfigInterval:600
      StatusFilePath:null
      [SmartGroupConfig]
      MaxSmartGroupItems:
      [SnmpConfig]
      SnmpPort:162
      SnmpServer:
      [Support]
      AgentLogMaxWaitTime:30
      MaxWaitTime:5
      [WebServices]
      MaxSessionsPerUser:50
      MaxWebServicesSessions:30
      RegistryApplicationName:BMC_BladeLogic_Server_Automation_Suite
      RegistryBusinessName:BMC
      RegistryCriteria:
      RegistryPublishedHostName:
      RegistryServer:
      RegistryServerPassword:     <REMOVED FOR SECURITY REASONS>
      RegistryServerPort:
      RegistryServerProtocol:http
      RegistryServerUserName:
      TimeOutInterval:300000
      TouchTimeForService:5000
      WebServiceRunReleasedCommandsOnly:false

      ##########################################################################################################