Frequently Asked Questions

How to view log files?

Any failure in the execution is captured in the upgrade factory logs.

To view log files

Log on to the Siebel application container.
Use the API link below to get the log files URL for logs download. This is a zipped file with all the logs related to Upgrade Factory execution.
Trigger a GET request using the REST API Client: http://<PUBLIC_IP>:<Port>/scm/api/v1.0/upgradefactory/logs

How to connect to the host server?

Mac users can use the Launch terminal application. Windows users can install a terminal application such as gitbash (https://git-scm.com/downloads)

To connect to the host server

Place the SSH key in any of the folders (This is the same private key which was used while creating the SCM stack)
Open the terminal window and navigate to the folder having the SSH key. For example, cd /user/johndoe/demo/ ocikey)
Change the permission to 600.
chmod 600 <SSH Private Key Name>
Establish connection using the command below.
ssh -i <SSH Private Key Name> opc@<PUBLIC_IP>
Example: ssh -i scmuf-private.key >opc@<PUBLIC_IP)
If the connection is not established, then an incorrect SSH private key is being used or firewall or proxy is blocking the connection.
If on a VPN, disconnect it and try again.

How to connect to Siebel server?

Once you are logged into the VM Instance <PUBLIC_IP> using an SSH Terminal, you can log on to different Siebel servers using the Docker/Podman commands.

Login to Siebel container.

docker exec -it <container name> bash

example (to connect to enterprise server): docker exec -it ses-ENT bash

(or)

podman exec -it <container name> bash

example (to connect to enterprise server): podman exec -it ses-ENT bash

How to copy a file or folder inside a Docker/Podman container to the host VM instance?

Use this command:

docker cp
                <container name>:<file/folder inside the container with full path> <host
                server path> example(to copy /siebel/ses/siebsrvr/test.txt file inside enterprise
                server to /home/opc):  docker cp ses-ENT:/siebel/ses/siebsrvr/test.txt
                /home/opc/

(or)

podman cp <container name>:<file/folder
                inside the container with full path> <host server path> example(to copy
                /siebel/ses/siebsrvr/test.txt file inside enterprise server to /home/opc): podman cp
                ses-ENT:/siebel/ses/siebsrvr/test.txt /home/opc/

Use this command from your local machine terminal to copy file from host server to your local machine.

scp -i<SSH Private Key Name> -r
                opc@<PUBLIC_IP>/<file/folder> <localmachine-path> example:scp
                -iscmuf-private-key – r opc@<PUBLIC IP>/home/opc/test.txt
            ~/Downloads/

How to connect to the database?

Connect to Database from ses-ENT container (Siebel Enterprise Server).

SQLPLUS Connection: sqlplus sadmin/Welcome1@SIEBELDB or sqlplus siebel/Welcome1@SIEBELDB

ODBC Connection: odbcsql /u sadmin
                /p Welcome1 /s SIEBELDB

Connect to the database using SQL Developer.

By default, Siebel instances expose the Siebel DB on port 1521 with the service name of SAMPLE.

To connect

Launch SQL Developer.
Click on the + icon on the left pane to add a new database connection and fill the connection details as shown below and click Test to verity the status (success or failure).
- Name: My SCM Siebel (any name of your choice)
- Username: SADMIN
- Password: Welcome1
- Hostname: <PUBLIC_IP>
- Port: 1521
- Service name: SAMPLE