Home » RDBMS Server » Server Administration » Idle instance (Oracle ,Linux)
Idle instance [message #658982] Tue, 03 January 2017 05:20 Go to next message
ram_orafaq1989
Messages: 5
Registered: October 2016
Junior Member
Hi Team,
Is it possible to connect to idle instance in a linux system after the database is up and running.I know there is a way by setting the ORACLE_SID value to a junk value . Is there any other way to connect to idle instance in a system that is already running the database.
Thanks .
Re: Idle instance [message #658984 is a reply to message #658982] Tue, 03 January 2017 05:27 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Idle instance = database not running.
So what are you actually trying to achieve here?
Re: Idle instance [message #658987 is a reply to message #658982] Tue, 03 January 2017 06:29 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ram_orafaq1989 wrote on Tue, 03 January 2017 05:20
Hi Team,
Is it possible to connect to idle instance in a linux system after the database is up and running.I know there is a way by setting the ORACLE_SID value to a junk value . Is there any other way to connect to idle instance in a system that is already running the database.
Thanks .
By definition, an instance that is running is not idle.

I agree with Cookiemonster ... what are you trying to achieve here?

[Updated on: Tue, 03 January 2017 06:30]

Report message to a moderator

Re: Idle instance [message #658990 is a reply to message #658982] Tue, 03 January 2017 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also, if you want to continue to get help you should envisage to feedback and thank people ywho try to help you.
Please review your previous topic.

Re: Idle instance [message #659011 is a reply to message #658982] Wed, 04 January 2017 02:56 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
ram_orafaq1989 wrote on Tue, 03 January 2017 11:20
Hi Team,
I know there is a way by setting the ORACLE_SID value to a junk value .
Correct. If you set your ORACLE_SID to a non-existent SID SQL*Plus will indeed report that it has connected you to "an idle instance". However, a subsequent STARTUP command would fail. As others have enquired, what exactly are you trying to achieve?
Re: Idle instance [message #659060 is a reply to message #658990] Thu, 05 January 2017 06:32 Go to previous messageGo to next message
ram_orafaq1989
Messages: 5
Registered: October 2016
Junior Member
Hi all,
Thanks for all your replies . I am a PL SQL developer . Just wanted to know if Oracle supports logging in SQL Plus with SYSDBA role without connecting to any instance or database.
Also after logging in , if we set up the init.ora Start up file with a junk db name , it should start the instance right ?. Correct me if I am wrong .

@Micheal Cadot,
Thanks for your feedback , I will make sure to place my thanks for the replies.
Re: Idle instance [message #659061 is a reply to message #659060] Thu, 05 January 2017 06:38 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ram_orafaq1989 wrote on Thu, 05 January 2017 06:32
Hi all,
Thanks for all your replies . I am a PL SQL developer . Just wanted to know if Oracle supports logging in SQL Plus with SYSDBA role without connecting to any instance or database.
Look at the /nolog command line option. Has nothing to do with 'as sysdba' or not.

https://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_three.htm#i1169374

Quote:

Also after logging in , if we set up the init.ora Start up file with a junk db name , it should start the instance right ?. Correct me if I am wrong .
IF you set ORACLE_SID to some "junk" value, you could start an instance in NOMOUNT with

SQL> startup nomount pfile='init.ora'

But there is not much you could do with it so the fundamental question remains. Why would you want to? What are you really trying to accomplish?

oracle:junkdb$ cat initjunkdb.ora
db_block_size=8192
db_name="junkdb"

oracle:junkdb$ export ORACLE_SID=junkdb

oracle:junkdb$ sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 5 06:49:45 2017

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount pfile='initjunkdb.ora'
ORACLE instance started.

Total System Global Area  234881024 bytes
Fixed Size                  2922904 bytes
Variable Size             176162408 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes
SQL>

[Updated on: Thu, 05 January 2017 06:51]

Report message to a moderator

Re: Idle instance [message #659203 is a reply to message #659061] Mon, 09 January 2017 09:11 Go to previous messageGo to next message
ram_orafaq1989
Messages: 5
Registered: October 2016
Junior Member
Hi Ed,
Thanks for your reply . I understand there is not much practical usability with my question .Just wanted to know a few things with respect to authentication in sqlplus .
Thanks.
Re: Idle instance [message #659204 is a reply to message #659203] Mon, 09 January 2017 09:19 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
If you're a member of the O/S "dba" group "sqlplus / as sysdba" will work regardless.

[Edit: typo]

[Updated on: Mon, 09 January 2017 09:42]

Report message to a moderator

Re: Idle instance [message #659208 is a reply to message #659203] Mon, 09 January 2017 09:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ram_orafaq1989 wrote on Mon, 09 January 2017 16:11
Hi Ed,
Thanks for your reply . I understand there is not much practical usability with my question .Just wanted to know a few things with respect to authentication in sqlplus .
Thanks.
So what did you learn?

Re: Idle instance [message #659269 is a reply to message #659208] Wed, 11 January 2017 03:14 Go to previous messageGo to next message
ram_orafaq1989
Messages: 5
Registered: October 2016
Junior Member
That we can login into sql plus and start instances without any connection to database.Understood that sqlplus , instances and databases are separate entities that can be worked with independently.
Re: Idle instance [message #659270 is a reply to message #659269] Wed, 11 January 2017 03:30 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
ram_orafaq1989 wrote on Wed, 11 January 2017 09:14
That we can login into sql plus and start instances without any connection to database.Understood that sqlplus , instances and databases are separate entities that can be worked with independently.
Not quite correct. Yes, SQL*Plus, the instance, and the database are separate. But you do not log in to SQL*Plus. You log in with SQL*Plus. The instance is memory structures and processes: it lives on your CPUs and in your RAM, and is transient; you start and stop it. The database is persistent: it is files on disc, and exists from creation until you deliberately delete it. An "ORacle server" is an instance plus a database. What ties it all together is the concept of a "session". A session is a connection from the SQL*Plus client to the Oracle server, and the login occurs when the session is established.
If the instance is "idle", you have a special case: just one instance process is launched, the process that supports your session. Log in to that, and you can use it to launch the instance and then create a database or open an already extant database.

Clear?
Previous Topic: help:ORA-27102: out of memory
Next Topic: Clarification Required On Query
Goto Forum:
  


Current Time: Fri Mar 29 03:55:49 CDT 2024