Sitemap

Amicuk Programming Answers

Index > why to Command prompt-SQLPLUS AS SYSDBA >

why to Command prompt-SQLPLUS AS SYSDBA

Advertisement

Running SQLPLUS script from command prompt on SUN

Category:DefaultRelease time:2015-10-11Views:130

We are making a migration from VMS to SUN ( SunOS 5.10) and from 9i to 10g. We have encountered an unanticipated problem with running scripts from the command line in SUN(SQLPLUS execution from the command line). All of our packages have a naming con[More]

Sqlplus / as sysdba on command prompt

Category:DefaultRelease time:-0001-11-30Views:130

Hi I am new to oracle db on Windows environment. I did a set ORACLE_SID=cddg then a sqlplus / as sysdba I got insufficient privileges error . Can anyone Please let me knwo where the problem is ?Is the os user you logged in with a member of the ORA_DB[More]

Error 57 in invoking sqlplus command from DOS command prompt in Oracle Serv

Category:DefaultRelease time:-0001-11-30Views:130

I have a Oracle 11G server which has suddenly shutdown due to power cut-off. Now when I restart the system and trying to connect to database invoking the sqlplus as sysdba from DOS command prompt - I am getting following errors C:\Documents and Setti[More]

Error while Invoking SQLPLUS from Command Prompt

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am trying to Connect to Oracle through sqlplus from command prompt of windows and getting this Error: C:\Documents and Settings>sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 28 10:08:43 2006 Copyright (c) 1982, 2005, Oracle.[More]

Can't create database from command prompt

Category:DefaultRelease time:2015-10-11Views:130

I am using Oracle 9i over Win XP. I can create new database using OEM wizard without any problem. However, when I try to create new database from command prompt, using following commands, I get an error. sqlplus /nolog connect / as internal (when I i[More]

Launching Index Tuning Wizard from command prompt

Category:DefaultRelease time:-0001-11-30Views:130

I have been playing with index tuning wizard and I could not figure how to launch it from command line (Manual says it can be launched via management console or oracle expert). DB2 and SQL Server provide executables which can be launched from command[More]

Sqlplus / as sysdba error

Category:DefaultRelease time:-0001-11-30Views:130

I am looged in as a one of admin group user and from the command prompt when I type sqlplus / as sysdba gives me ORA-01031 insufficient privileges. My sqlbet.ora has the following entry: SQLNET.AUTHENTICATION_SERVICES = (NTS). I have similar configur[More]

Unable to connect to Oracle using OS authentication (sqlplus / as sysdba)

Category:DefaultRelease time:-0001-11-30Views:130

Hello, When I try to connect locally ,using OS authentication ( sqlplus / as sysdba ), on a Oracle database, I get "ORA-01031: insufficient privileges" error. OS: Windows XP Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod. conne[More]

Do we have a command to clear sql command prompt

Category:DefaultRelease time:-0001-11-30Views:130

do we have a command to clear sql command prompt ??I faced one issue, that would like to share with you guys. Oracle: 10gR2 OS: Win XP / 2003 / 2000 C:\Documents and Settings\mamohiuddin.MYPC>sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.1.0[More]

VM Server 2.2.1 & 11gR2 RAC ... How to get ASM command prompt?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am using Oracle VM Server 2.2.1, and two database instances created by the Oracle 11gR2 RAC template? My memory seems to have slipped. How do I get to the ASM command prompt? What ORACLE_HOME do I set? What ORACLE_SID do I use? What 'login word[More]

Oracle Connection Via Command Prompt

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I am in a situation where I will have to test a connection to a Oracle Database by using just command prompt (Windows Server 2008) as I am not allowed to install any Oracle client tools. The Oracle server is located on a different server mach[More]

Unable to connect to database from windows command prompt

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, Im trying to connect to Oracle database from my windows command prompt, these are the steps I followed: 1) cd C:\oracle\product\11.2.0\client_1\sqlplus 2) sqlplus username\[email protected]:1521\service_name I do get the error ORA-06401: NETC[More]

Ed at Linux command prompt

Category:DefaultRelease time:-0001-11-30Views:130

Dear All, I was trying to use ed command to open an editor to update my sql statements on Linux. Please can anyone tell me how I can implement it in Linux command prompt. Thanks in advance, Ash$ ed /etc/hosts 632 5 192.168.1.45    srv001 loghost s/g/[More]

Sqlplus / as sysdba hung state

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, When we try to do a sqlplus / as sysdba it gets into hung state. sapkxqap03:oraqs9 2> sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Wed Feb 16 19:06:28 2011 Copyright (c) 1982, 2007, Oracle.  All Rights Reserved. We dont ge[More]

Sqlplus as sysdba takes 3-4 mins

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am trying to login to the database by using sqlplus as sysdba but it takes 3 to 4 mins to get the sql prompt. But for other users it does not take that much time. Could any one suggest me on this? Thanks Venkatuser12052260 wrote: My problem has[More]

Shell scipt does return to command prompt

Category:DefaultRelease time:-0001-11-30Views:130

I'm trying to run a sql script from the command line. I need the sql to run and then exit to the command prompt. current using sqlplus -s un/[email protected] @fn.sql param1 param2 Where fn.sql is something like select * from &1 when run, the sql script and para[More]

SHOW commands in SQLPlus

Category:DefaultRelease time:-0001-11-30Views:130

Where can I find a list / explanation of the SHOW commands in SQLPlus? Thanks,Hi, Also, try this cool glogin script from Chris Foot to show the instance name in your SQL*Plus promt: COLUMN file_name FORMAT a44 COLUMN tablespace_name FORMAT a20 COLUMN[More]

How to restirct sqlplus '/as sysdba' logins?.

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Anyone know how to restirct sqlplus '/as sysdba' logins from the Unix prompt.Hi, Anyone know how to restirct sqlplus '/as sysdba' logins from the Unix prompt.You can add SQLNET.AUTHENTICATION_SERVICES=(NONE) to the $ORACLE_HOME/network/admin/sqln[More]

Command prompt issue from VBscript

Category:DefaultRelease time:2015-10-11Views:130

So I have this script that works perfectly for parsing out a COM number and then sending data to said COM port via the command line (things like 'ipconfig > //./COM15'). The issue is that it only works when I use the /K modifier which tells the comma[More]

Query running on sql commands prompt not running on report region

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Facing a weird issue now. I have written a report query which is running absolutely fine in sql command prompt but when i trying to run this as a report it is just processing and the report is not loading. What could be the reason behing this[More]

Hot
I am getting this more often than I care to think about. It seems that each time I have an update, I'm getting this message. This happens whether I use the CC dropdown on my computer or open the application and update from there. What is the problem [More]
Hi, I have an iPod touch version 4.3.5 (ML1). Model is MC540C. The App Store sometimes bars me from installing apps because the app has a minimum requirement of iOS 5 or 6. How can I force my iPod to install these apps anyway?No, it is more than the [More]
I just armed myself with sufficient audacity to start looking at the contents of PDF files, using PDFSpy, CosEdit, and -most interestingly- good old 'vi'. There are (at least) two factors that prevent clear text readability. (1) What is the deal with [More]
Dear Experts, when i convert the PR to PO using MD04, document type by default comes as NB. Can anyone help me in sorting the issue. Regards, Praveen Sinha.Hi Mathias,    Looks like its MM related issue.Purchase Requisition to Purchase Order .Can you [More]
Hi,    Can anybody suggest me Function module in CRM that gives details of billing document when its corresponding cancelled billing no. is given as input. Ex. Invoice no. is 'X'.       When 'X' gets cancelled , a document gets generated of type canc [More]
When connecting the headphione jack to external speakers through an external amplifier I am receiving a loud distortion sound. Can it be eliminated?When connecting the headphione jack to external speakers through an external amplifier I am receiving [More]
I am tring to retieve the approver for a particular role using a workflow. But i am not able to retieve it, i have tried "get approvers" method but i am not very much familiar as to what condition should i give to make it run. Any help in this r [More]
So I need to add USB 2.0 to my Pismo. What current production PC cards are known to work with no fuss or muss?I got myself one of those cheap no-name cards with 4 USB ports in eBay for a few Euros. Just make sure that it is CardBus-compatible. I thin [More]
Hello ,  I using CUCM version 9.1.1.2000-5  .  Does this version support MOH for third party sip phones ?  Thank you Hi, I couldn't found better piece of information which list all cases how MoH is implemented for various terminals and hence thought [More]
Bonsoir à tous, Je tourne et retourne le problème dans tous les sens, j'ai mis mes drivers à jour, installé et réinstallé Photoshop 2 fois... Rien n'à faire, c'est tout bloqué !!! Je suis sous HP Pavilion 6, carte graphique Intel (R) HD Graphics et w [More]