Oracle Error Code 1920
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion oracle cannot drop a user that is currently connected Excel-DB Don Burleson Blog
Ora 1940
ORA-01920: user name 'string' conflicts with another user or role name Expert Oracle Database drop user oracle Tips by Burleson Consulting November 29, 2015 The error "ORA-01920: user name 'string' conflicts with another user or role name" occurs most commonly when creating users or assigning roles. The
Ora-00001
oerr utility notes this on the ORA-01920 error: ORA-01920: user name 'string' conflicts with another user or role nameCause: There is already a user or role with that name.Action: Specify a different user name. Common causes for the ORA-01920 error include: Attempting to create a user that already exists Attempting to assign a role that has already been assigned ora-06512 The ORA-01920: user name 'string' conflicts with another user or role name prevents the creation of duplicate entries in the dba_users table. If an ORA-01920 is returned during the attempted creation of a user, the dba_users table should be queried to determine what users already exist: select owner, username from dba_users, order by 1; At this point, resolving the ORA-01920 should be easy. If the user does indeed already exist in the dba_users table, either use the existing user or create a user with a different user name. Attempting to drop an existing user, particularly from a production database can be very tricky and dangerous. ORA-01920 can also occur when attempting to assign user roles that have already been assigned. Querying user_role_privs can help determine which roles have been assigned and by whom. Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for
the error, the probable cause, and the recommended action. Each error code corresponds to an exception class. See "Runtime and Development Exceptions" for more information. Format: A description shown in the actual exception thrown. Cause: The most probable cause for the error. Action: Suggestions for resolving the error. Descriptor Exceptions (1 - 176) Error code: 1 ATTRIBUTE_AND_MAPPING_WITH_INDIRECTION_ MISMATCH Cause:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business http://stackoverflow.com/questions/14734131/managing-error-handling-while-running-sqlplus-from-shell-scripts Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs https://community.emc.com/thread/186425?tstart=0 Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Managing error handling while running sqlplus from shell scripts up vote 9 down vote favorite 4 #!/bin/sh echo "Please enter evaluate database username" oracle error read eval_user echo "Please enter evaluate database password" read eval_pass echo "Please enter the database name" read db_name LOGFILE=shell_log.txt $ORACLE_HOME/bin/sqlplus -s /nolog <<-EOF>> ${LOGFILE} connect $eval_user/$eval_pass@$db_name WHENEVER OSERROR EXIT 9; WHENEVER SQLERROR EXIT SQL.SQLCODE; DBMS_OUTPUT.put_line('Connected to db'); EOF if [ $? != 0 ] then echo "The upgrade script failed. Please refer to the log results.txt for more information" echo "Error code $?" exit 0; fi I am entering garbage values trying to force this oracle error code script to fail. But, annoyingly, it keeps moving ahead without any mention of any error code. What else needs to be done here? oracle shell sqlplus aix share|improve this question asked Feb 6 '13 at 16:35 roymustang86 1,941113573 Which OS user account are you running under? What database does the script login to? –APC Feb 11 '13 at 14:01 I tried your script, and the log file is capturing the error code. Here is the grab from the log file: ERROR: ORA-01017: invalid username/password; logon denied SP2-0734: unknown command beginning "DBMS_OUTPU..." - rest of line ignored. –Incognito Feb 12 '13 at 9:55 May I know, what're you getting in log file when you execute the script? –Incognito Feb 12 '13 at 11:18 add a comment| 5 Answers 5 active oldest votes up vote 7 down vote accepted +50 What Max says is correct. Try this modified script #!/bin/sh echo "Please enter evaluate database username" read eval_user echo "Please enter evaluate database password" read eval_pass echo "Please enter the database name" read db_name LOGFILE=shell_log.txt sqlplus -s /nolog <<-EOF>> ${LOGFILE} WHENEVER OSERROR EXIT 9; WHENEVER SQLERROR EXIT SQL.SQLCODE; connect $eval_user/$eval_pass@$db_name DBMS_OUTPUT.put_line('Connected to db'); EOF sql_return_code=$? if [ $sql_return_code != 0 ] then echo "The upgrade script failed. Please refer to the log results.txt for more information" echo "Erro
Management Converged Platforms Data Protection Infrastructure Management Platform Solutions Security Storage Dell Products for Work Network Servers Education Partners Programs Highlighted Communities Support » Connect » Developers » Partners » Downloads » 日本語コミュニティ EMC Community Dell Community A AppSync Application Xtender Atmos Avamar C Captiva Celerra Centera CLARiiON Cloud Tiering Appliance Connectrix D Data Domain Data Protection Advisor Disk Library DiskXtender Documentum E ECS eRoom G Greenplum H Host Systems I InfoArchive Isilon ISIS Document Imaging L Leap N NetWorker P PowerPath Prosphere R RecoverPoint Replication RSA S ScaleIO Secure Remote Smarts SourceOne & EmailXtender EMC Storage Analytics Symmetrix U Unity V ViPR Controller Product Communities > NetWorker > Discussions Please enter a title. You can not post a blank message. Please type your message and try again. 1 2 3 Previous Next 33 Replies Latest reply: Sep 5, 2016 11:26 PM by Katrine Error 1920 / Service failed to start during client install ribosom Dec 15, 2013 3:45 AM I have two clients running Windows 2008 Standard which refuse to have the Networker client installed on them. The problem is that at the very end of the install nsrexecd fails to start with the error:Error 1920. Service nsrexecd failed to start. Verify you have sufficient privileges to start system services.After this I have to cancel and the install is rolled back.The service is using the local system account, and I am using domain admin account for the installation. The available articles suggest to attempt install to a different disk/location, but it did not help. Same thing happens for 8.0.1 and 7.6.5 install. Server has already been rebooted.Any ti