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