OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » connect database

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

connect database [message #536044]

Mon, 19 December 2011 02:03

sirumon
Messages: 8
Registered: December 2011
Location: Dhaka

Junior Member

Hi,
I'm new in Oracle XE. Please help

XE has been setup. Then in Command Prompt
*************************************
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\sirajul>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 19 13:33:47 2011

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

Enter user-name: hr/hr

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>
***************************************************
Here Connection is successful.

But While I setup Oracle Forms Developer 10g, The above process no longer on success in Command Prompt.
I experience TNS:protocol adapter error
*********************************************

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\sirajul>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 19 13:33:47 2011

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

Enter user-name: hr/hr
ORA-12560:TNS:protocol adapter error

***********************************************

When I deinstall Developer Suit 10g Then the problem is solved.

Please help.

with regards
[[mailto:mdsirumon@yahoo.com|mdsirumon@yahoo.com]]

Report message to a moderator

Re: connect database [message #536049 is a reply to message #536044]

Mon, 19 December 2011 02:16

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

Senior Member
Account Moderator

The new installation changes your default environment that is variables ORACLE_HOME, ORACLE_SID, PATH.

Regards
Michel

Report message to a moderator

Re: connect database [message #536060 is a reply to message #536049]

Mon, 19 December 2011 02:36

sirumon
Messages: 8
Registered: December 2011
Location: Dhaka

Junior Member

Dear,Michel

How do I examine default environment that is variables ORACLE_HOME, ORACLE_SID, PATH.

As I'm beginner please help with an example.

With Best Regards
mdsirumon@yahoo.com

Report message to a moderator

Re: connect database [message #536062 is a reply to message #536060]

Mon, 19 December 2011 02:39

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

In windows, at the cmd prompt type "ECHO ORACLE_HOME" ECHO.... etc

Report message to a moderator

Re: connect database [message #536063 is a reply to message #536062]

Mon, 19 December 2011 02:48

sirumon
Messages: 8
Registered: December 2011
Location: Dhaka

Junior Member

C:\Documents and Settings\sirajul>ECHO ORACLE_HOME
ORACLE_HOME

C:\Documents and Settings\sirajul>

Report message to a moderator

Re: connect database [message #536065 is a reply to message #536063]

Mon, 19 December 2011 02:49

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Sorry, mixed up my OS's - in windows its "SET ...."

Report message to a moderator

Re: connect database [message #536067 is a reply to message #536065]

Mon, 19 December 2011 02:51

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

Senior Member
Account Moderator

or "echo %ORACLE_HOME%"

Regards
Michel

Report message to a moderator

Re: connect database [message #536071 is a reply to message #536067]

Mon, 19 December 2011 02:58

sirumon
Messages: 8
Registered: December 2011
Location: Dhaka

Junior Member

C:\Documents and Settings\sirajul>echo %ORACLE_HOME%
%ORACLE_HOME%

C:\Documents and Settings\sirajul>

Report message to a moderator

Re: connect database [message #536072 is a reply to message #536071]

Mon, 19 December 2011 03:00

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

That would suggest it is not set. Try setting it.

Report message to a moderator

Re: connect database [message #562345 is a reply to message #536072]

Tue, 31 July 2012 09:19

sirumon
Messages: 8
Registered: December 2011
Location: Dhaka

Junior Member

Dear Michel,

Please explain the reason occurring in two scenario in windows XP:

1.when trying as:

All Program>Oracle Database 10g Express Edition>Run SQL Command Line>Enter.

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 31 20:03:27 2012

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

SQL> connect
Enter user-name: hr
Enter password:
Connected.
SQL>

2. When trying from cmd:
Run>CMD

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\sirajul>sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jul 31 20:13:05 2012

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

Enter user-name: hr
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:

I appreciate your valuable tips to get rid around.

Regards
Sirajul

Report message to a moderator

Re: connect database [message #562346 is a reply to message #562345]

Tue, 31 July 2012 09:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

how many different Oracle version or DB have been installed on this system?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: connect database [message #562350 is a reply to message #562345]

Tue, 31 July 2012 10:51

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

Senior Member
Account Moderator

If you just post what has been asked that is the result of command SET you will see that ORACLE_HOME and/or ORACLE_SID is not set.

Regards
Michel

Report message to a moderator

Re: connect database [message #562403 is a reply to message #562350]

Wed, 01 August 2012 05:51

sirumon
Messages: 8
Registered: December 2011
Location: Dhaka

Junior Member

----Sorry
There is another installation of 11g fusion middleware.
De-installation that one is quite enough for me at this moment. Yet there any other options to fix this besides
ORACLE_HOME and/or ORACLE_SID set other than De-installation.

Regards
Sirajul

Report message to a moderator

Re: connect database [message #562405 is a reply to message #562403]

Wed, 01 August 2012 06:13

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

Senior Member
Account Moderator

I don't understant your post.
Are you or not on the database server?
Are you on client worstation or application server different from the database server?
In both cases post the result of "SET".

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 11g high memory usage dbw0 and dbw1
Next Topic:	where the second fetch data ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:18:34 CST 2024