sqlplus / as sysdba on command prompt

Similar Questions

• difference between sqlplus /nolog and sqlplus "/ as sysdba".

  HI ppl,
  
  Please help me with this... This is an emergency of lill
  
  On the oracle 10g platform, what is the difference between sqlplus /nolog and sqlplus "/ as sysdba".
  
  concerning

  Zombie says:
  Thnx for the people of responses,

  but not giving sqlplus/nolog... Disable writing to the Oder, the session is opened in mode nologing IE?

  concerning

  Laughing out loud

  Do not assume that everywhere where NOLOG is mentioned it means no. LOGGINg:-D. By sqlplus / nolog, you did nothing but had just the sql command prompt without really connecting as any user. You will still need to connect, by some users to start your work. This has NOTHING to do with do it again / cancel and anything else.

  The other command will actually to connect as user Sys with Sysdba role.

  That said, I STRONGLY suggest you to read this book for sure.
  http://download.Oracle.com/docs/CD/B19306_01/server.102/b14231/TOC.htm

  HTH
  Aman...

• Please, be it a while I worked with oracle, but I need to develop my self in PL/SQL. But I'm a challenge to navigate from SQL to the windows command prompt 'diary of the oracle@oel6 '. I often do that before Linux but I don't even know

  Please help

  Janet Oluwadunsin wrote:

  Thanks Steve, I appreciate your correction.

  I want to start the listener from the command prompt, I have connected successfully to sql plus, but I don't remember how I'll get my way to

  [oracle@oel6 journal] $

  at startup my interlocutor.

  I hope this helps

  And just to clarify my and other previous posts... you do NOT get to a command prompt and start your receiver from sqlplus.  sqlplus is a command-line that connects to a database and provides a user interface to the question of the sql to the database statements.  lsncrctl is another command line utility, used to send commands to the listener.  lsnrctl and sqlplus are two completely separate and distinct, all tools two started from the command line of the operating system, that have nothing to do with the other.  Neither one is a kind of 'gateway' to the other.

• Security problem for sqlplus / as sysdba

  Hi all

  11.2.0.1

  My boss is not comfortable with the command "sqlplus / as sysdba.  It seems would prefer that a name of user and password be used or forced? as in 'sqlplus sys/change_on_install as sysdba'

  Is there really an advantage or a drawback of this command in terms of security?

  Your comment is very much appreciated.

  Merry Christmas to all!

  Thank you

  pK

  In addition to the response of Hemant see this demo:

  C:\Windows\System32>sqlplus / as sysdba

  SQL * more: Production release 11.2.0.1.0 Thu Dec 26 10:58:07 2013

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

  Connected to:

  Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0 - 64 bit Production

  With partitioning, OLAP, Data Mining and Real Application Testing options

  C:\Windows\System32>type E:\app\serverroom\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

  sqlnet.ora # Network Configuration file: E:\app\serverroom\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

  # Generated by Oracle configuration tools.

  # This file is actually generated by netca. But if customers can opt for

  # install 'Software Only', this file does not exist and without the native

  authentication #, they will not be able to connect to the database on NT.

  SQLNET. AUTHENTICATION_SERVICES = (NTS)

  NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

  I am able to connect as / dBA because I SQLNET. AUTHENTICATION_SERVICES = (NTS)

  OK, now I am just cheigng NTS to ZERO and now tries to connect / as sydba:

  C:\Windows\System32>type E:\app\serverroom\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

  sqlnet.ora # Network Configuration file: E:\app\serverroom\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

  # Generated by Oracle configuration tools.

  # This file is actually generated by netca. But if customers can opt for

  # install 'Software Only', this file does not exist and without the native

  authentication #, they will not be able to connect to the database on NT.

  SQLNET. AUTHENTICATION_SERVICES = (NONE)

  NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

  C:\Windows\System32>sqlplus / as sysdba

  SQL * more: Production release 11.2.0.1.0 Thu Dec 26 11:02:31 2013

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

  ERROR:

  ORA-01031: insufficient privileges

  Enter the user name:

  ERROR:

  ORA-01017: name of user and password invalid. connection refused

  Enter the user name:

  ERROR:

  ORA-01017: name of user and password invalid. connection refused

  SP2-0157: unable to connect to ORACLE after 3 attempts, leaving SQL * more

  SYS C:\Windows\System32>sqlplus / * as sysdba

  SQL * more: Production release 11.2.0.1.0 Thu Dec 26 11:02:43 2013

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

  Connected to:

  Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0 - 64 bit Production

  With partitioning, OLAP, Data Mining and Real Application Testing options

  C:\Windows\System32 >

  So, just change SQLNET. AUTHENTICATION_SERVICES (NTS) in SQLNET. AUTHENTICATION_SERVICES (None) in sqlnet.ora and you did.

  Concerning

  Girish Sharma

• sqlplus / as sysdba with insufficient privileges error

  I installed Oracle 10.2.0.1 on Windows XP. I then installed 10g Release 2 (10.2.0.4) Patch Set 3 for Microsoft Windows (32-bit). I imported a database using pump data and then tried to connect in Windows XP box so I could change the sys using password:

  sqlplus / as sysdba

  but I get the following error:

  sqlplus / as sysdba
  SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 6 07:58:51 2010
  
  Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
  
  ERROR:
  ORA-01031: insufficient privileges

  My Windows XP box has access to two other databases that are located on a separate server. I then tried to connect using sqlplus to a user account that was on one of the other databases and it me connected. So my problem seems to be that when I enter:

  sqlplus / as sysdba

  He thinks I'm trying to connect to one of the other servers. How to connect using the command above and the target of the Windows XP box, I'm trying to connect from? How can I specify the server that I want to connect to in the above command?

  Just found it!

  Check $ORACLE_HOME/network/admin/sqlnet.ora file it provide SQLNET. AUTHENTICATION_SERVICES = (NTS)

  then try again

• Question about the connection using the "sqlplus / as sysdba.

  Good afternoon
  
  The command:
  

  sqlplus / as sysdba

  worked very well for the Oracle server. When I go to a client, it does not work even if I specify the correct instance. On the client, I can able to connect using one of these two commands:
  

  sqlplus.exe sys/abc123@"orahost.john.local:1521/dbca.john.local" as sysdba
  
  or 
  
  sqlplus.exe sys/abc123@dbca as sysdba
  
  but not
  
  sqlplus / as sysdba
  
  or 
  
  sqlplus /@dbca as sysdba

  The question is: is the form "/ as sysdba" limited to used on the Oracle server and not available for customers?
  
  Thank you for your help,
  
  John.

  is the form "/ as sysdba" limited to use on the Oracle Server

  Yes

  and not available for customers?

  Yes

• Execution of procedure stored from the command prompt?

  Is there a way to the execude stored procedure in Windows command prompt, something like running script sql using sqlplus.exe username/password@db @sql_script. *. I am aware of the possibility to set the pl/sql block that calls the procedure in the script and then call the script, but this isn't the solution, what I'm looking for.

  Something like that?

  C:\Documents and Settings\Administrator>echo execute del_emp|sqlplus hr/hr
  
  SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 14 19:13:52 2010
  
  Copyright (c) 1982, 2005, Oracle.  All rights reserved.
  
  Connected to:
  Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
  
  SQL>
  PL/SQL procedure successfully completed.
  
  SQL> Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 -
  Production
  

• sqlplus virtue sysdba problem

  Hello
  
  Server: windows
  version (Oracle): 10.1.0.2.0
  
  Its not letting me connect using sqlplus / as sysdba command...
  However I can connect with the connection string using sys...
  I added in the ora_dba under Computer Management Group
  
  SQLNET.ora also contains the NTS parameter
  
  Help, please
  Arun Kumar

  Hi Arun,

  : \>sqlplus ' [email protected]/sys as sysdba'

  Here the name of your db is BPPR but you set local C:\>set = bprr and try?

  Ravi

• How to save passwords after you said 'no' to the command prompt

  How save passwords after you said 'never' at the command prompt.

  I tried again and again and again, and none of the solutions suggested on the internet works. And there is also something too complicated for me.

  Hi, jscher2000:

  Yes it's MARKET! Thank you very much for your help!

  I'm not all pages to remember my password I just want some specific pages to remember passwords. for example. for now I only need craigslist login page to remember my pw, not other login pages.

  If this is the case, then it is a perfect solution for me.

• Re: Satellite Pro C660 - how to do the recovery with command prompt disc?

  I have a brand new Pro C660 of Satellite. It worked fine for a day, now it will not load windows. I don't have to create the recovery disks, as I only had a few hours (Yes, Yes, I know, should have been the first thing I did). All data are present (but backed up just in case USB) and I can see the folder HDDREcovery with all data intact. However, I can't run the application to create recovery discs. Does anyone know how to extract the images and create the media using only the command line? (I can go into command prompt by booting from the Windows 7 disc a friend). All options fail own laptop startup disks. It says 'Windows does not load' and I try startup repair, but it detects no error. Any help/thoughts on this will be greatly appreciated!

  Hey,.

  It of not possible to create the drive with command prompt recovery. You must use the Windows Toshiba Recovery Media Creator.

  Now it s too late for you, but you can order a disc here:
  https://backupmedia.Toshiba.EU/landing.aspx

• Pavilion Elite HPE-170 t: need help with the result of a command prompt to Power Options

  I have recently upgraded to Windows 10 in Windows 7.  Like so many thousands of people, I problelms of sleep mode.  Mine will not be auto-sleep.  It has been suggested that I saw to run command prompt: powercfg-applications

  It supposedly will list the items running on your computer which can now be auto-sleep to work.  I tried several times and up to now, I get the same item displayed each time.  This is what is displayed: \device\harddiskvolume2\windows\sysWOW64\svchost.exe (hpqddsvc) is followed by this message: a file delete operation is underway

  My first thought is that if there is an operation to remove file in progress all the time, it's maybe the reason why my computer is not auto-sleep.  If there is someone out there who can shed some light on this situation, I would appreciate the help.

  EUREKA * SOLVED
  

  I found the answer to my problem!  After using the control system: powercfg-query and get the answer: \device\harddiskvolume2\windows\sysWOW64\svchost.exe (hpqddsvc) delete file operation is in progress

  I started looking for whatever it is associated with the answer above.  In the Manager of tasks in respect of the services, I found the name of the file hpqddsvc, with a description of HP CUE DeviceDiscovery Service was running.  When I stopped the task and re-tried in opt power standby mode, it worked correctly.  In the Configuration of the system (by typing msconfig at the run prompt) on the Services tab, I unchecked the box for HP CUE DeviceDiscovery Service and rebooted the computer.  The service is no longer running.

  I'm sure that this Service has been added to my computer when I downloaded the hp.com/support product detection tool .  The tool scans your computer to detect and identify HP products.

  This can be useful to others who have the problem of the auto-sleep I've had.

• How can I add a Web site to the popup blocker exceptions list by using a command prompt?

  I have a lot of users with Firefox 2. I need a specific web site to allow for pop-up windows if their Blocker is enabled. I need to be able to run this command in a script that runs from a command prompt when the user connects.

  I don't think that you can do.

  However Firefox 2.0 version use a hostperm.1 of text file to store the exceptions.

  See http://kb.mozillazine.org/hostperm.1

• Re: How to run the update to the BIOS of the DOS - Satellite A100 PSAA8A command prompt?

  I'm having some trouble with my GF Satellite A100 (PSAA8A). When installing a new HARD drive with a clean install of XP, I flashed by chance, one of the BIOS when installing drivers. Its kind of bricks now.

  Using a floppy disk CD boot, combined with the update of the V6.00 BIOS, I goes to a DOS command prompt, but not sure where to go now.

  Under * Tradional BIOS update *.
  See the link: [http://eu.computers.toshiba-europe.com/cgi-bin/ToshibaCSG/faq.jsp?z=234&service=EU&from=faq_selection&CFID=B IOS & FID = TRO0000000b07]

  It is said:
  + 1. Extract the zip file containing the BIOS upgrade to a temporary folder. +
  + 2. Three subfolders will be generated in the temporary folder. "docs", "update - 3.5' disc', 'Update - CD - R or CD - RW +.
  + 3. Insert a 1.44 MB diskette formatted in the floppy disk drive. +
  + 4. Run the *.exe file in the folder "" Update - 3.5 disk ". Follow the instructions on the screen. A BIOS update diskette will be generated. +

  But there is no 3 folder. There is only a single called S10VWF that contains Winphlash etc. (see photo url). As far as I know, I can only run Winphlash Windows environment due to its GUI. Then what should I do? Help!

  http://img.Photobucket.com/albums/v259/tRUkbOY/S10SWF.jpg

  Hi Brett

  There is a little thing that you have forgotten or supervised.

  The BIOS you downloaded is a version of BIOS to WIN. It s not traditional BIOS update!

  The description published in your ad describes the update using the traditional BIOS.
  But the Toshiba driver page only provides updates of BIOS based VICTORY. The BIOS can be upgraded only from Windows operating system running.

  Please don't mix these two possibilities of updates!

• Satellite keyboard is not working and flashes the command prompts

  Hello world. I hope someone can help... my laptop has suddenly decided to some how turn off the keyboard. No key does not work. The touchpad mouse seems to work very well. Started once w7, a lot of windows boxes flickers between them. Command prompts to do the same thing and I cannot click on any admin agrees with the cursor ect.

  He will not simply accept. I tried the system restore ect but cannot place orders, when similar probs in Device Manager. For example, the cursor jumps oddly at the bottom of any list that I pull up and I can't ride him. The same things happen with another hard drive in the laptop. I scanned with several brands of security too... clear at all. IM wondering if its hardware, not software.

  I even re formatted the hard drive of w7 since another laptop and started again but still the same thing. I have also attached another keyboard to the live system with the same problem. USB keyboards work but still control problems. USB mouse even.

  Thanx

  I understand your question, the internal keyboard does not work, but you can use the external USB keyboard properly... don't you?

  Well, in this case, the question is clear to me: the problem is caused by the fault of the internal keyboard.
  From my point of view of the few he has no alternative option but in order to replace the internal keyboard.

• Satellite L - can I add new accounts via the command prompt?

  Is it possible that I can add new accounts to the machine via the command prompt on the screen of "recovery"?

  (When you start in recovery mode and select command prompt)

  I tried the normal commands "net user username / add ', but the accounts are not added to the machine.

  Y at - it another command which can be used?
  Thank you.

  Hello

  I don't know if it will work using the in my opinion Mr. recovery console, it is not possible.
  As far as I know that you can add the user and the password using the CMD, but this might work only when the Windows operating system has been loaded.

  In this case, you can use this command to add the user account: + net user username / add +.
  If you want to add a password for the user account, then you must use this way: + net user username password / Add +.