Skip to Main Content

Oracle Database Discussions

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!

Connected to an idle instance

Quanwen ZhaoOct 30 2018 — edited Oct 30 2018

Hello, experts

Today I try to install Oracle Database 18.3 using RPM-based package on my Oracle Linux Server 7.5 (Test Environment). It's all normal after I deploy it.

Nevertheless I add some contents on environment configuration file ".bash_profile" on oracle user. Such as follows,

[oracle@ncet ~]$ cat .bash_profile

......

export ORACLE_BASE=/opt/oracle/

export ORACLE_HOME=$ORACLE_BASE/product/18c/dbhome_1

export ORACLE_SID=ORCLCDB

export PATH=$ORACLE_HOME/bin:$PATH

alias t='cd /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace'

alias l='cd /opt/oracle/diag/tnslsnr/ncet/listener/trace'

Afterwards I login to SQL*Plus and it has shown "idle instance".

[oracle@ncet ~]$

[oracle@ncet ~]$ source .bash_profile

[oracle@ncet ~]$

[oracle@ncet ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Oct 30 12:30:39 2018

Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

[oracle@ncet ~]$ echo $ORACLE_SID

ORCLCDB

It's why? Could you help me? Thanks in advance.

Best Regards

Quanwen Zhao

This post has been answered by Mario Alcaide on Oct 30 2018
Jump to Answer
Comments
Post Details
Added on Oct 30 2018
10 comments
7,569 views