I had an issue with Spacewalk where there was nothing but the Oracle Linux spacewalk header within the web interface. I was planning on upgrading so I took this opportunity to perform an upgrade. I used this document - https://docs.oracle.com/cd/E92593_01/E90682/html/swk22-svr-upgrade.html
When I reach step 8 to run /usr/bin/spacewalk-schema-upgrade I get an error:
# /usr/bin/spacewalk-schema-upgrade
Connect to database was not successful.
I am running with the Oracle Database and see it it running-
systemctl status dbora.service
● dbora.service - The Oracle Database Service
Loaded: loaded (/usr/lib/systemd/system/dbora.service; enabled; vendor preset: disabled)
Active: active (running) since Sun 2018-11-25 16:03:21 EST; 1min 4s ago
Process: 2275 ExecStop=/home/oracle/scripts/shutdown.sh >> /home/oracle/scripts/startup_shutdown.log 2>&1 (code=exited, status=0/SUCCESS)
Process: 2324 ExecStart=/home/oracle/scripts/startup.sh >> /home/oracle/scripts/startup_shutdown.log 2>&1 (code=exited, status=0/SUCCESS)
Tasks: 63
CGroup: /system.slice/dbora.service
├─2336 /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
├─2344 ora_pmon_db12c
├─2346 ora_clmn_db12c
├─2348 ora_psp0_db12c
├─2351 ora_vktm_db12c
├─2355 ora_gen0_db12c
├─2357 ora_mman_db12c
├─2361 ora_gen1_db12c
├─2365 ora_diag_db12c
├─2367 ora_ofsd_db12c
├─2371 ora_dbrm_db12c
├─2373 ora_vkrm_db12c
├─2375 ora_svcb_db12c
├─2377 ora_pman_db12c
├─2379 ora_dia0_db12c
├─2381 ora_dbw0_db12c
├─2383 ora_lgwr_db12c
├─2385 ora_ckpt_db12c
├─2387 ora_lg00_db12c
├─2389 ora_smon_db12c
├─2391 ora_lg01_db12c
├─2393 ora_smco_db12c
├─2395 ora_reco_db12c
├─2397 ora_w000_db12c
├─2399 ora_lreg_db12c
├─2401 ora_w001_db12c
├─2403 ora_pxmn_db12c
├─2407 ora_mmon_db12c
├─2410 ora_mmnl_db12c
├─2412 ora_d000_db12c
├─2414 ora_s000_db12c
├─2416 ora_tmon_db12c
├─2430 ora_tt00_db12c
├─2432 ora_tt01_db12c
├─2434 ora_tt02_db12c
├─2439 ora_aqpc_db12c
├─2443 ora_p000_db12c
├─2445 ora_p001_db12c
├─2447 ora_p002_db12c
├─2449 ora_p003_db12c
├─2451 ora_p004_db12c
├─2453 ora_p005_db12c
├─2455 ora_p006_db12c
├─2457 ora_p007_db12c
├─2459 ora_p008_db12c
├─2461 ora_p009_db12c
├─2463 ora_cjq0_db12c
├─2465 ora_p00a_db12c
├─2467 ora_p00b_db12c
├─2469 ora_p00c_db12c
├─2471 ora_p00d_db12c
├─2474 ora_p00e_db12c
├─2476 ora_p00f_db12c
├─2674 ora_s001_db12c
├─2679 ora_qm02_db12c
├─2683 ora_q002_db12c
├─2685 ora_q003_db12c
└─2791 ora_w002_db12c
Nov 25 16:03:15 orswalkl2p startup.sh[2324]: SQL> ORACLE instance started.
Nov 25 16:03:15 orswalkl2p startup.sh[2324]: Total System Global Area 5049942016 bytes
Nov 25 16:03:15 orswalkl2p startup.sh[2324]: Fixed Size 8631096 bytes
Nov 25 16:03:15 orswalkl2p startup.sh[2324]: Variable Size 1056967880 bytes
Nov 25 16:03:15 orswalkl2p startup.sh[2324]: Database Buffers 3976200192 bytes
Nov 25 16:03:15 orswalkl2p startup.sh[2324]: Redo Buffers 8142848 bytes
Nov 25 16:03:19 orswalkl2p startup.sh[2324]: Database mounted.
Nov 25 16:03:21 orswalkl2p startup.sh[2324]: Database opened.
Nov 25 16:03:21 orswalkl2p startup.sh[2324]: SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Nov 25 16:03:21 orswalkl2p systemd[1]: Started The Oracle Database Service.
I also tried restarting the dbora.service and still can't run the schema update. Not even sure how to get Spacewalk connected or why or how it is not connected.