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

SmithJohn45

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 [email protected] 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

rober584812

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

Regards.

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.

rober584812

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

Regards.

SmithJohn45

https://community.oracle.com/tech/developers/discussion/comment/16810276#Comment_16810276

thanks again, will check it and give you feedback ☺️

SmithJohn45

https://community.oracle.com/tech/developers/discussion/comment/16810276#Comment_16810276

hi @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/[email protected]

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/[email protected]:1521/XEPDB1

The order . oraenv is necessary.

Regards.

SmithJohn45

https://community.oracle.com/tech/developers/discussion/comment/16810915#Comment_16810915

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.