This discussion is archived
5 Replies Latest reply: Dec 3, 2012 9:36 PM by Osama_Mustafa RSS

problem in connect db instance

862343 Newbie
Currently Being Moderated
this is one of my OMR,both connect command issured from same machine ,i do not know why,anybody can help?
$ sqlplus sys/pass@ip/mygc.example.com as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 4 09:37:54 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SYS@mygc/host> exit



$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 4 09:38:26 2012

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

idle> conn system/pass
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

ORACLE_SID=mygc
ORACLE_BASE=/data/app/oracle
ORACLE_HOME=/data/app/oracle/product/11.2.0/dbhome_1
Edited by: 859340 on 2012-12-3 下午6:03

Edited by: 859340 on 2012-12-3 下午6:13

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points