Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

installed 21c XE on CentOS 7 but facing problem to connect in sqlplus

SmithJohn45Sep 23 2021

hi all,
created a VM using CentOS 7 (7.8) and installed Oracle Database XE 21c
i followed the guide from very trusted site here:
https://oracle-base.com/articles/21c/oracle-db-21c-xe-rpm-installation-on-oracle-linux-7-and-8
after installation steps completed modified .bash_profile as below:

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH

export ORACLE_SID=XE
export PDB_NAME=XEPDB1
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/21c/dbhomeXE
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export PATH=$ORACLE_HOME/bin:/$PATH

then reboot VM and tried to connect but failed, below are 2 attempts in SQL*PLUS environment

SQL> conn / as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn sys@xepdb1 as sysdba
Enter password: 
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

please help, i tried to install Oracle DB first time on Linux. there is no tnsnames.ora in $ORACLE_HOME/network/ folder, nothing mentioned for how to set environment variables in guide above.
regards
This post has been answered by rober584812 on Sep 25 2021
Jump to Answer

Comments

rober584812

Hello SmithJohn45.
Try the next commands:

systemctl start oracle-xe-21c
systemctl enable oracle-xe-21c

After running the commands, reboot and test the connection to SQLPLUS.
Regards.

SmithJohn45

thanks @rober584812 but it is already mentioned in guide and off course i executed those commands to start database audomatically.
image.png

rober584812
Answer

@smithjohn45 read and try the next: https://connor-mcdonald.com/2021/09/23/21cxe-post-install-tip/
Regards.

Marked as Answer by SmithJohn45 · Oct 1 2021
1 person found this helpful
SmithJohn45

thanks again, will check it and give you feedback

SmithJohn45

@rober584812 here is my feedback...
this helped me and now I can connect to my PDB.
thanks very much for help :)

SmithJohn45

hi rober584812
it was connected to my PDB but when I restart my CentOS 7 VM now it is not connecting to XEPDB1
i issued 2 ' Alter Pluggable Database ' commands ( as below ) but still failed to connect using sys/ora1234@xepdb1
in my .bash_profile i added following environment variables which can only enable me to run sqlplus, also i have to issue command manually as below to connect to XE (CDB) but this also not allowed me to connect to PDB.
. oraenv
alter commands as per oracle documents:

alter PLUGGABLE DATABASE ALL OPEN;
alter PLUGGABLE DATABASE ALL SAVE STATE;

environment variables:
export ORACLE_BASE=/opt/oracle/
export LD_LIBRARY_PATH=$ORACLE_BASE/product/21c/dbhomeXE/lib
export ORACLE_HOME=$ORACLE_BASE/product/21c/dbhomeXE
export PATH=$ORACLE_BASE/product/21c/dbhomeXE/bin:$PATH
export PATH=/usr/bin:$PATH
export ORACLE_SID=XE
this is same problem i am facing in 18c XE. please help to connect and start Apex 21 + ORDS 21 installation and development.
regards
Is it necessary to issue , oraenv command ? what about if i add it in .bash_profile but will this accept XE as parameter in that file?

rober584812

Hello SmithJohn45 , check if the listener is running.

cd <oracle_home>/bin
lsnrctl status

After, if the listener status is OK, try the following command:
system/password@localhost.localdomain:1521/XEPDB1
The order . oraenv is necessary.
Regards.

1 person found this helpful
SmithJohn45

yeah, i can connnect using ezconnect syntax. but as mentioned earlier, i am confused as i want to install Apex & ORDS, how I can configure to use it both " . oraenv " and ezconnect syntax without every time manually interact when logout and login, machine restart etc. and same for production environment?
regards

rober584812

Hello @smithjohn45 , the important thing is that the listener is working, if the listener is in the OK state, you will be able to access the Oracle XE instance without problems; Regarding the installation of APEX with ORDS, using "oraenv" will be required during the installation process, you can configure ORDS in autorun or standalone mode.
Regards.

1 - 9

Post Details

Added on Sep 23 2021
9 comments
4,123 views
2 mentions