Cannot Login to Oracle 10g DB from client machine
Posted on 2010-11-22
I have refreshed the 10.1.0.3 oracle database from production using RMAN and the Dev database is up and running. I can login to the database from the DB server but could not do so from Client machine. I was able to login before Refresh. Also After the refresh, our Unix Admin rebooted the server. Now I am getting the following error.
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 22 10:48:29 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
The LISTENER is also up and running. I can do tnsping from my client machine.
C:\Documents and Settings\xxxx>tnsping testdb
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-NOV-2010 10:52:09
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xxx.xx)(PORT = 1521))) (
CONNECT_DATA = (SID = test)))
OK (10 msec)
Database version: 10.1.0.3
OS: Linux 3
Any resolution for this error?