Oracle Data Base Machine
As you can see in the general overview image, the Linc migrator uses an Oracle Database that is installed in a CentOS machine. The original Database machine was a physical machine and it was the only place where we had all the information required to run the conversion tool. The original IP Address of the DB Machine was 192.168.0.35.
Due to issues with one of the physical disks of the original DB machine, we recreated that DB in one Virtual machine using the same versions used in the original one (CentOS5 and Oracle 10g). the only place where the Database is correctly installed and configured. This DB configuration is a little bit complicated, so you need to take care of it.
As a result of the issues with the DB machine and the effort used to manually recreate the DB, we request the DevOps team to back up the actual versions of the conversion tool VM and the DB VM.
The actual IP Address of the DB VM is 192.168.0.78, this IP address was configured in the DNS associated with the Mac address of the VM because the VM needs to use that IP Address. If for any reason, you change the IP Address, you need to update all the scheme files stored in the Oracle XML Repository to use the right IP Address, and update the Linc Conversion tool configuration file (located in the Linc Conversion tool VM) to point to the right DB IP Address.
To connect to the DB machine using the actual configuration, and the IP address of the DB VM), use putty and use as the Hostname the IP 192.168.0.78:
When the connection is established, use the credentials root/root to log into the system. Now you have access to the Machine where the DB is installed.
Database startup/shutdown
There are some first steps that you must follow before starting the database. Probably some of the configuration is already done but if you get errors you will need to do some configurations.
The first thing you need to do is to check if the ORACLE_HOME environment variable is already defined. To do this, in the terminal enter the following command:
If the variable is already defined, you will see in the terminal the path of the Oracle installation folder, if not nothing will be displayed in the terminal. If the ORACLE_HOME is already set, you can skip setting it (Avoid doing this if the DB is already working. This was necessary in the old physical machine but probably won't be necessary if you are using the DB VM).
To set the ORACLE_HOME execute the following command:
To start the database you need to change to the Oracle user. To do this, execute the following command in the terminal (putty):
To check the database status, you can review if there are active listeners by executing the command:
You can even review the listeners configured in the Oracle instance by checking the content of the listener.ora file. To check the configuration on this file you can execute the command:
You should see the following contents:
To start the database, as an Oracle user, you can open sqlplus and execute the startup command. To do this, follow the next steps:
In the terminal, enter the following command:
To log in to sqlplus use the credentials:
user: sys as sysdba
password: orcl1234
In the sqlplus console, execute the startup command
If you want to stop the database instance, you can execute the shutdown command in sqlplus:
Database Troubleshooting
This section shows some common issues that you can face while trying to start the database.
If you receive the following error (ora-01113, ora-01110):
You need to recover the data file. Using the previous example image, to fix this specific issue, you need to execute the following instruction in the sqlplus:
Database Virtual machine list of users
The following is the list of users that can be used in the DB VM:
Connecting to the DB
If you want to connect to the database to review the information stored or to check the XML repository information, you can use the credentials:
These credentials are the ones used by the Linc conversion tool.
To review the public schemas stored in the DB and used by the Linc Conversion tool, you can go to the URL: http://192.168.0.78:8085/public/schemas
To review the metadata (information) generated by the executions of the conversion tool, you can go and check the project information in the following URL: http://192.168.0.78:8085/public/projects/
To see both, the schemes and the project's information, use the lincrepository2 credentials.
Last updated