<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by AleynaGulec on Medium]]></title>
        <description><![CDATA[Stories by AleynaGulec on Medium]]></description>
        <link>https://medium.com/@aleynagulec?source=rss-f6c1be87632e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*o1yBDMKY5WQ_u_SL7Wy4Uw.png</url>
            <title>Stories by AleynaGulec on Medium</title>
            <link>https://medium.com/@aleynagulec?source=rss-f6c1be87632e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 09:19:23 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@aleynagulec/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[ORA-28003 — ORA-20000 error]]></title>
            <link>https://aleynagulec.medium.com/ora-28003-ora-20000-error-2fed796b830c?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/2fed796b830c</guid>
            <category><![CDATA[oracle-19c]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[oracle11g]]></category>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[oracle-database]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Fri, 18 Jul 2025 08:32:52 GMT</pubDate>
            <atom:updated>2025-07-18T08:33:16.081Z</atom:updated>
            <content:encoded><![CDATA[<h3>ORA-28003 — ORA-20000 error</h3><p>Merhaba,</p><p>Bu yazımda ORA-28003 ve ORA-20000 hatalarıyla birlikte çözümünden bahsedeceğim.</p><p>HATA:</p><p>SQL&gt; ALTER USER deneme identified by deneme12;</p><p>*</p><p>ERROR at line 1:</p><p>ORA-28003: password verification for the specified password failed</p><p>ORA-20000: password length less than 15 bytes</p><p>ÇÖZÜM:</p><p>SQL&gt; select username,profile from dba_users where username=’DENEME’;</p><p>USERNAME PROFILE <br> — — — — — — — — — — — — — — — — — — — — — — — — <br>DENEME DEFAULT</p><p>SQL&gt; select profile, limit from dba_profiles where resource_name = <br>‘PASSWORD_VERIFY_FUNCTION’ and profile=’DEFAULT’;</p><p>USERNAME LIMIT<br> — — — — — — — — — — — — — — — — — — — — — — — —</p><p>DEFAULT ORA12C_STIG_VERIFY_FUNCTION</p><p>SQL&gt; ALTER PROFILE “DEFAULT” LIMIT PASSWORD_VERIFY_FUNCTION null;</p><p>SQL&gt; ALTER USER deneme identified by deneme12;</p><p>User altered.</p><p>SQL&gt; ALTER PROFILE “DEFAULT” LIMIT PASSWORD_VERIFY_FUNCTION ORA12C_STIG_VERIFY_FUNCTION;</p><p>Umarım sizler için faydalı olur..</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2fed796b830c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[ORA-28650: Primary index on an IOT cannot be rebuilt]]></title>
            <link>https://medium.com/machine-learning-t%C3%BCrkiye/ora-28650-primary-index-on-an-iot-cannot-be-rebuilt-7d321e81731a?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/7d321e81731a</guid>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[oracle-database]]></category>
            <category><![CDATA[error]]></category>
            <category><![CDATA[hata]]></category>
            <category><![CDATA[database]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Thu, 08 May 2025 11:34:23 GMT</pubDate>
            <atom:updated>2025-11-27T07:54:10.243Z</atom:updated>
            <content:encoded><![CDATA[<p>Merhaba,</p><p>ORA-28650 hatasını ve bu hata alındığında izlemeniz gereken yolu aşağıda paylaşıyorum.</p><pre>SQL&gt; alter index ALNA.ORDER_PK rebuild tablespace TS_ALNA01;<br><br>alter index ALNA.ORDER_PK rebuild tablespace TS_ALNA01;<br>*<br>ERROR at line 1:<br><br>ORA-28650: Primary index on an IOT cannot be rebuilt<br><br>SQL&gt; select index_type, table_name from dba_indexes where index_name=&#39;ORDER_PK&#39;;<br><br>INDEX_TYPE TABLE_NAME<br>- - - - - - - - - - - - - - - - - - - <br><br>IOT - TOP CLASSIFICATION_STORE<br><br>SQL&gt; alter table ALNA.ORDER_PK move tablespace TS_ALNA01;<br><br>Table altered.</pre><p>Umarım sizin için yararlı bir paylaşım olur..</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7d321e81731a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/machine-learning-t%C3%BCrkiye/ora-28650-primary-index-on-an-iot-cannot-be-rebuilt-7d321e81731a">ORA-28650: Primary index on an IOT cannot be rebuilt</a> was originally published in <a href="https://medium.com/machine-learning-t%C3%BCrkiye">Machine Learning Turkiye</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Mount: wrong fs type, bad option, bad superblock on NFS]]></title>
            <link>https://aleynagulec.medium.com/mount-wrong-fs-type-bad-option-bad-superblock-on-nfs-fe24f6b7f63d?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/fe24f6b7f63d</guid>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[linux]]></category>
            <category><![CDATA[disk]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[nfs-server]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Tue, 06 Dec 2022 06:49:36 GMT</pubDate>
            <atom:updated>2022-12-06T06:49:36.883Z</atom:updated>
            <content:encoded><![CDATA[<p>Merhaba, NFS diski mount ederken aşağıdaki hatayı alıyorsa belirtilen adımları takip etmeniz yeterli olacaktır.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lJfugpDvaa4oq-_uklxTQA.png" /></figure><pre>yum install nfs-utils<br><br>yum install nfs-common<br><br>yum install cifs-utils</pre><p>Umarım sizler için faydalı bir doküman olmuştur. Eğer merak ettikleriniz olursa bana<strong> </strong><a href="https://www.linkedin.com/in/aleyna-g%C3%BCle%C3%A7-3028bb133/"><strong>LinkedIn</strong></a><strong> </strong>hesabımdan ulaşabilirsiniz. Bir sonraki yazılarımda görüşmek dileğiyle :)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fe24f6b7f63d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[TNS-01030 : The listener supports no services]]></title>
            <link>https://aleynagulec.medium.com/tns-01030-the-listener-supports-no-services-a97aa7513549?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/a97aa7513549</guid>
            <category><![CDATA[listener]]></category>
            <category><![CDATA[oracle11g]]></category>
            <category><![CDATA[oracle-19c]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[oracle-12c]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Fri, 02 Dec 2022 13:22:52 GMT</pubDate>
            <atom:updated>2022-12-02T13:22:52.999Z</atom:updated>
            <content:encoded><![CDATA[<h3>TNS-01030 : The listener supports no services</h3><p>Merhaba, listener’ı başlattığınızda eğer listener veritabanını dinlemiyorsa aşağıdaki adımları takip etmeniz yeterli olacaktır.</p><p><strong>HATA:</strong></p><pre>[oracle@prod ~]$ lsnrctl status<br><br>The listener supports no services</pre><p><strong>ÇÖZÜM:</strong></p><pre>SQL&gt; show parameter local_listener<br>NAME TYPE VALUE<br> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <br>local_listener string</pre><p>local_listener parametresini sunucunuzun host ve port’una göre setlemeniz gerekmektedir. Ardından register ederek sorunu ortadan kaldırabilirsiniz.</p><pre>SQL&gt; alter system set local_listener=&#39;(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.xx.x)(PORT=1534))&#39;;<br><br>SQL&gt; show parameter local_listener<br>NAME TYPE VALUE<br> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <br>local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.xx.x)(PORT=1534))<br><br>SQL&gt; alter system register;</pre><p>Listener’ı kontrol ettiğinizde veritabanını dinlediğini gözlemleyeceksiniz.</p><pre>[oracle@primary01 admin]$ lsnrctl status<br>...<br>Service &quot;PRODDB&quot; has 1 instance(s).<br> Instance &quot;PRODDB&quot;, status READY, has 1 handler(s) for this service…<br>Service &quot;PRODDBXDB&quot; has 1 instance(s).<br> Instance &quot;PRODDB&quot;, status READY, has 1 handler(s) for this service…<br>The command completed successfully</pre><p>Umarım sizler için faydalı bir doküman olmuştur. Eğer merak ettikleriniz olursa bana<strong> </strong><a href="https://www.linkedin.com/in/aleyna-g%C3%BCle%C3%A7-3028bb133/"><strong>LinkedIn</strong></a><strong> </strong>hesabımdan ulaşabilirsiniz. Bir sonraki yazılarımda görüşmek dileğiyle :)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a97aa7513549" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[ORA-00821: Specified value of sga_target 1024M is too small, needs to be at least 1732M]]></title>
            <link>https://aleynagulec.medium.com/ora-00821-specified-value-of-sga-target-1024m-is-too-small-needs-to-be-at-least-1732m-91847d3e153?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/91847d3e153</guid>
            <category><![CDATA[linux]]></category>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[oracle11g]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[oracle-19c]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Fri, 02 Dec 2022 13:10:09 GMT</pubDate>
            <atom:updated>2022-12-02T13:10:25.310Z</atom:updated>
            <content:encoded><![CDATA[<p>Merhaba, <strong>ORA-00821</strong> hatası ve çözümü aşağıdaki gibidir.</p><p><strong>HATA:</strong></p><p>ORA-00821: Specified value of sga_target 1024M is too small, needs to be at least 1732M</p><p><strong>ÇÖZÜM:</strong></p><pre>SQL&gt; startup<br>ORA-00821: Specified value of sga_target 1024M is too small, needs to be at 1732M<br><br><br>SQL&gt; alter system set sga_target=1732M scope=spfile;<br>alter system set sga_target=1732M scope=spfile<br>*<br>ERROR at line 1:ORA-01034: ORACLE not available</pre><p>Pfile dosyası, hatada verdiği değere göre düzenlenir.</p><pre>SQL&gt; create pfile from spfile;<br>File created.<br><br>*sga_target=1732M<br><br>SQL&gt; startup pfile= $ORACLE_HOME/dbs/initPROD.ora<br>ORACLE instance started.</pre><p>Umarım sizler için faydalı bir doküman olmuştur. Eğer merak ettikleriniz olursa bana<strong> </strong><a href="https://www.linkedin.com/in/aleyna-g%C3%BCle%C3%A7-3028bb133/"><strong>LinkedIn</strong></a><strong> </strong>hesabımdan ulaşabilirsiniz. Bir sonraki yazılarımda görüşmek dileğiyle :)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=91847d3e153" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[ORA-09968 — unable to lock file]]></title>
            <link>https://aleynagulec.medium.com/ora-09968-unable-to-lock-file-37d0f2431896?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/37d0f2431896</guid>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[oracle11g]]></category>
            <category><![CDATA[oracle-database]]></category>
            <category><![CDATA[oracle-19c]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Fri, 25 Nov 2022 08:43:46 GMT</pubDate>
            <atom:updated>2022-11-25T08:44:09.303Z</atom:updated>
            <content:encoded><![CDATA[<h3>ORA-09968 : unable to lock file</h3><p>Merhaba, veritabanını açarken<strong> ORA-09968 </strong>hatasını alıyorsanız aşağıdaki adımları takip etmeniz yeterli olacaktır.</p><p><strong>HATA:</strong></p><pre>SYS&gt; startup nomount<br>ORA-10997: another startup/shutdown operation of this instance inprogress<br>ORA-09968: unable to lock file<br>Linux-x86_64 Error: 11: Resource temporarily unavailable<br>Additional information: 1751</pre><p><strong>ÇÖZÜM:</strong></p><pre>[root@test ~]# ipcs<br> - - - Message Queues - - - - <br>key msqid owner perms used-bytes messages <br> - - - Shared Memory Segments - - - - <br>key shmid owner perms bytes nattch status <br>0x00000000 65536 oracle 600 4194304 2 dest <br>0x00000000 163841 oracle 600 4194304 2 dest <br>0x00000000 294915 oracle 600 2097152 2 dest <br>0x00000000 5636102 oracle 600 4194304 2 dest <br>0x00000000 5734407 oracle 600 393216 2 dest <br> - - - Semaphore Arrays - - - - <br>key semid owner perms nsems<br><br>[oracle@test dbs]$ ps -ef|grep pmon<br>oracle 2809 2083 0 02:56 pts/10 00:00:00 grep - color=auto pmon<br><br>[oracle@test dbs]$ fuser *<br>/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/lkinstorcl: 2150<br><br>[oracle@test dbs]$ ps -ef|grep 2150<br>oracle 1751 1 99 02:25 ? 00:24:06 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))<br>oracle 2643 2083 0 02:50 pts/10 00:00:00 grep - color=auto 2150<br><br>[oracle@test dbs]$ kill -9 2150<br><br>[oracle@test dbs]$ fuser *</pre><p>Umarım sizler için faydalı bir doküman olmuştur. Eğer merak ettikleriniz olursa bana<strong> </strong><a href="https://www.linkedin.com/in/aleyna-g%C3%BCle%C3%A7-3028bb133/"><strong>LinkedIn</strong></a><strong> </strong>hesabımdan ulaşabilirsiniz. Bir sonraki yazılarımda görüşmek dileğiyle :)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=37d0f2431896" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Merhaba, Oracle 11.2.0.4.0]]></title>
            <link>https://aleynagulec.medium.com/merhaba-oracle-11-2-0-4-0-c26d4a43b97f?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/c26d4a43b97f</guid>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[linux]]></category>
            <category><![CDATA[oracle11g]]></category>
            <category><![CDATA[oracle-database]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Tue, 22 Nov 2022 07:09:34 GMT</pubDate>
            <atom:updated>2022-11-22T07:09:34.985Z</atom:updated>
            <content:encoded><![CDATA[<h3>“pdksh-5.2.14” is missing when Installing 11.2.0.4 on RHEL 7.6</h3><p>Merhaba, Oracle 11.2.0.4.0 kurulumu sırasında aşağıdaki paket hatası karşıma çıktı. Hata, çözümü ile birlike aşağıdaki gibidir.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/873/1*iaZS8MFzl8Pgmz42Xn8vkg.png" /></figure><p>CV_ASSUME_DISTID parametresi aşağıdaki şekilde düzenlenir.</p><pre>$ cd /setup/database/stage/cvu/cv/admin/ <br> $ vi cvu_config <br>#CV_ASSUME_DISTID=OEL4<br> CV_ASSUME_DISTID=OEL6</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c26d4a43b97f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Global ports off in Root, do SetGlobalPortEnabled(TRUE) to enable.]]></title>
            <link>https://aleynagulec.medium.com/global-ports-off-in-root-do-setglobalportenabled-true-to-enable-2ce8381bab3a?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/2ce8381bab3a</guid>
            <category><![CDATA[error]]></category>
            <category><![CDATA[oracle-19c]]></category>
            <category><![CDATA[oracle-enterprise-manager]]></category>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[oracle]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Tue, 22 Nov 2022 05:48:03 GMT</pubDate>
            <atom:updated>2022-11-22T05:48:43.317Z</atom:updated>
            <content:encoded><![CDATA[<p>Merhaba, Oracle Enterprise Manager’a SYS kullanıcısı ile giriş yaparken loglara aşağıdaki hata düşüyorsa belirtilen çözümü uygulamanız yeterli olacaktır. Hata ve çözümü aşağıdaki gibidir.</p><p><strong>HATA:</strong></p><p>Global ports off in Root, do SetGlobalPortEnabled(TRUE) to enable.</p><p><strong>ÇÖZÜM:</strong></p><p>SQL&gt; exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2ce8381bab3a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Oracle’da Tablo Bazlı İstatistik]]></title>
            <link>https://medium.com/machine-learning-t%C3%BCrkiye/oracleda-tablo-bazl%C4%B1-i%CC%87statistik-ae81f967d7b?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/ae81f967d7b</guid>
            <category><![CDATA[oracle-19c]]></category>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[oracle11g]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Tue, 27 Sep 2022 11:15:11 GMT</pubDate>
            <atom:updated>2022-11-23T07:19:21.055Z</atom:updated>
            <content:encoded><![CDATA[<p>Merhaba, Oracle’da tablo bazlı istatistik syntax’ımız aşağıdaki gibidir.</p><pre><strong>exec DBMS_STATS.GATHER_TABLE_STATS (‘schema_name’ , ‘table_name’, cascade =&gt; true, degree =&gt; 6);</strong></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ae81f967d7b" width="1" height="1" alt=""><hr><p><a href="https://medium.com/machine-learning-t%C3%BCrkiye/oracleda-tablo-bazl%C4%B1-i%CC%87statistik-ae81f967d7b">Oracle’da Tablo Bazlı İstatistik</a> was originally published in <a href="https://medium.com/machine-learning-t%C3%BCrkiye">Machine Learning Turkiye</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[RMAN-06820: warning: failed to archive current log at primary database
cannot connect to remote…]]></title>
            <link>https://aleynagulec.medium.com/rman-06820-warning-failed-to-archive-current-log-at-primary-database-cannot-connect-to-remote-4e6856c5c29a?source=rss-f6c1be87632e------2</link>
            <guid isPermaLink="false">https://medium.com/p/4e6856c5c29a</guid>
            <category><![CDATA[oracle-database]]></category>
            <category><![CDATA[oracle-12c]]></category>
            <category><![CDATA[rman]]></category>
            <category><![CDATA[oracle]]></category>
            <dc:creator><![CDATA[AleynaGulec]]></dc:creator>
            <pubDate>Fri, 23 Sep 2022 13:09:29 GMT</pubDate>
            <atom:updated>2022-09-23T13:09:29.440Z</atom:updated>
            <content:encoded><![CDATA[<h3>RMAN-06820: warning: failed to archive current log at primary database<br>cannot connect to remote database</h3><p>Merhaba, RMAN-06820 hatası ve hata sonucunda uygulamanız gereken adımı göstereceğim.</p><p><strong>HATA:</strong></p><p>RMAN-06820: warning: failed to archive current log at primary database<br>cannot connect to remote database</p><p><strong>ÇÖZÜM:</strong></p><p>Rman backup alınırken 06820 hatası alıyorsanız rman’e kullanıcı adı ve sifresiyle birlikte baglanmalısınız. Bundan sonra hata çözülecek ve backup başarılı alınacaktır.</p><p><strong>rman target &lt;username&gt;/&lt;password&gt;</strong></p><p><strong>rman target &lt;username&gt;/&lt;password&gt;@standby</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4e6856c5c29a" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>