Question1:
Swingbench fails to be started, and an error is reported on the host, including the connection exception.
Solution:
Check whether the database instance is running properly.
Check whether the listener and RAC services are running properly.
If yes, use the SQLPlus and Swingbench tools to log in to the database and check whether the connection can be set up.
In this case, when you log in to the system using the user name and password, the system displays a message indicating that the test user name and password set during Swingbench data filling have expired. As a result, the connection fails. Reset the password as prompted.
Question2:
Swingbench fails to connect to the database using the correct user name and password. The ORA 12516 error occurs.
Symptom:
Swingbench fails to connect to the database, and error ora 12516 is reported during the connection test.
Solution:
1. Run the sqlplus / as sysdba command to log in to the database. The login fails and a message is displayed indicating that the number of connections exceeds the maximum.
2. Suspend the database listener, release the number of connections, and then start or change the maximum number of connections after a period of time.
