Forum Stats

  • 3,767,860 Users
  • 2,252,726 Discussions
  • 7,874,367 Comments

Discussions

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

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

Best Answer

Answers