OraFAQ Forum: Linux » unable to connect for linux server to database (merged)

Home » Infrastructure » Linux » unable to connect for linux server to database (merged) (RHEL4-U3-i386-AS-20060720)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to connect for linux server to database (merged) [message #640778]

Wed, 05 August 2015 01:46

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: unable to connect for linux server to database (merged) [message #640789 is a reply to message #640778]

Wed, 05 August 2015 03:08

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: unable to connect for linux server to database (merged) [message #640811 is a reply to message #640789]

Wed, 05 August 2015 07:56

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.

Report message to a moderator

Re: unable to connect for linux server to database (merged) [message #640815 is a reply to message #640811]

Wed, 05 August 2015 08:16

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: unable to connect for linux server to database (merged) [message #640818 is a reply to message #640815]

Wed, 05 August 2015 08:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Connect WITHOUT using any SQL*Net & post the results.

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Previous Topic:	.bash_profile
Next Topic:	Problem in installing "Oracle Database 12c Release 1 Examples"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 01:25:55 CST 2025