I am quite new to Blackboard and Oracle both so excuse me for asking a possibly obvious question. I am setting up a development environment for writing a new building block and am having trouble getting BB Learn 9.1 to connect to the Oracle ( 11g ) database which I have running in Amazon RDS. I have created a blackboard SID named "BB" and a blackboard user "bb", but during installation there is no way for me to specify the username with which to connect the database - there is simply a "Database administrator password" field. I can connect to the server fine using sqlplus with the username bb, but I am assuming that blackboard's installer is trying to connect using a different username. This is where I assume my question gets Amazon RDS-specific, because if the installer needs to use the SYS user for example, I am unsure how to set the password for this user such that the BB installer can connect to the server. Thank you in advance for any assistance!
Also, I have tried using "bb/bbpassword" in the administrator password field to no avail. The error received is ORA-01017: Invalid username/password; login denied.
You have to use the Oracle SYS (administrator) password on the Blackboard installer. The Blackboard installer will create a "blackboard" user on Oracle, and the installation process will ask you what password you want to use for that user, but you do not set up the "blackboard" user on the database yourself--the installer will do that.
I've never heard of Amazon RDs being a supported database platform for Blackboard installations. You may need to contact Blackboard support to see if it will work.
You may also need to contact Amazon about setting the password or the SYS admin user.
© Blackboard, Inc.