Results 1 to 7 of 7

Thread: shutdown and startup

  1. #1
    Junior Member
    Join Date
    Apr 2007
    Answers
    11

    shutdown and startup

    what is 1-connect /as sysdba, 2- set termout on ,3- shutdown and startup stands for. is sysdba same as connect to sys? what is the requirement of shutdown and startup . is it implicitly raises.


  2. #2
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Re: shutdown and startup

    Quote Originally Posted by samarendra_78 View Post
    what is 1-connect /as sysdba, 2- set termout on ,3- shutdown and startup stands for. is sysdba same as connect to sys? what is the requirement of shutdown and startup . is it implicitly raises.
    hi samarendra,

    1- connect /as sysdba means that you would connect to the database as sysdba and will have the privelleges of DBA ...which are more than that of a user..

    3- shutdown/startup stand for dismounting/mounting of the database on the server....if once shutdown you cant access the database from SQL*plus tool
    you need to startup that is mount the database on the server which you can do as sysdba only...if you are not able to mount the database from SQL*plus tool then you can do it through enterprise manager in oracle but only when you log in to the instance as sysdba

    2-? i also dont know about this 'set termout on' will try n answer it after a few days


  3. #3
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: shutdown and startup

    Quote Originally Posted by samarendra_78 View Post
    what is 1-connect /as sysdba, 2- set termout on ,3- shutdown and startup stands for. is sysdba same as connect to sys? what is the requirement of shutdown and startup . is it implicitly raises.
    2) what is 'set termout on' ?
    Setting termout is used to display or suppress the output of sql commands if the commands are run as a sql script.
    For example, if "set termout off" is given, it will suppress the output of the sql commands and to revert it back, "set termout on" is used.

    *** Innila ***

  4. #4
    Junior Member
    Join Date
    Apr 2007
    Answers
    11

    Re: shutdown and startup

    Thanks AARDVAX AND INNILA,

    but why on earth is need for shutdown and startup commnd . you can logut simply. is it necessary .

    and innila i am sorry , but i did not get it clearly about set termout plz if u can details about it . if possible with an example.

    any way thanks again to both of u.

    regards samarendra mishra


  5. #5
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Re: shutdown and startup

    hi samarendra

    if you are accessing server as one of the user you do not need to use startup (mounting) the database / shutdown (dismounting) the database..

    as collection of objects in your schema needs not to be dismounted for you as one of the user....it is more usefull for the DBA who has access to all schemas...

    for you as a user there is no need to use the above set of commands....but there may be a requirement of using the commands (whose usage u already know) by the administrator while making some changes in the structure..

    hope that would solve your problem


  6. #6
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Re: shutdown and startup

    well i also cound not understand the use of set termout on/off explained by INNILA...i tried putting that off while executing an SQL script but there was no change in the output...please clarify if you people come across any thing beneficial

    thanks & regards


  7. #7
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: shutdown and startup

    Hi,

    Since the definition alone is not very much clear, let me explain with an example in detail.
    As already given, Setting termout is used to display or suppress the output of sql commands if the commands are run as a sql script.

    Let me create a sql file named samplescript.sql since termout works for sql scripts.
    The samplescript.sql consists of a simple query,
    select empno, ename from emp;

    Now, let me run the script by setting termout as on
    Note :- Default value for termout is "on"


    SQL> set termout on
    SQL> @samplescript;

    EMPNO EMPNAME
    ------------ -----------------
    25398 STEVE

    1 row selected.

    This is the output of the script file, check out for the output while running the same sql file with termout "off"

    SQL> set termout off
    SQL> @samplescript;
    SQL>


    The output is not displayed or lets say, the output is suppressed since the setting of termout is off.
    If there is a requirement where u want to run a sql script but avoid the output, then u can go for termout off.

    Hope it is clear now.

    Last edited by Innila; 06-12-2007 at 02:41 AM.
    *** Innila ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact