Discussions
Categories
- 382.2K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 521 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 489 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 127 Programming Languages
- 289.9K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 260 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
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
-
@SmithJohn45 read and try the next: https://connor-mcdonald.com/2021/09/23/21cxe-post-install-tip/
Regards.
Answers
-
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.
-
thanks @rober584812 but it is already mentioned in guide and off course i executed those commands to start database audomatically.
-
@SmithJohn45 read and try the next: https://connor-mcdonald.com/2021/09/23/21cxe-post-install-tip/
Regards.
-
thanks again, will check it and give you feedback ☺️
-
hi @rober584812 here is my feedback...
this helped me and now I can connect to my PDB.
thanks very much for help :)
-
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?
-
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/XEPDB1The order . oraenv is necessary.
Regards.
-
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
-
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.