S
steve pittman
Guest
Hi Johan, Seems like sql is intermittently getting a failure when a user connects to the server with the db name that will use the properties file to connect automatically to the multiple databases - icfcb, rxdb, agdb. When this type of failure occurs, sql will try to retain the connection to the primary db (1st in properties file) and skip the other databases. This would account for the behavior when a certain catalog is not known to sql, as shown in your error message. Also, check the db name format which users use to connect to the db. If the name format is not just right, sql will not find your properties file, and will not know about the auxiliary databases. In 11.4, when these failures occur, sql will try to write some error diagnostics information to a file in the directory where the db was started. This file will have a name like sql*xxxx*.log, where xxxx is the sql servers process id. If you have one or more of these, see what they say. Looking at the properties file that you posted, I notice a typo in the 3rd line from end - "catolog" should be "catalog". I can't predict right now what the effect of this will be, but fixing it will not hurt. Hope this helps. .....steve pittman [OE sql development architect]
Continue reading...
Continue reading...