ORA-01034 and ORA-27101
[oracle@localhost ~]$ sqlplus t2/oracle@path
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 2 02:44:12 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
SOLUTION:
[oracle@localhost ~]$ export ORACLE_SID=Path
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 2 02:36:08 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523)(SID=Path))';
System altered.
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
RETEST:
[oracle@localhost ~]$ sqlplus t2/oracle@Path
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 2 02:40:50 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL>
No comments:
Post a Comment