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 have just finished downloading OS X 10.7 Lion but when i go to run the install it comes up wit an error asking me to try again i am using an imac 2006 model on 10.6.8 4 gb of ram and it is the core 2 duo model any suggestions?the specific error com [More]
Hi, I'm trying to establish portal System connection to Sap R/3 46C. But the conncetion faild after pupulationg the fields. I saw in the "test connection" options: "SAP Web AS Connection", "ITS Connection", "Connection T [More]
I've had a Smart Mailbox that worked for many years, but now it wont. This Smart Mailbox is set up like this: Contains messages that match all of the following conditions: Message is in Mailbox Junk Subject Does not contain *VL-JUNK* Subject Does not [More]
Hi all, i got this task: i created a web template (Button Panel) with many buttons, behind each button there is another web template with its query, this second web template has a button to get back to the panel button,now, the user asked me the task [More]
In a classic report using a Generic Column template, one can use the Column Condition attribute to conditionally render the column. But when using a named column (row template), even though the Builder allows one to specify this condition, it doesn't [More]
I have a logo created in Ai CS4 and it need to have a transparnt background (no white) because it will be printed on t-shirts, some not white, and a business card, but on other than white paper. What file format should I save this in for there to be [More]
When I try to download attachments in emails I get foreign languages or symbols. I have microsoft 2003 on my computer which should handle these attachments, but it isn'tHi, Please see [http://help.yahoo.com/kb/index?page=content&id=SLN8782 this]. [ht [More]
HI, Having issues with my Captivate Software crashing when I go to save a project. I tried to to get updates but the update link is ghosted. Why? Please refer to image. Please could someone replied with a solution. Thanks in advance.Hi, Does this pro [More]
I have no issue exporting the mailbox from 2010.   The issue is importing into 2007.  I have a 2003 32 bit server with outlook 2003 sp2 running etc.  Every time I try to import I get the below error.  Is this even supported? I've scoured the web, tri [More]
Has anyone else experienced a redirect loop for  microsoft.com/emet if so is there a quick and easy way of reporting it? Thanks, MatthewHello tip: check iis log on both of exch servers and check  owa  application haven't got "HTTP redirect" enab [More]