Arch Linux

edhic

Member

From: maroc

Registered: 2022-11-28

Posts: 16

[ SOLVED ]Error service oracle xe

i have problem in execute service oracle-xe

❯ systemctl status oracle-xe.service

× oracle-xe.service - Oracle Database Express Edition
     Loaded: loaded (/usr/lib/systemd/system/oracle-xe.service; disabled; preset: disabled)
     Active: failed (Result: exit-code) since Thu 2023-02-16 22:38:19 +01; 10min ago
    Process: 31357 ExecStartPre=/opt/oracle/product/18c/dbhomeXE/bin/lsnrctl start LISTENER (code=exited, status=1/FAILURE)
        CPU: 66ms

Feb 16 22:38:19 edhic systemd[1]: Starting Oracle Database Express Edition...
Feb 16 22:38:19 edhic lsnrctl[31357]: LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 16-FEB-2023 22:38:19
Feb 16 22:38:19 edhic lsnrctl[31357]: Copyright (c) 1991, 2018, Oracle.  All rights reserved.
Feb 16 22:38:19 edhic lsnrctl[31357]: TNS-01106: Listener using listener name LISTENER has already been started
Feb 16 22:38:19 edhic systemd[1]: oracle-xe.service: Control process exited, code=exited, status=1/FAILURE
Feb 16 22:38:19 edhic systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
Feb 16 22:38:19 edhic systemd[1]: Failed to start Oracle Database Express Edition.

❯ journalctl -xeu oracle-xe.service

░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ An ExecStartPre= process belonging to unit oracle-xe.service has exited.
░░ 
░░ The process' exit code is 'exited' and its exit status is 1.
Feb 16 22:38:19 edhic systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ The unit oracle-xe.service has entered the 'failed' state with result 'exit-code'.
Feb 16 22:38:19 edhic systemd[1]: Failed to start Oracle Database Express Edition.
░░ Subject: A start job for unit oracle-xe.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ A start job for unit oracle-xe.service has finished with a failure.
░░ 
░░ The job identifier is 3414 and the job result is failed.

Last edited by edhic (2023-02-17 18:24:44)

Raynman

Member

Registered: 2011-10-22

Posts: 1,539

Re: [ SOLVED ]Error service oracle xe

Feb 16 22:38:19 edhic lsnrctl[31357]: TNS-01106: Listener using listener name LISTENER has already been started

edhic

Member

From: maroc

Registered: 2022-11-28

Posts: 16

Re: [ SOLVED ]Error service oracle xe

is because port of listener but if already start

❯ bash -c 'echo -e "connect / as sysdba\nstartup\nalter pluggable database all open\nexit;" | /opt/oracle/product/18c/dbhomeXE/bin/sqlplus -s /nolog'

Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

for $ORACLE_HOME is nothing there

❯ subl /usr/lib/systemd/system/oracle-xe.service

[Unit]
Description=Oracle Database Express Edition

[Service]
Environment=ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
Environment=ORACLE_SID=XE
User=oracle
Group=oinstall
LimitNOFILE=65536
LimitNPROC=16384
LimitSTACK=33554432
LimitMEMLOCK=134217728
Type=oneshot
ExecStartPre=/opt/oracle/product/18c/dbhomeXE/bin/lsnrctl start LISTENER
ExecStart=bash -c 'echo -e "connect / as sysdba\nstartup\nalter pluggable database all open\nexit;" | /opt/oracle/product/18c/dbhomeXE/bin/sqlplus -s /nolog'
ExecStop=bash -c 'echo -e "connect / as sysdba\nshutdown immediate\nexit;" | /opt/oracle/product/18c/dbhomeXE/bin/sqlplus -s /nolog'
RemainAfterExit=yes

[Install]
WantedBy=multi-user.target

edhic

Member

From: maroc

Registered: 2022-11-28

Posts: 16

Re: [ SOLVED ]Error service oracle xe

i did this
export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export ORACLE_SID=XE
export PATH=$PATH:$ORACLE_HOME/bin

then this

❯ bash -c 'echo -e "connect / as sysdba\nstartup\nalter pluggable database all open\nexit;" | /opt/oracle/product/18c/dbhomeXE/bin/sqlplus -s /nolog'

ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0640: Not connected
SP2-0640: Not connected

edhic

Member

From: maroc

Registered: 2022-11-28

Posts: 16

Re: [ SOLVED ]Error service oracle xe

* i think there is problem in service oracle xe
* i left it inactive (-.-)
* i put export in file .bashrc or .zshrc
* i execute /opt/oracle/product/18c/dbhomeXE/bin/sqlplus then write system and password i cerate in configure and it work.
* oh yeah there is problem of history (up-down-arrow key , ... ) i download rlwrap and i put some of alias in .zshrc file

# alias of sqlplus
alias hsqlplus='rlwrap sqlplus'
alias rl_rman='rlwrap rman'
alias rl_asmcmd='rlwrap asmcmd'

hhm and that's it.