Results 1 to 11 of 11
  1. #1
    Join Date
    Jun 2012
    Posts
    6

    Question Unanswered: Problem with Sql plus

    Hi!

    All the time when I'm trying login myself to sqlplus I log on to SQL> but I don`t know what I have to do to got Main user account for example [sys@orcl~] ?

    I get some info to write this (set sqlprompt "_USER'@'CONNECT_IDENTIFIER > ") but this only changing name but doesn't make real step down to sys@orcl

    My example steps:

    Name: sys as sysdba
    Password: oracle
    SQL>


    but I need be here (for example to call listener):
    [sys@orcl~]

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2012
    Posts
    6
    It`s this same.
    User: sys/manager@orcl as sysdba
    SQL> set sqlp "_USER'@'_CONNECT_IDENTIFIER _PRIVILAGES
    @ quit
    SQL>

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2012
    Posts
    6
    anacedent I have all the time this problem this example it`s not make step down because you can write there what do you want for example

    SQL> SET SQLPROMPT "lalalala"
    lalala


    name is changed but I can`t write for example "listener stop" because this lalala is this same as SQL>

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    after invoking SQL*Plus, you can only issue valid SQL or sqlplus commands & "listener stop" is neither.
    "listener stop" is not even valid OS command.

    below would be valid

    SQL> HOST lsncrtl stop
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by simman View Post
    name is changed but I can`t write for example "listener stop" because this lalala is this same as SQL>
    "listener stop" is not a SQL statement.
    It's not even a valid command to stop the listener.

    Please check the manual for details on how to start and stop the listener:
    http://docs.oracle.com/cd/E11882_01/network.112/e10836/listenercfg.htm#CHDBJAEG

  8. #8
    Join Date
    Jun 2012
    Posts
    6
    I would like to write this as host because I`m not able to make this lesson - Starting and Stopping the Listener Using the Listener Control Utility

    Chapter 4: Configuring the Network Environment

    but I have got problem write this "lsnrctl status listener" because I don`t know how to be [sys@oracl ~]

    My Oracle 11g is in my Windows 7 and all the time in this SQL PLUS I can write as SQL>

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    open Command Window & then COPY line below

    lsnrctl status

    finally PASTE into Command Window to execute it
    sqlplus is NOT involved with managing the listener
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Jun 2012
    Posts
    6
    but I`m not able to use this command netmgr

    I have to Start -> Programs -> Oracle Home -> Configuration and Migration Tools -> Net Manager

    click

    I decided closed this POST because I get all usefull INFORMATION [closed]
    Last edited by simman; 06-03-12 at 00:18.

  11. #11
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You don't understand. You can write a .bat file that will start/stop your listener and database. Its very easy. You setup an icon pointing to it and just click it.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •