Home » Infrastructure » Linux » unable to connect for linux server to database (merged) (RHEL4-U3-i386-AS-20060720)
unable to connect for linux server to database (merged) [message #640778] Wed, 05 August 2015 01:46 Go to next message
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 [message #640781 is a reply to message #640778] Wed, 05 August 2015 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Given what you posted, it seems you are not connected to Oracle.
If you want we debug your script you should post it, don't you think?
You should also post the COMPLETE session, starting from sqlplus commands line.

Before, Please read How to use [code] tags and make your code easier to read.

Re: unable to connect for linux server to database (merged) [message #640789 is a reply to message #640778] Wed, 05 August 2015 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Instead of repeating the same question in another topic, you should post what is asked.

Re: unable to connect for linux server to database (merged) [message #640811 is a reply to message #640789] Wed, 05 August 2015 07:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 3 21:29:39 2015
>Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
The version of SQLPLus must match the version of the database to which it connects.
Re: unable to connect for linux server to database (merged) [message #640815 is a reply to message #640811] Wed, 05 August 2015 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It can but it is not mandatory(within a reasonable range of versions):
E:\>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Aug 5 15:11:17 2015

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

SQL> connect michel/******@mikb2
Connected.
SQL> @v

Version Oracle : 11.2.0.1.0

E:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Mer. Ao¹t 5 15:13:06 2015

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> connect michel/******@mikb2
Connected.
SQL> @v

Version Oracle : 11.2.0.1.0

E:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 - Production on Me Aou 5 15:14:38 2015

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect michel/******@mikb2
ERROR:
ORA-12537: TNS:connection closed

Re: unable to connect for linux server to database (merged) [message #640818 is a reply to message #640815] Wed, 05 August 2015 08:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Connect WITHOUT using any SQL*Net & post the results.
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
Michel Cadot
Messages: 68624
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.
Previous Topic: .bash_profile
Next Topic: Problem in installing "Oracle Database 12c Release 1 Examples"
Goto Forum:
  


Current Time: Thu Mar 28 10:28:08 CDT 2024