A Technical I.T./DevOps Blog
Problem scenario
You have configured dbconfig.xml for JIRA 7.x to use Oracle 12. But JIRA is not working correctly when you try to start it. What should you do with your dbconfig.xml file?
Solution
Atlassian’s website, as of 8/30/18, recommends having “oracle10g”, an unsupported version, in the dbconfig.xml file. This is despite the fact that Oracle 10 and Oracle 11 are not supported for JIRA 7.x according to Atlassian’s site here.
…
Problem scenario
You run a Java program and receive “java.lang.classnotfoundexception oracle.jdbc.driver.oracledriver”. You need to get a program working despite reading that this driver has been deprecated. What should you do?
Solution
1. Find the JRE/lib/ext directory.
2. Place an ojdbc14.jar file (e.g., downloaded from Oracle.com or some trustworthy website) in that directory.
3. Without recompiling your program, run the Java program again.
…
Problem scenario
You are not sure if the username and password to a PostgreSQL database work. What do you do?
Solution
Run this one-line command:
psql -d “postgresql://jdoe:coolpassword@localhost/foobardb” -c “select now()”
# Replace “jdoe” with the SQL database username
# Replace “coolpassword” with the user’s password
# Replace “foobardb” with the name of the database you are authenticating too
# If you have the PostgreSQL client installed (so psql works) and the database is remote,
…
Problem scenario
You know that Amazon Aurora is compatible with either PostgreSQL or MySQL. While RDS supports these database types as well as Oracle and SQL Server, RDS does not offer all of the advantages that Aurora offers.
You have read about the benefits of Aurora a database PaaS or DBaaS. You want to deploy Amazon Aurora because it has numerous features for high availability, performance,
…
Continue reading “How Do You Use Amazon Aurora to Try It Out?”
Problem scenario
You have no desktop GUI and a limited ability to install new applications other than the Java compiler. You are not be allowed to install a SQL command line client such as sqlconnect or a utility such as tnsping. What should you do to test the credentials, server name and port number to ensure they work to allow access to an Oracle database?
Solution
The overview is to use a Java program with the code provided below.
…
Problem scenario
You get an error such as this on a Linux server:
“Caused by: java.lang.AbstractMethodError: Method oracle/jdbc/driver/OraclePrepreadStatementWrapper.setBinaryStream (IL java/io/InputStream;)V is abstract at oracle.jdbc.driver.OraclePreparedStatementWrapper.setBinaryStream (OraclePreparedStatementWrapper.java)”
What should you do?
Possible Solution #1
If you are doing Java coding, have you imported the packages needed for the line of Java code that is throwing this error?
Possible Solution #2
If you are using JBoss,
…
Problem scenario
You want users to be able to enter a table name and then see the content of the table. How do you create a webpage with a text field and a submit button that will display the content of the table if it exists?
Solution
Overview
This assumes you have the LAPP stack set up on a single server. To set up the LAPP stack on Ubuntu,
…
Problem scenario
You have a data warehouse that has not been performing as well as you would like. What are some things that you can do to optimize the performance?
Solution
1. Schedule processes such as back ups or ETL jobs at different times from hours of peak demand. Rebuilding indexes can be a good idea or a bad one depending on when it is performed.
…
Continue reading “How Do You Optimize Data Warehouse Performance?”
Problem scenario
You created a DB instance in RDS. You cannot connect to it. What should you do?
Solution
1. Make sure that it is “Available.” It could have been turned off.
2. Click on the Instance and confirm the relevant Security Group allows you to connect to it.
3. Click on the Instance and search for “Publicly accessible”. Make sure this is set to “Yes.” If it is set to “No” you may have to take a snapshot of the instance and launch that snapshot with the “Publicly accessible” option.
…
Continue reading “How Do You Troubleshoot Connecting to an RDS Instance?”
Problem scenario
In an Ubuntu-based Docker container, how do you install MariaDB and start the MariaDB service?
Solution
Run these commands:
sudo apt-get -y update
sudo apt-get -y install vim
sudo apt-get install mariadb-server
sudo service mysql start
…