ORA-01034: ORACLE不可用

Question

我将按照这个reamde创建一个Oracle数据库。我运行以下命令：

docker run -it --network=SampleNET --rm store/oracle/database-instantclient:12.2.0.1 sqlplus sys/Oradoc_db1@InfraDB:1521/mindshift AS SYSDBA

然后得到这样的信息：

Enter user-name: weblogic
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3701
Additional information: 1724833639
Process ID: 0
Session ID: 0 Serial number: 0

当我拉出图像并运行脚本时，输出如下：

  domain_name     : [base_domain]
    admin_port      : [7001] 
    domain_path     : [/u01/oracle/user_projects/domains/base_domain]
    production_mode : [prod]
    admin password  : [welcome1]
    admin name      : [AdminServer]
    admin username  : [weblogic]

几天来，我一直在努力寻找一种解决方案，这样我就可以使用docker在本地拥有自己的Oracle数据库。

`[oracle@7d929b104a08 /]$  echo $ORACLE_SID`
`ORCLCDB`
` echo $ORACLE_HOME
`/u01/app/oracle/product/12.2.0/dbhome_1`

`[oracle@7d929b104a08 /]$ ps -ef | grep smon`
`oracle     146     1  0 17:53 ?        00:00:00 ora_smon_ORCLCDB`
`oracle     671   631  0 17:56 ?        00:00:00 grep --color=auto smon`

Answer 1

很可能没有正确设置参数ORACLE_HOME和ORACLE_SID。

$ echo $ORACLE_SID
....                    -->> Look what you get
$ echo $ORACLE_HOME
....                  
$ ps -ef | grep smon    -->> Look for smon background process which
ora_smon_InfraDB        --.. should include ORACLE_SID in it.

$ ORACLE_SID=InfraDB    -->> set to a valid value like these ones.
$ ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1

$ lsnrctl status        -->> Look whether listener is ON
$ lsnrctl start         -->> If not, then start the listener.

Answer 2

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

实例未启动时的典型错误。检查实例是否真的启动了。数据库创建运行时是否没有错误？