unable to connect for linux server to database (merged) [message #640778] |
Wed, 05 August 2015 01:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9a5a4ce1b4601196f17d79761074b645?s=64&d=mm&r=g) |
ramadurga
Messages: 5 Registered: June 2011 Location: chennai
|
Junior Member |
|
|
Hi all,
we are running scripts from linux server. those scripts will connect database server and execute the stored procedures.
earlier it has connected to database. but yesterday onwards we are unable to connect to database and it is giving unable to connect oracle error in log files. we didnt change any database password or scripts.
ERROR:
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 3 21:29:39 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 ERROR:
ORA-03114: not connected to ORACLE
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Can you please help on this..
Many Thanks
[Updated on: Wed, 05 August 2015 03:07] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
Re: unable to connect for linux server to database (merged) [message #640824 is a reply to message #640818] |
Wed, 05 August 2015 08:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
This case is even better.
E:\>set ORACLE_SID=MIKB2
E:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Aug 5 15:34:57 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect michel/******
Connected.
SQL> @v
Version Oracle : 11.2.0.1.0
SQL> def _SQLPLUS_RELEASE
DEFINE _SQLPLUS_RELEASE = "1101000600" (CHAR)
E:\>set ORACLE_SID=MIKB2
E:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mer. Ao¹t 5 15:36:47 2015
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> connect michel/******
Connected.
SQL> @v
Version Oracle : 11.2.0.1.0
SQL> def _SQLPLUS_RELEASE
DEFINE _SQLPLUS_RELEASE = "1002000400" (CHAR)
E:\>set ORACLE_SID=MIKB2
E:\>sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Me Aou 5 15:37:52 2015
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect michel/******
Connected.
SQL> @v
Version Oracle : 11.2.0.1.0
SQL> def _SQLPLUS_RELEASE
DEFINE _SQLPLUS_RELEASE = "902000800" (CHAR)
E:\>set ORACLE_SID=MIKB2
E:\>sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Me Aou 5 15:38:50 2015
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> connect michel/******
ERROR:
ORA-12546: TNS:permission denied
SQL> def _SQLPLUS_RELEASE
DEFINE _SQLPLUS_RELEASE = "801070000" (CHAR)
RA-12546: TNS:permission denied
*Cause: User has insufficient privileges to perform the requested operation.
*Action: Acquire necessary privileges and try again.
|
|
|