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 downloaded an upgrade from itunes last night to os5.1 i think. it said there was a problem with the download. now my phone will not work at all. it just has a picture of the itunes logo ans a picture of a usb cable on it. my computer will not recog [More]
I've forgotten my i-cloud password and have changed email addresses so I am unable to access i-cloud in order to re-set both email address and new passwordGo to http://iforgot.apple.com and sign in. A new password will be sent to your associated emai [More]
Hi All, any body can give the infomation / steps / screenshots to install the business content objects.and what are the major changes compared to BW3.5. plz..help me With Regards, Padmavati Message was edited by:         padmavati bHi padma,       Se [More]
I have a late 2011 MacBook or 15". My MacBook screen/display flickers excessively making the mac completely unusable. I am not sure if flickering is the right term. Some times it flickers and some times turns turs completely blue or black with white [More]
Hello, We are on oracle 11.5.10.2. Oracle has a canned Uninvoiced receipts report in the Purchasing Super User > Reports. Can anyone tell me what view this report uses to obtain it's data or can anyone tell me simply where the data is located in the [More]
hello guys ..when i try to update any applecation..it puts the first user a ccount and it ask the password which i dont know it cause im not the first user of this i pad ,,,,so how can i changebit to update apps dute to my account name and password?? [More]
I have an iphoto library with 103GB of data stored on a separate hard drive.  When I try to open on any Mac, none of the images appear even though the hard drive appears to be working fine.  I have tried to uninstall and reinstall iphoto, tried diffe [More]
hello i am new to writing game in java. i used to put component to panel, set Layout, that kind of things, to deal with user response. now writing game, a full-screen one, i think of having only a frame and a canvas that draw the whole output. i thin [More]
If I type anything into the address bar, links to bing searches for websites come up. If I make an error in the address, I am sent to bing. Virus scan finds no issues. Ad-aware puts a Win32 file in quarantine, but it doesn't have an impact on the add [More]
We have a requirement to print street2 and street3 from our vendor/customer masters in the printed remittance we use the standard payment print programs RFFONL_I and RFFOD_U, but have our own version of the international remittance Z110_IN_AVIS is th [More]