Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Post Details

Added on Sep 23 2021
9 comments
4,086 views