doganay.wordpress.com
USING TURKISH CHARACTERS on UNIX/LINUX | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/2015/07/08/using-turkish-characters-on-unixlinux
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. July 8, 2015 / doganay. USING TURKISH CHARACTERS on UNIX/LINUX. Larr; MASTER NODE in a RAC. GENERATE USER CREATE SCRIPT (COMPLETE) →. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. Notify me of new comments via email.
doganay.wordpress.com
HOW TO DELETE “DATABASE SYSTEM” TARGETS MANUALLY on Enterprise Manager Cloud Control 12c REPOSITORY DB | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/2015/05/08/how-to-delete-database-system-targets-manually-on-enterprise-manager-cloud-control-12c-repository-db
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. May 8, 2015 / doganay. HOW TO DELETE “DATABASE SYSTEM” TARGETS MANUALLY on Enterprise Manager Cloud Control 12c REPOSITORY DB. Delete from sysman.em manageable entities where entity type='oracle dbsys'; commit;. Larr; UPDATE A TABLE WITHOUT GRANT BUG. GENERATE USER CREATE SCRIPT (COMPLETE) →. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public).
doganay.wordpress.com
UPDATE A TABLE WITHOUT GRANT BUG | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/2015/05/06/update-a-table-without-grant-bug
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. May 6, 2015 / doganay. UPDATE A TABLE WITHOUT GRANT BUG. Bug exists on only 11.2.0.3.0-11.2.0.3.8. Does not exist on 11.1 and below, 11.2.0.3.9-current latest psu 11.2.0.3.X, 11.2 and 12c. SQL create user u2 identified by Deneme 1234;. 10g and before ————–. SQL update (with tmp as (select * from u1.t1) select * from tmp) set a=2 where b=1 * ERROR at line 1: ORA-01732: data manipulation operation not legal on this view. ORA-24...
doganay.wordpress.com
doganay | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/author/doganay
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. MMON PROCESS IS NOT RUNNING. DBA ERRORS HTML FORMATTING. ORA-01017: invalid username/password; logon denied. ORA-32318: CANNOT RENAME A MATERIALIZED VIEW. ORA-01548 WHEN DROPPING UNDO TBS. 8220;IS MY SCRIPT RUNNING” SHELL SCRIPT CODE PIECE. HOW TO ADD LINES TO TRACE FILES AND/OR ALERT LOG USING DBMS SYSTEM. HOW TO VI LAST N LINES OF A FILE. DROP PARTITION WITHOUT PASSING PARTITION NAME. Mustafa DOĞANAY Linkedin Page. Yasin BA...
doganay.wordpress.com
SHELL COMMANDS for DBAs | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/shell-commands-for-dbas
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. SHELL COMMANDS for DBAs. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Mustafa DOĞANAY Linkedin Page.
doganay.wordpress.com
GENERATE USER CREATE SCRIPT (COMPLETE) | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/2015/07/08/generate-user-create-script-complete-2
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. July 8, 2015 / doganay. GENERATE USER CREATE SCRIPT (COMPLETE). Select ‘alter user ‘ username ’ quota ‘ decode(max bytes,-1,’UNLIMITED’,max bytes) ’ on ‘ tablespace name ’ ’ from DBA ts quotas. Where username=upper(trim(‘& USERNAME’). Mustafa DOGANAY's Blog. Larr; USING TURKISH CHARACTERS on UNIX/LINUX. HOW TO CREATE A PRIMARY KEY PARALEL →. Leave a Reply Cancel reply. Enter your comment here. Address never made public).
doganay.wordpress.com
MOS TRICKS | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/2015/04/28/mos-tricks
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. April 28, 2015 / doganay. Https:/ support.oracle.com/rs? Https:/ updates.oracle.com/download/XXXXXX.html. Https:/ support.oracle.com/epmos/faces/BugDisplay? MOS Expire popup close:. Javascript:(function(){document.getElementById(‘DhtmlZOrderManagerLayerContainer’).style.display=’none’ })(). Larr; Error in invoking target ‘agent nmhs’ of makefile. UPDATE A TABLE WITHOUT GRANT BUG →. Leave a Reply Cancel reply. ORA-38774: canno...
doganay.wordpress.com
GENERATE USER CREATE SCRIPT (COMPLETE) | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/2015/05/14/generate-user-create-script-complete
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. May 14, 2015 / doganay. GENERATE USER CREATE SCRIPT (COMPLETE). Larr; HOW TO DELETE “DATABASE SYSTEM” TARGETS MANUALLY on Enterprise Manager Cloud Control 12c REPOSITORY DB. LAST DDL TIME ON DBA OBJECTS NOT CHANGING →. Doganay / Jul 8 2015 1:13 pm. Reblogged this on Mustafa DOGANAY's Blog. Where username=upper(trim(‘& USERNAME’). Leave a Reply Cancel reply. Enter your comment here. Address never made public). ORA-04023: Objec...
doganay.wordpress.com
UNABLE TO OPEN THE SUBSYSTEM FOR SFTP | Mustafa DOGANAY's Blog
https://doganay.wordpress.com/2015/06/05/unable-to-open-the-subsystem-for-sftp
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. June 5, 2015 / doganay. UNABLE TO OPEN THE SUBSYSTEM FOR SFTP. When trying to sftp:. Unable to open the subsystem for SFTP. The most likely reason is that the server does not support this subsystem. Please contact the server’s administrator for further information. Locate sftp-server /usr/libexec/sftp-server # Edit sftp server line in /etc/ssh/sshd config # service sshd reload. Close all ssh sessions and try to sftp again.
doganay.wordpress.com
Mustafa DOGANAY's Blog | Mustafa DOGANAY's Oracle Blog | Page 2
https://doganay.wordpress.com/page/2
Mustafa DOGANAY's Blog. Mustafa DOGANAY's Oracle Blog. SHELL COMMANDS for DBAs. August 12, 2016 / doganay. COLUMN ADDING WITH DEFAULT VALUE ACCELERATING. This is called DDL OPTIMIZATION alter table t1 add(col1 number default 1 not null);. August 12, 2016 / doganay. SQL select regexp substr('SMITH,ALLEN,WARD,JONES','[ ,] ', 1, level) COL1 from dual 2 connect by regexp substr('SMITH,ALLEN,WARD,JONES', '[ ,] ', 1, level) is not null; COL1 - - SMITH ALLEN WARD JONES. August 12, 2016 / doganay. A- 4B414C414E4...
SOCIAL ENGAGEMENT