tag:blogger.com,1999:blog-71472762724649296112024-03-11T02:26:26.583-07:00Oracle Teknolojileri, Weblogic, SOA Suite, Java, Kurumsal Veri Sözlüğü, API Gateway, API ManagerOracle Teknolojileri, Weblogic, SOA Suite, Java, Kurumsal Veri Sözlüğü, API Gateway, API Manager, Veri Sözlüğü, SOAGEN, Metanizer, Apinizerasadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.comBlogger199125tag:blogger.com,1999:blog-7147276272464929611.post-61867968748867378812017-03-02T00:38:00.002-08:002017-03-02T00:42:42.088-08:00rman scriptconnect target 'system/oracle'<br />
run {<br />
crosscheck archivelog all;<br />
delete noprompt expired archivelog all;<br />
crosscheck backup;<br />
delete noprompt expired backup;<br />
BACKUP database format '/backup/datafile/db_%t_%s_%p.dbf';<br />
sql 'alter system archive log current';<br />
sql 'alter system archive log current';<br />
backup archivelog all format '/backup/archivelog/al_%t_%s_p%p.dbf' delete all input;<br />
backup current controlfile tag =cf1 format '/backup/controlfile/cf_%t_%s_%p.dbf';<br />
delete noprompt obsolete redundancy = 1;<br />
crosscheck archivelog all;<br />
crosscheck backup;<br />
Crosscheck Copy;<br />
Crosscheck Backup;<br />
delete noprompt expired archivelog all;<br />
delete noprompt expired copy;<br />
delete noprompt expired backup;<br />
delete NOPROMPT BACKUP OF SPFILE COMPLETED BEFORE 'SYSDATE-3';<br />
delete NOPROMPT BACKUP OF CONTROLFILE COMPLETED BEFORE 'SYSDATE-3';<br />
}asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com4tag:blogger.com,1999:blog-7147276272464929611.post-67478668698114441022017-01-22T06:16:00.001-08:002017-01-22T06:16:57.683-08:00Oracle Delete Archivelog Using RMANHow to delete Archivelog Using RMAN<br />
<br />
<br />
<b>Archivelog List Commands</b><br />
<br />
RMAN>list archivelog all;<br />
RMAN>list copy of archivelog until time ‘SYSDATE-3’;<br />
RMAN>list copy of archivelog from time ‘SYSDATE-3’<br />
RMAN>list copy of archivelog from time ‘SYSDATE-3’ until time ‘SYSDATE-1’;<br />
RMAN>list copy of archivelog from sequence 786544;<br />
RMAN>list copy of archivelog until sequence 786544;<br />
RMAN>list copy of archivelog from sequence 50000 until sequence 60000;<br />
<br />
<b>Archivelog Delete Commands</b><br />
<br />
RMAN>delete archivelog all;<br />
RMAN>delete archivelog until time ‘SYSDATE-3’;<br />
RMAN>delete archivelog from time ‘SYSDATE-3’<br />
RMAN>delete archivelog from time ‘SYSDATE-3’ until time ‘SYSDATE-1’;<br />
RMAN>delete archivelog from sequence 786544;<br />
RMAN>delete archivelog until sequence 786544;<br />
RMAN>delete archivelog from sequence 50000 until sequence 60000;<br />
<br />
Also, you can use noprompt statement for do not yes-no question.<br />
<br />
RMAN>delete noprompt archivelog until time ‘SYSDATE-10’;<br />
<br />asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-44827174564382520422017-01-21T07:35:00.002-08:002017-01-21T07:36:48.921-08:00Centos 6/7 Rethad 6/7 OEL 6/7 change time zone Centos 6/7 Rethad 6/7 OEL 6/7 change time zone<br />
<br />
# show the list of timezones<br />
<b>[root@easlan~]# timedatectl list-timezones </b><br />
Asia/Aden<br />
Asia/Almaty<br />
........<br />
Europe/Istanbul<br />
.....<br />
<br />
# set timezone<br />
<b>[root@easlan~]# timedatectl set-timezone Europe/Istanbul</b><br />
<br />
# show status<br />
<b>[root@easlan~]# timedatectl </b><br />
<b><br /></b>
Local time: Sat 2017-01-21 18:35:33 +03<br />
Universal time: Sat 2017-01-21 15:35:33 UTC<br />
RTC time: Sat 2017-01-21 18:35:33<br />
Time zone: Europe/Istanbul (+03, +0300)<br />
NTP enabled: yes<br />
NTP synchronized: yes<br />
RTC in local TZ: yes<br />
<br />
<br />
# test<br />
<b>[root@easlan~]# date</b><br />
Sat Jan 21 18:36:22 +03 2017<br />
<br />asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-76528408157680233302017-01-18T09:57:00.000-08:002017-01-18T09:57:00.363-08:00Oracle Change Listener Default Name<b>Oracle Change Listener Default Name</b><br />
<br />
<br />
$ ps -ef | grep tns<br />
<br />
oracle 9214 1 0 12:51 ? 00:00:00 /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr LISTENER -inherit<br />
<br />
<br />
$ lsnrctl stop LISTENER<br />
[oracle@easlan ~]$ lsnrctl stop<br />
<br />
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))<br />
The command completed successfully<br />
<br />
$ $ORACLE_HOME/network/admin and modify Listener.ora<br />
<br />
[oracle@easlan ~]$ cd /u01/app/oracle/product/11.2.0/db_1/network/admin/<br />
<br />
SID_LIST_EASLAN=<br />
(SID_LIST =<br />
(SID_DESC =<br />
(SID_NAME = PLSExtProc)<br />
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)<br />
(PROGRAM = extproc)<br />
)<br />
)<br />
<br />
EASLAN =<br />
(DESCRIPTION_LIST =<br />
(DESCRIPTION =<br />
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))<br />
(ADDRESS = (PROTOCOL = TCP)(HOST = easlan.localdomain)(PORT = 1521))<br />
)<br />
)<br />
<br />
<br />
Step Four :<br />
<br />
lsnrctl start EASLAN<br />
<br />
<br />
Step Five :<br />
<br />
SQL> show parameter local_listener<br />
<br />
SQL> alter system set local_listener='(address=(protocol=tcp)(host=your-hostname)(port=1521))';<br />
SQL> alter system register;asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-63771959851267429042017-01-18T03:19:00.004-08:002017-01-18T03:19:31.310-08:00ORA-04031 : Unable to allocate x bytes of shared memory<b style="background-color: white; color: red; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">ORA-04031 : Unable to allocate x bytes of shared memory</b><br />
<b style="background-color: white; color: red; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><br /></b>
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause :</b><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">ORA-04031 - deals with shared memory issues. It's lack of allocation of contiguous memory as and when requested by the current executing sql i.e., when process attempts to allocate a large piece of contiguous memory in the shared pool fails. </span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action:</b><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> If the shared pool is out of memory, either use the DBMS_SHARED_ POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">More ORA errors...</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="https://sites.google.com/site/oraclepracticals/troubleshoot/ora-04031" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">Click here</a><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> to read more for best practice.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2013/10/ora-01442-column-to-be-modified-to-not.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-01442</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2013/11/ora-00910-specified-length-too-long-for.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-00910</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2013/11/troubleshoot-ora-16191-ora-17629-with.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-17629</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2013/11/troubleshoot-ora-16191-ora-17629-with.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-16191</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2013/12/when-standby-db-not-in-synch-due-to-ora.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-27069</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2013/12/when-standby-db-not-in-synch-due-to-ora.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-00333</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2013/12/ora-00600-internal-error-code-arguments.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-00600</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2014/01/troubleshoot-ora-12018-ora-22992-oracle.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-22992</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2014/01/troubleshoot-ora-12018-ora-22992-oracle.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-12018</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2014/02/troubleshoot-ora-07445-exception.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-07445</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2014/05/troubleshoot-ora-02020-too-many.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">ORA-02020 </a><br />
<br />
<br />asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-89939162138097029242017-01-18T03:19:00.000-08:002017-01-18T03:19:05.858-08:00ORA-00054: resource busy and acquire with NOWAIT specified<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-00054: resource busy and acquire with NOWAIT specified</span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause : </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">This error usually comes when you are changing DDL but object is currently using by other user. It is not a critical error.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action : </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Redefine your object using ONLINE key word where ever possible.</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-25975722492217523692017-01-18T03:18:00.003-08:002017-01-18T03:18:22.099-08:00ORA-00918: column ambiguously defined<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-00918: column ambiguously defined</span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause :</b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">When ORA-00918 is thrown, you have a column which has been ambiguously defined. If a column name in a join is referenced ambiguously, it exists in multiple tables.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Column names which occur in multiple tables should be prefixed when it is referenced by its table name.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Columns must be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUM . Oracle documentation which reference ORA-00918 give the following example:</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- If tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">To correct ORA-00918, references should be prefixed to column names existing in multiple tables (either with the table name or table alias and a period)</span><br />
<span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><br /></span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com2tag:blogger.com,1999:blog-7147276272464929611.post-79742806530002340582017-01-18T03:17:00.007-08:002017-01-18T03:17:51.877-08:00ORA-01031: insufficient privileges<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-01031: insufficient privileges</span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. This error may occur if the user was granted the necessary privilege at a higher label than the current login.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action:</b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">For the DBA, the ORA-01031 can happen if the target OS executables do not have read and execute permissions (e.g. (770) in UNIX/Linux), and ensure that the oracle user is a member of the dba group (e.g. /etc/group). There are similar permission in the Windows registry.</span><br />
<span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><br /></span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-68536063890580950032017-01-18T03:17:00.003-08:002017-01-18T03:17:21.641-08:00ORA-00257: archiver error. Connect internal only, until freed. <b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-00257: archiver error. Connect internal only, until freed. </span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.</span><br />
<span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><br /></span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-3032341579567386932017-01-18T03:16:00.007-08:002017-01-18T03:16:51.462-08:00ORA-01652: unable to extend temp segment by string in tablespace string<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-01652: unable to extend temp segment by string in tablespace string</span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Use ALTER TABLESPACE ADD TEMPFILE statement to add one or more files to the tablespace indicated.</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-61495856438390762652017-01-18T03:16:00.003-08:002017-01-18T03:16:27.581-08:00ORA-07445 - exception encountered: core dump<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-07445 - exception encountered: core dump</span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause :</b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> An operating system exception occurred which should result in the creation of a core file. This is an internal error.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action :</b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> Contact Oracle Customer Support.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Common precipitators of the ORA-07445 include:</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- High volume user transactions</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Software bugs (i.e. Bug 4098853). See note 342443.1 on MOSC.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Too-small RAM regions (shared_pool_size, java pool, large_pool_size), and a too-small application memory stack (e.g. PL/SQL array too small)</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Too small undo and temp segments</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Program errors (addressing outside of RAM region), e.g. S0C4. Improper NLS parameter settings</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Hardware errors</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- Oracle block corruption and a host of other related issues. </span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">-- When Oracle internal job failed with specific exception</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Note:</b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> There are lots of reason for ORA-07445, Based of arguments and oracle document you can fix it. So may bugs are described in oracle document for ORA-07445.</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-5154661331944851592017-01-18T03:15:00.003-08:002017-01-18T03:15:49.678-08:00ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too small<b>ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too small</b><br />
<br />
<span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Query to execute to find issued tablespace:</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: xx-small;"><span style="font-family: "Courier New", Courier, monospace;">select * from(<br />SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file#<br />, greatest(e.block_id, c.block#) corr_start_block#<br /> , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block#<br /> , least(e.block_id+e.blocks-1, c.block#+c.blocks-1)<br /> - greatest(e.block_id, c.block#) + 1 blocks_corrupted<br /> , null description<br /> FROM dba_extents e, v$database_block_corruption c<br /> WHERE e.file_id = c.file#<br /> AND e.block_id <= c.block# + c.blocks - 1<br /> AND e.block_id + e.blocks - 1 >= c.block#<br /> UNION<br /> SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file#<br /> , header_block corr_start_block#<br /> , header_block corr_end_block#<br /> , 1 blocks_corrupted<br /> , 'Segment Header' description<br /> FROM dba_segments s, v$database_block_corruption c<br /> WHERE s.header_file = c.file#<br /> AND s.segment_name is NOT NULL<br /> AND s.header_block between c.block# and c.block# + c.blocks - 1<br /> UNION<br /> SELECT null owner, null segment_type, null segment_name, null partition_name, c.file#<br /> , greatest(f.block_id, c.block#) corr_start_block#<br /> , least(f.block_id+f.blocks-1, c.block#+c.blocks-1) corr_end_block#<br /> , least(f.block_id+f.blocks-1, c.block#+c.blocks-1)<br /> - greatest(f.block_id, c.block#) + 1 blocks_corrupted<br /> , 'Free Block' description<br /> FROM dba_free_space f, v$database_block_corruption c<br /> WHERE f.file_id = c.file#<br /> AND f.block_id <= c.block# + c.blocks - 1<br /> AND f.block_id + f.blocks - 1 >= c.block#<br /> order by file#, corr_start_block#) t where segment_name IS NOT NULL; </span></span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Solution with workaround:</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Force an extension of the SYSTEM rollback segment to occur using the following :</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; color: #0b5394; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="font-family: "Courier New", Courier, monospace;">connect / as sysdba<br />alter system set undo_management = MANUAL scope=spfile ;<br />shutdown immediate ;<br />startup ;<br /><br />create table sample (c1 number, c2 varchar2(10));<br /> </span></span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; color: #0b5394; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="font-family: "Courier New", Courier, monospace;">begin<br />for i in 1.. 400000 loop<br />insert into sample values (i,'ABCDEFGH');<br />end loop;<br />end;<br />/<br /><br />delete sample;<br />commit;<br /><br />alter system set undo_management = AUTO scope=spfile;<br /><br />shutdown immediate<br />startup </span></span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-69980580012185902612017-01-18T03:14:00.008-08:002017-01-18T03:14:58.476-08:00ORA-01555 Snapshot Too Old<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-01555 Snapshot Too Old</span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">The ORA-01555 is caused by Oracle read consistency mechanism. If you have a long running SQL that starts at 10:30 AM, Oracle ensures that all rows are as they appeared at 10:30 AM, even if the query runs until noon! Oracles does this by reading the "before image" of changed rows from the online undo segments. If you have lots of updates, long running SQL and too small UNDO, the ORA-01555 error will appear.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">From the docs we see that the ORA-01555 error relates to insufficient undo storage or a too small value for the undo_retention parameter:</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">ORA-01555: snapshot too old: rollback segment number string with name "string" too small</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Rollback records needed by a reader for consistent read are overwritten by other writers.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action: </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">If in Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><a href="http://facedba.blogspot.in/2015/01/setting-of-optimal-value-for-undo.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">Click here</a><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> to read : </span><a href="http://facedba.blogspot.in/2015/01/setting-of-optimal-value-for-undo.html" style="background-color: white; color: black; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-decoration: none;" target="_blank">how to set optimal value for undo retention and undo tablespace size</a><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">If you are facing following error for the below query, then do the my suggested action plan. I rectified the issue in same way.</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-89042097764249601082017-01-18T03:14:00.005-08:002017-01-18T03:14:36.204-08:00ORA-03113: end-of-file on communication channel<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;">ORA-03113: end-of-file on communication channel</span></b><br />
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: red;"><br /></span></b>
<span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">This error pretty much means that your connection has clutched its chest and died. For some reason, your client machine and the database server are acting like an old married couple and have stopped talking to each other. That reason could be one of a rather long list: has your server crashed? has someone pulled out your network cable? was your process killed at the O/S level? is your Windows log full? or maybe there is an Oracle internal error?</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Do not overlook the obvious. This error is sometimes caused by the simplest of things. If, however, it is caused by an Oracle internal error, look to your alert log for further information.</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-48823276997656201712017-01-18T03:14:00.002-08:002017-01-18T03:14:14.925-08:00ORA-00600: internal error code, arguments: [%s], [%s],[%s], [%s], [%s]<span style="background-color: white; font-size: 14.85px;"><span style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><b>ORA-00600: internal error code, arguments: [%s], [%s],[%s], [%s], [%s]</b></span></span><br />
<span style="background-color: white; font-size: 14.85px;"><span style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><b><br /></b></span></span>
<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause : </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">This is a generic error; it means something serious has gone wrong and you are going to need to roll up your sleeves, dig in, and find out what. But you are not without clues. Your alert.log file will contain the path to your trace file. You will want to look in it, as a record is written to the trace file every time an ORA-00600 error occurs.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Take the information you get from your trace file and the first argument in the square brackets (the internal message number), and head over to My Oracle Support (Metalink). There you will find a handy ORA-0600 lookup tool (Note 153788.1) that will direct you to additional information that will help you solve your problem.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action : </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Check with Oracle support as per your version and arguments</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Note:</b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> There are lots of reason for ORA-00600, Based of arguments and oracle document you can fix it. So may bugs are described in oracle document for ORA-00600.</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-68572477161984323682017-01-18T03:13:00.001-08:002017-01-18T03:13:32.161-08:00ORA-12154: TNS:could not resolve the connect identifier specified<b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cause :</b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"> This error is, almost appropriately, often the very first one you get on trying to establish a connection to your database. Simply put, it means that you have named the database you wish to be connected to and Oracle doesn’t know who the heck you’re talking about. This error is often caused by typos, maybe in your connection string, but possibly in your tnsnames.ora file. It is also possible that the tnsnames.ora file is not accessible or does not even exist. If it does, ensure that it contains the service name you are using; also go over it with a fine toothcomb to make sure it doesn’t have any unpaired parentheses or such.</span><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><br style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;" /><b style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Action : </b><span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;">Cross Check tns entry, Check firwall access to connecting server</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-91265595376325550502016-10-18T08:03:00.000-07:002016-10-18T08:03:33.704-07:00Kurumsal Veri Sözlüğü - Enterprise Data Dictionary<div class="separator" style="clear: both; text-align: center;">
<a href="http://metanizer.soagen.com.tr/images/Metanizer-logo-w.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://metanizer.soagen.com.tr/images/Metanizer-logo-w.png" height="102" width="400" /></a></div>
<br />
<a href="http://metanizer.com/" target="_blank">Kurumsal Veri Sözlüğü Platformu</a>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com1tag:blogger.com,1999:blog-7147276272464929611.post-34713800006986495312016-10-18T08:00:00.002-07:002016-10-18T08:03:54.501-07:00Veri Sözlüğü<span style="font-family: "trebuchet ms" , sans-serif; font-size: medium;"><b>Veri Sözlüğü nedir?</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif; font-size: medium;"><b><br /></b></span><span style="font-family: "trebuchet ms" , sans-serif;"> Bir kurum tarafından üretilen, kullanılan ve yönetilen verilere ait üstverilerin (metadata), belirlenen standartlara uygun şekilde tanımlanmasını ve yönetilmesini ve merkezi olarak erişilebilmesini sağlar. Veri sahipliğinin, sorumlularının ve kullanıcılarının bilinmesini sağlayarak kurumsal hafızanın kişilerden bağımsız olarak yönetilebilmesi için çok önemli bir rol oynar. Kurumlar arası entegrasyon çalışmalarında terminoloji birliği sağladığından birlikte çalışılabilirlik için olmazsa olmaz bir kaynak görevi üstlenmektedir.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlPDWpom6LshtvtzDl3SuQtA9IkDXUqYStlpjwkFWdkTlsg-Lbw8pnB5d8DjLCaM3XbQtEGKRMm1_BrFNvqSlmCmGjYcZ2X1ZDSwzn4bUEfxteK0_npdmxa-LU8TRHhaZAalP5T4Lc0PKR/s1600/Metanizer-BeyazYazi.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="58" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlPDWpom6LshtvtzDl3SuQtA9IkDXUqYStlpjwkFWdkTlsg-Lbw8pnB5d8DjLCaM3XbQtEGKRMm1_BrFNvqSlmCmGjYcZ2X1ZDSwzn4bUEfxteK0_npdmxa-LU8TRHhaZAalP5T4Lc0PKR/s200/Metanizer-BeyazYazi.png" width="200" /></a></div>
<span style="font-family: "trebuchet ms" , sans-serif;"><b><br /></b></span><a href="http://metanizer.com/" target="_blank"><span style="font-family: "trebuchet ms" , sans-serif;"><b>Kurumsal Veri sözlüğü Platformu</b></span></a><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"><a href="http://metanizer.com/"></a> Veri Sözlüğü, verinin anlamını, diğer veriler ile ilişkisini, kaynağını, kullanımını ve biçimini tarif eden tanımlamalar topluluğudur. Verinin kendisini tutmaz, verinin niteliklerini ve özelliklerini tanımlar. İhtiyaca göre belli bir alana özgü veya genel kullanım alanları mevcuttur.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"> Paydaşların sistem ile nasıl bir etkileşim kuracağını anlamalarını sağlar, ayrıca kurumun verilerinin kurum içi sahiplerini/sorumlularını tutar.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;">Barındırdığı tanımlar ile kurumun kurumsal hafızasını net ve açık bir şekilde ortaya koyar ve herkes için erişilebilir kılar. Kurumun verilerinin uluslararası standartlara uygun bir şekilde tarif edilmesi sayesinde bilgi paylaşımı veya entegrasyon sırasında yaşanan sıkıntıları minimize eder ve kurum içi ve dışında terminoloji birliği sağlar.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;">Kurum içinde tutarsız veya tekrar eden verilerin oluşmasını engeller böylece sistemlerin yönetilebilir kalmasını sağlar. Yazılım geliştirilirken sıkça başvurulur. Tanımlı, standartlaştırılmış ve birbirleri ile ilişkilendirilmiş veri tipleri sayesinde yazılım analizi, tasarımı, geliştirimi ve test sürecini kolaylaştırır. Yazılımın hızlı, sağlam ve kaliteli bir şekilde yapılabilmesini sağlar.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;">Veri analizi için yapılacak raporlamalar ve sorgulamalar için güçlü bir altyapı oluşturur ve sağladığı tanımlamalar ile yapılacak raporlamaların ve sorgulamaların kolay ve hızlı bir şekilde hazırlanmasını sağlar. Veri Sözlüğü kullanılmadığında yaşanan ortak sorunlar:</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"> Farklı kaynak ve sistemlerden gelen standart olmayan verilerin neden olduğu uyuşmazlıklar, Uyuşmazlıklar nedeniyle sınıflandırma, bütünleştirme, tekilleştirme sorunları,</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;">Donanım, yazılım ve ağ altyapı maliyetlerinin artması, İstenen bilgiye zamanında ve doğru şekilde erişilememesi. Bunlara bağlı olarak; Entegrasyon problemleri, Aynı işi yapan bir çok uygulama, Verimsizlik, Karar almada yetersiz bilgiden kaynaklanan önemli aksaklıklar.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;">Gelişmiş ülkelerde daha sık rastladığımız ve bu sorunların çözümü olarak görülen veri sözlükleri, son yıllarda ülkemizde de kurumların stratejik planlarında yer almaktadır.</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com4tag:blogger.com,1999:blog-7147276272464929611.post-53284045593370910672014-06-08T09:47:00.000-07:002014-06-08T09:47:05.526-07:00Error occurred during initialization of Could not reserve enough space for object heap SOA Domain<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;">You have a fresh SOA Installation and get these errors while starting the Admin Server with command: </span><br />
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><br /></span>
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;">startWebLogic.cmd Error occurred during initialization of VM Could not reserve enough space for object heap Could not create the Java virtual machine. </span><br />
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><br /></span>
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;">Solution : Open user_projects\domains\base_domain\bin\setSOADomainEnv.cmd </span><br />
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><br /></span>
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;">file and change : From : </span><br />
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><br /></span>
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;">set JAVA_OPTIONS=%JAVA_OPTIONS% set DEFAULT_MEM_ARGS=-Xms512m -Xmx1024m set PORT_MEM_ARGS=-Xms768m -Xmx1536m </span><br />
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><br /></span>
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;">To:</span><br />
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><br /></span>
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"> set JAVA_OPTIONS=%JAVA_OPTIONS% set DEFAULT_MEM_ARGS=-Xms512m -Xmx768m set PORT_MEM_ARGS=-Xms768m -Xmx1536m Save the file and then re-run startWebLogic.cmd :</span>asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-57872326186269604662013-12-28T12:46:00.002-08:002013-12-28T12:46:12.613-08:00Error Starting Weblogic Admin Server: Could not reserve enough space for object heap<span style="background-color: white; font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: 13px; line-height: 18.90625px;">The first time that I run my weblogic admin server after installing and configuring oracle soa in weblogic 10.3.x, I encountered the following error:</span><br />
<pre style="background-color: white; line-height: 18.90625px;">Could not reserve enough space for object heap.
Could not create the Java virtual machine.</pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC-YiiJGg0KgmblwJPbTQNQHeWouSbWbgnO-B8croBQ24XEeswqON3vKxf1FaS7KFn49W1nag7UBAwt9U7iQyUcZ-72oGEsjBdFODfsZGOrxebTtgW532n6sVV2v0TO6jB5NfwrNS2Gbg/s400/Could+not+reserve+enough+space+for+object+heap.bmp" /></pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;">
<span style="font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: 13px; white-space: normal;">I resolved this by creating a new environment variable called EXTRA_JAVA_PROPERTIES with the following value "-Xms512m -Xmx512m". </span></pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT_k3XV1bolRjfPpl64zyrAMgivBl9a08k-iXyCnMXcmbPHEtrl7p-73v0FhMqTnua4ywey2Q7XY73pHx8lJS76WdEbZd0x2qD11wQO_3BIh4lMlM5OQPGly2kzc25uTglnyZH9MInkEc/s400/EXTRA_JAVA_PROPERTIES.JPG" /></pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;"><pre>Running applications with limited free memory (7343786)
Under certain circumstances, if you do not have enough free memory available, you may receive an error when running an application:
Error occurred during initialization of VM
Could not reserve enough space for object heap
Normally you would resolve this by adding -Xms and -Xmx arguments to the project's Run/Debug profile. However, there are existing entries for these settings in the WebLogic startup that will override the project's settings. The proper way to resolve this error is to add EXTRA_JAVA_PROPERTIES to your environment, as follows:
On Linux
setenv EXTRA_JAVA_PROPERTIES "-Xms512m -Xmx512m"
On Windows
set EXTRA_JAVA_PROPERTIES="-Xms512m -Xmx512m"
</pre>
<h4 style="font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: 13px; white-space: normal;">
Important update to this post!</h4>
<div style="font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: 13px; white-space: normal;">
"-Xmx512" is not sufficient to run and test an application in a SOA server, because it would be incredibly slow. If you encounter the above issue using the default config of "-Xmx1024m", then try to decrease the number until it will work. There is no hard rule, you could try "-Xmx1000m" for instance. If it still doesn't work, then try decreasing the number again.</div>
</pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
<pre style="background-color: white; line-height: 18.90625px;">
</pre>
asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-50603127307890089272013-06-27T07:52:00.003-07:002013-06-27T08:07:30.192-07:00Oracle Database 12c Linux üzerine kurulumuMerhaba bu yazımızda oracle'ın yeni tanıttıgı Database 12c kurulumu OEL linux 6.3 üzerinde yapacagız.<br />
<br />
Linux için yapılan ayarlar 11g r2 ile aynı çok bir farkı yok.<br />
<img alt="DB12c_Install_ol_1" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_1.jpg" /><br />
<br />
sd<br />
<br />
<img alt="DB12c_Install_ol_2" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_2.jpg" width="400" /><br />
asd<br />
<img alt="DB12c_Install_ol_3" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_3.jpg" width="400" /><br />
<br />
as<br />
<img alt="DB12c_Install_ol_4" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_4.jpg" width="400" /><br />
sdd<br />
<img alt="DB12c_Install_ol_5" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_5.jpg" width="400" /><br />
asd<br />
<img alt="DB12c_Install_ol_6" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_6.jpg" width="400" /><br />
sd<br />
<img alt="DB12c_Install_ol_7" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_7.jpg" width="400" /><br />
asds<br />
<img alt="DB12c_Install_ol_8" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_8.jpg" width="400" /><br />
asd<br />
<img alt="DB12c_Install_ol_9" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_9.jpg" width="400" /><br />
asd<br />
<img alt="DB12c_Install_ol_10" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_10.jpg" width="400" /><br />
asd<br />
<img alt="DB12c_Install_ol_11" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_11.jpg" width="400" /><br />
asdsa<br />
<img alt="DB12c_Install_ol_12" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_12.jpg" width="400" /><br />
asdasd<br />
<img alt="DB12c_Install_ol_13" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_13.jpg" width="400" /><br />
dsd<br />
<img alt="DB12c_Install_ol_14" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_14.jpg" width="400" /><br />
dfs<br />
<img alt="DB12c_Install_ol_15" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_15.jpg" width="400" /><br />
fdfs<br />
<img alt="DB12c_Install_ol_17" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_17.jpg" width="400" /><br />
sdfds<br />
<img alt="DB12c_Install_ol_18" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_18.jpg" width="400" /><br />
ewrewr<br />
<img alt="DB12c_Install_ol_19" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_19.jpg" width="400" /><br />
sds<br />
<img alt="DB12c_Install_ol_20" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_20.jpg" width="400" /><br />
ere<br />
<img alt="DB12c_Install_ol_21" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_21.jpg" width="400" /><br />
wqe<br />
<img alt="DB12c_Install_ol_22" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_22.jpg" width="400" /><br />
sdsa<br />
<img alt="DB12c_Install_ol_23" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_23.jpg" width="400" /><br />
asdasd<br />
<img alt="DB12c_Install_ol_24" height="270" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_24.jpg" width="400" /><br />
dbca<br />
<img alt="DB12c_Install_ol_25" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_25.jpg" width="400" /><br />
dfdsfds<br />
<img alt="DB12c_Install_ol_26" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_26.jpg" width="400" /><br />
sdfds<br />
<img alt="DB12c_Install_ol_27" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_27.jpg" width="400" /><br />
sdfdsf<br />
<img alt="DB12c_Install_ol_28" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_28.jpg" width="400" /><br />
dsfds<br />
<img alt="DB12c_Install_ol_29" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_29.jpg" width="400" /><br />
sdfdsf<br />
<img alt="DB12c_Install_ol_30" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_30.jpg" width="400" /><br />
asdsad<br />
<img alt="DB12c_Install_ol_31" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_31.jpg" width="400" /><br />
asdsad<br />
<img alt="DB12c_Install_ol_32" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_32.jpg" width="400" /><br />
asdsad<br />
<img alt="DB12c_Install_ol_33" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_33.jpg" width="400" /><br />
erew<br />
<img alt="DB12c_Install_ol_34" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_34.jpg" width="400" /><br />
werrew<br />
<img alt="DB12c_Install_ol_35" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_35.jpg" width="400" /><br />
dsfd<br />
<img alt="DB12c_Install_ol_36" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_36.jpg" width="400" /><br />
dfds<br />
<img alt="DB12c_Install_ol_37" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_37.jpg" width="400" /><br />
ewr<br />
<img alt="DB12c_Install_ol_38" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_38.jpg" width="400" /><br />
dfds<br />
<img alt="DB12c_Install_ol_39" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_39.jpg" width="400" /><br />
asds<br />
<img alt="DB12c_Install_ol_41" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_41.jpg" width="400" /><br />
asdsa<br />
<img alt="DB12c_Install_ol_42" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_42.jpg" width="400" /><br />
asd<br />
<img alt="DB12c_Install_ol_43" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_43.jpg" width="400" /><br />
fdg<br />
<img alt="DB12c_Install_ol_45" height="301" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_45.jpg" width="400" /><br />
sdfds<br />
<img alt="DB12c_Install_ol_46" height="178" src="http://www.koraykey.com/wp-content/uploads/DB12c_Install_ol_46.jpg" width="400" /><br />
sads<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnl2DZOdb3OWuXQekTeExDCqktBq3tSim7UTS0QZkg4tjkfxvldASGQdt6Z1-9spo3md3reTbtt72eB37erjWpF_QNrTlirju96zLKPCXiymT1LrIiHSMuPKDeEwRRiw87pvBTyzqUDKbN/s1237/12c.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnl2DZOdb3OWuXQekTeExDCqktBq3tSim7UTS0QZkg4tjkfxvldASGQdt6Z1-9spo3md3reTbtt72eB37erjWpF_QNrTlirju96zLKPCXiymT1LrIiHSMuPKDeEwRRiw87pvBTyzqUDKbN/s400/12c.jpeg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com0tag:blogger.com,1999:blog-7147276272464929611.post-46588464773756488942013-04-15T10:49:00.002-07:002013-04-15T10:49:49.732-07:00Ankara JUG Nisan 2013 Etkinliği<br />
<div class="post-body entry-content" id="post-body-2647902717144514415" itemprop="description articleBody" style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 1.4; position: relative; width: 570px;">
<div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: inherit;">Ankara JUG etkinliklerine devam ediyor! Bu ay etkinliğimize uzun yıllardır Java konusunda danışmanlık ve eğitim hizmeti veren <a href="http://www.devinim.com.tr/" style="color: #888888; text-decoration: initial;">Devinim Yazılım Eğitim Danışmanlık</a> şirketinde Danışman ve Eğitmen olarak çalışmakta olan <a href="http://tr.linkedin.com/pub/ertu%C4%9Frul-aslan/23/644/8ba" style="color: #888888; text-decoration: initial;">Ertuğrul Aslan</a> konuğumuz olacak.</span><br /><span style="font-family: inherit;"></span><br /><span style="font-family: inherit;">2013 Nisan toplantımız her zamanki gibi Bilkent Cyberpark Dr. Fikret Yücel Konferans Salonu'nda düzenlenecek. Ancak bu sefer elimizde olmayan nedenlerden dolayı küçük bir farklılık olacak. Etkinliklerimizi düzenlediğimiz salondaki yoğunluktan dolayı Nisan toplantımızı, normal tarihinden 1 hafta sonra, Mayıs ayı başında düzenleyeceğiz. Dolayısı ile etkinlik tarihimizi<strong>2 Mayıs 2013 - Perşembe</strong> günü saat <strong>19:00 </strong>olarak ayarladık. Etkinliğimize aşağıdaki bağlantıyı kullanarak kaydınızı yaptırabilirsiniz.</span></div>
<div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: inherit;"></span><br /></div>
<div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: inherit;"><strong>Kayıt: </strong><a href="http://ankarajugnisan2013.eventbrite.com/" style="color: #888888; text-decoration: initial;" target="_blank">Ankara JUG Nisan 2013 Etkinliği</a></span></div>
<div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: inherit;"></span><br /><span style="font-family: inherit;"><strong>Konuşmacı:</strong> <strong>Ertuğrul ASLAN</strong></span></div>
<div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: Arial, sans-serif;"><a href="http://tr.linkedin.com/pub/ertu%C4%9Frul-aslan/23/644/8ba" style="color: #888888; text-decoration: initial;">Ertuğrul Aslan</a>, 2005 yılında java ile tanışmış olup, profesyonel olarak 2007 yılından bu yana çok büyük ölçekli özellikle Finans projelerinde, projelerin tasarımından, kodlanmasına, veritabanlarının oluşturulması gibi bütün adımlarında görev almıştır. Bu projelerde Java EE 5 ve Java EE 6'nin teknolojileri olan EJB 3.1, JPA 2, Web Service ve JSF 2 kullanarak projeler geliştirmiştir. Bu projelere paralel olarak 2007 yılında Oracle veritabanı ile çalışmaya başlamış ve geliştirdiği projelerin veritabanlarının hazırlanmasından performans iyileştirme gibi bütün yönetimlerinde de görev almıştır. Farklı yazılım şirketlerinde Senior Java Developer ve Oracle DBA olarak çalışmış olan Ertuğrul Aslan, aynı zamanda 2008 yılından bu yana, Java ve Oracle eğitimleri vermektedir. Oracle Database 11g Administrator Certified Professional (OCP) sahibidir.</span><br /><span style="font-family: inherit;"></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhV9gALgIVGQ8EZlTqt5SRIzNxrX3rvhN56PkYhXf6hQU5vKeIEpjI2m9h9PeYFo-WFXXcNgL-UvZRM2zXn2gWZySgF8ILI9xNr3GjDtKkCB0R7ADN_VRSusyK1KQfDHjvtfkGJ_OnKKUo/s1600/Java-persistence.png" imageanchor="1" style="color: #888888; margin-left: 1em; margin-right: 1em; text-decoration: initial;"><img border="0" height="140" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhV9gALgIVGQ8EZlTqt5SRIzNxrX3rvhN56PkYhXf6hQU5vKeIEpjI2m9h9PeYFo-WFXXcNgL-UvZRM2zXn2gWZySgF8ILI9xNr3GjDtKkCB0R7ADN_VRSusyK1KQfDHjvtfkGJ_OnKKUo/s320/Java-persistence.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: inherit;"></span> </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0pwKL1fp_0CgJxy62At9zQhyphenhyphenN-UBfsgO-Z5SFOlla9hmvJu0q0qoQGrr_O4J-VioV0p74e7dz-lfqFsf1J37cR8Lgf8S9EzB3o7dDIKqGmo47yixcayCuu2CRYP18E6_htWj7m4v_p2E/s1600/Screen+Shot+2013-02-13+at+10_21_34+AM.png" imageanchor="1" style="color: #888888; margin-left: 1em; margin-right: 1em; text-decoration: initial;"><span style="font-family: inherit;"></span></a><br /></div>
<div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: inherit;"><strong>Etkinlik Adı: </strong>JPA 2</span><br /><br />JPA 2 başlıklı etkinlikte "JPA nedir?", "Neden JPA'ya ihtiyaç duyarız" ve "ORM nedir?" sorularına bulacağımız cevaplarla birlikte, JPA hakkinda yanlis bilinenler, Hibernate ile karsilastirilmasi, JPA providerlar, Persistence Conext ve persistence.xml, EntityManager ve komutları, Relatations, JPQL sorgu dili, JPA concurrency konularında bilgiler edinebileceksiniz. Bunlarla birlikte Java EE 7 ve JPA 2.2 ile gelecek yeni ozelliklere de değinilecektir. Örnek demo uygulamalarla, teorik olarak anlatılan konuların, uygulamada nasıl kullanılabileceğini deneyimleme şansına sahip olacaksınız.<br /> </div>
<div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: inherit;">Etkinliklerimizde katılımcılarımıza çeşitli hediyeler veriyoruz bildiğiniz gibi. Hediyelerimiz çekiliş ile verilecektir. Bu etkinliğimizin hediyeleri:</span></div>
<div dir="ltr" style="text-align: justify;" trbidi="on">
<ul style="line-height: 1.4; margin: 0.5em 0px; padding: 0px 2.5em;">
<li style="margin: 0px 0px 0.25em; padding: 0px;">Bu ay etkinliğimizin sponsorlarından <a href="http://www.devinim.com.tr/" style="color: #888888; text-decoration: initial;" target="_blank">Devinim Yazılım Eğitim Danışmanlık</a> firması tüm katılımcılara Java eğitimleri için <strong>%20 indirim</strong> hediye ediyor.</li>
<li style="margin: 0px 0px 0.25em; padding: 0px;">Ayrıca <a href="http://www.devinim.com.tr/" style="color: #ff9900;" target="_blank">Devinim Yazılım Eğitim Danışmanlık</a> firması <strong>2 şanslı katılımcımıza</strong> Java eğitimlerinde kullanılmak üzere <strong>%50 indirim</strong> hediye edecek.</li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><span style="font-family: inherit;"><strong>2 şanslı katılımcımıza</strong> <a href="http://www.bilgicozumleri.com/OracleAcademy.html" style="color: #888888; text-decoration: initial;" target="_blank"><strong>Oracle Academy</strong></a><strong> </strong>Mug'ı</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;">Etkinliklerimizin global sponsoru <a href="http://www.jetbrains.com/" style="color: #888888; text-decoration: initial;" target="_blank">JetBrains</a> tarafından katılımcı sayımıza göre ücretsiz lisans hediye edilecektir. Eğer toplam 30+ katılımcımız olursa <strong>1 adet</strong> <a href="http://www.jetbrains.com/" style="color: #888888; text-decoration: initial;" target="_blank">JetBrains</a> ürün lisansı, 50+ katılımcımız olması durumunda <strong>2 adet</strong> <a href="http://www.jetbrains.com/" style="color: #888888; text-decoration: initial;" target="_blank">JetBrains</a> ürün lisansı hediye edilecektir.</li>
<li style="margin: 0px 0px 0.25em; padding: 0px;">Etkinliklerimizin global sponsoru <a href="http://www.atlassian.com/" style="color: #888888; text-decoration: initial;">Atlassian</a> tarafından <strong>1 adet</strong> <a href="http://www.atlassian.com/software" style="color: #888888; text-decoration: initial;">Atlassian</a> ürün lisansı hediye edilecektir.</li>
<li style="margin: 0px 0px 0.25em; padding: 0px;">Etkinliklerimizin global sponsoru <a href="http://oreilly.com/" style="color: #888888; text-decoration: initial;">O'Reilly</a> tarafından <strong>1 şanslı katılımcımıza</strong> Sticker Seti ve Not Defteri hediye edilecektir.</li>
<li style="margin: 0px 0px 0.25em; padding: 0px;">Bu hediyelere ek olarak <a href="http://www.bilgicozumleri.com/OracleAcademy.html" style="color: #888888; text-decoration: initial;" target="_blank"><strong>Oracle Academy</strong></a><strong></strong>'nin sürpriz hediyeleri sizleri bekliyor olacak!</li>
</ul>
</div>
<br /><div dir="ltr" style="text-align: justify;" trbidi="on">
<span style="font-family: inherit;">Bu etkinliğimizde ayrıca sizlere küçük ikramlarımız olacak. İş veya okul çıkışı hiçbir yere uğramadan etkinliğimize gelebilirsiniz :). </span><span style="font-family: inherit;">Etkinliklerimiz sizlerle güzel ve keyifli... Hem etkinliğimize, hem de etkinlik sonrası sohbetimize bekliyoruz. Görüşmek üzere...</span></div>
</div>
asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com2tag:blogger.com,1999:blog-7147276272464929611.post-70159753968350885112013-04-05T11:33:00.001-07:002013-04-05T11:33:36.263-07:00PRVF-4007 : User equivalence check failed for user oracleRAC kurulumda, ortamlarin kuruluma hazir olup olmadigi anlamak icin, asagidaki gibi testler yapariz bu testleri yaparken yukaridaki gibi hata aliyorsaniz, asagidaki adimlari takip etmelisiniz.<br />
<br />
<br />
[oracle@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac1,RACG2 -r 11gR2 -fixup -verbose<br />
<br />
Performing pre-checks for cluster services setup<br />
<br />
Checking node reachability...<br />
<br />
Check: Node reachability from node "rac1"<br />
Destination Node Reachable?<br />
------------------------------------ ------------------------<br />
rac1 yes<br />
RACG2 yes<br />
Result: Node reachability check passed from node "rac1"<br />
<br />
Checking user equivalence...<br />
<br />
Check: User equivalence for user "oracle"<br />
Node Name Comment<br />
------------------------------------ ------------------------<br />
rac1 failed<br />
RACG2 failed<br />
Result: PRVF-4007 : User equivalence check failed for user "oracle"<br />
<br />
ERROR:<br />
User equivalence unavailable on all the specified nodes<br />
Verification cannot proceed<br />
<br />
Pre-check for cluster services setup was unsuccessful on all the nodes.<br />
<br />
-- TO AVOID<br />
<br />
PRVF-4007 : User equivalence check failed for user "oracle<br />
<br />
<br />
<br />
SETUP SSH USER EQUIVALENCE IN 11GR2<br />
<br />
In new 11GR2 ssh User equivalence can be setup as below.<br />
<br />
[oracle@rac1 grid]$ ll<br />
total 40<br />
drwxrwxrwx 9 oracle oinstall 4096 Apr 1 08:11 doc<br />
drwxrwxrwx 4 oracle oinstall 4096 Apr 1 08:11 install<br />
drwxrwxrwx 2 oracle oinstall 4096 Apr 1 08:11 response<br />
drwxrwxrwx 2 oracle oinstall 4096 Apr 1 08:11 rpm<br />
-rwxrwxrwx 1 oracle oinstall 3795 Apr 1 08:11 runcluvfy.sh<br />
-rwxrwxrwx 1 oracle oinstall 3227 Apr 1 08:11 runInstaller<br />
drwxrwxrwx 2 oracle oinstall 4096 Apr 1 09:05 sshsetup<br />
drwxrwxrwx 14 oracle oinstall 4096 Apr 1 08:11 stage<br />
-rwxrwxrwx 1 oracle oinstall 4228 Apr 1 08:11 welcome.html<br />
<br />
<br />
cd sshsetup<br />
./sshUserSetup.sh -user oracle -hosts rac1,rac2 -advanced -exverify -confirm<br />
<br />
Below is method to setup ssh Manually step-by-step.<br />
<br />
ON NODE-1<br />
<br />
rac1@:/home/oracle : $mkdir -p ~/.ssh<br />
rac1@:/home/oracle : $chmod 700 ~/.ssh<br />
rac1@:/home/oracle : $/usr/bin/ssh-keygen -t rsa<br />
Generating public/private rsa key pair.<br />
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):<br />
Enter passphrase (empty for no passphrase):<br />
Enter same passphrase again:<br />
Your identification has been saved in /home/oracle/.ssh/id_rsa.<br />
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.<br />
The key fingerprint is:<br />
4a:3b:fe:ea:03:d3:cf:6f:d3:06:fb:1a:ed:1e:b0:6b oracle@rac1.localdomain.com<br />
rac1@:/home/oracle : $/usr/bin/ssh-keygen -t dsa<br />
Generating public/private dsa key pair.<br />
Enter file in which to save the key (/home/oracle/.ssh/id_dsa):<br />
Enter passphrase (empty for no passphrase):<br />
Enter same passphrase again:<br />
Your identification has been saved in /home/oracle/.ssh/id_dsa.<br />
Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.<br />
The key fingerprint is:<br />
5e:cb:46:cc:d8:f1:01:44:3e:7a:20:eb:ce:5d:d4:15 oracle@rac1.localdomain.com<br />
<br />
ON NODE-2<br />
<br />
rac2@:/home/oracle : $mkdir -p ~/.ssh<br />
rac2@:/home/oracle : $chmod 700 ~/.ssh<br />
rac2@:/home/oracle : $/usr/bin/ssh-keygen -t rsa<br />
Generating public/private rsa key pair.<br />
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):<br />
Enter passphrase (empty for no passphrase):<br />
Enter same passphrase again:<br />
Your identification has been saved in /home/oracle/.ssh/id_rsa.<br />
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.<br />
The key fingerprint is:<br />
dc:4e:e7:c3:ee:71:84:e7:2e:72:99:3d:b0:0a:2b:f9 oracle@rac2.localdomain.com<br />
rac2@:/home/oracle : $/usr/bin/ssh-keygen -t dsa<br />
Generating public/private dsa key pair.<br />
Enter file in which to save the key (/home/oracle/.ssh/id_dsa):<br />
Enter passphrase (empty for no passphrase):<br />
Enter same passphrase again:<br />
Your identification has been saved in /home/oracle/.ssh/id_dsa.<br />
Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.<br />
The key fingerprint is:<br />
5a:49:d4:e2:b9:5d:e9:f8:f5:bb:ce:7c:4b:f4:dd:6c oracle@rac2.localdomain.com<br />
<br />
ON NODE-1<br />
<br />
rac1@:/home/oracle : $ssh rac1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys<br />
The authenticity of host 'rac1 (192.168.100.181)' can't be established.<br />
RSA key fingerprint is 27:ac:4b:9a:e3:d2:ae:6d:2b:71:99:8d:b9:c0:b1:a7.<br />
Are you sure you want to continue connecting (yes/no)? yes<br />
Warning: Permanently added 'rac1,192.168.100.181' (RSA) to the list of known hosts.<br />
oracle@rac1's password:<br />
rac1@:/home/oracle : $ssh rac1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys<br />
rac1@:/home/oracle : $scp /home/oracle/.ssh/authorized_keys oracle@rac2:~/.ssh/<br />
oracle@rac2's password:<br />
authorized_keys 100% 1030 1.0KB/s 00:00<br />
<br />
ON NODE-2<br />
<br />
rac2@:/home/oracle/.ssh : $ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys<br />
The authenticity of host 'rac2 (192.168.100.182)' can't be established.<br />
RSA key fingerprint is 27:ac:4b:9a:e3:d2:ae:6d:2b:71:99:8d:b9:c0:b1:a7.<br />
Are you sure you want to continue connecting (yes/no)? yes<br />
Warning: Permanently added 'rac2,192.168.100.182' (RSA) to the list of known hosts.<br />
oracle@rac2's password:<br />
rac2@:/home/oracle/.ssh : $ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys<br />
rac2@:/home/oracle/.ssh : $scp /home/oracle/.ssh/authorized_keys oracle@rac1:~/.ssh/<br />
The authenticity of host 'rac1 (192.168.100.181)' can't be established.<br />
RSA key fingerprint is 27:ac:4b:9a:e3:d2:ae:6d:2b:71:99:8d:b9:c0:b1:a7.<br />
Are you sure you want to continue connecting (yes/no)? yes<br />
Warning: Permanently added 'rac1,192.168.100.181' (RSA) to the list of known hosts.<br />
oracle@rac1's password:<br />
authorized_keys 100% 2060 2.0KB/s 00:00<br />
<br />
--Confirm ssh on both Nodes.<br />
<br />
rac1@:/home/oracle : $ssh rac2 date<br />
Mon Aug 6 09:20:48 EDT 2012<br />
rac1@:/home/oracle : $ssh rac1 date<br />
Mon Aug 6 09:20:43 EDT 2012<br />
<br />
rac2@:/home/oracle/.ssh : $ssh rac2 date<br />
Mon Aug 6 09:20:37 EDT 2012<br />
rac2@:/home/oracle/.ssh : $ssh rac1 date<br />
Mon Aug 6 09:20:31 EDT 2012<br />
asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com3tag:blogger.com,1999:blog-7147276272464929611.post-55257521742464143942013-04-02T08:36:00.003-07:002013-04-02T08:36:38.885-07:00INS-40922 Invalid SCAN Name - unresolved to IP address RAC kurulumda asagidaki hatayi aliyorsaniz, /etc/hosts icindeki scan name`i kontrol etmeniz gerekmektedir.<br />
<img height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpAfe50d6NYhrMK2v1soO3SwAyaixcRvjJtdqEBievSAQl4JidsYNxGmLatjI0OEbg6Rl1R94TU0iHWNJGiPPYWYXeketl8V8ZUxeJZ3QIZ5QXV-1BYf0thP8-ygQVnikjFAsfcrHDnTI/s400/123_thumb%255B1%255D.jpg" width="400" /><br />
<br />
<blockquote class="tr_bq">
$ cat /etc/hosts<br /> # SCAN<br /> 20.20.20.55 <b>scan</b>.localdomain scan</blockquote>
buradaki scan ile ayni degerde yani "scan" yazmaniz gerekmektedir<br />
<br />
asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com2tag:blogger.com,1999:blog-7147276272464929611.post-45029773217475944372013-03-23T14:10:00.003-07:002013-03-23T14:12:32.079-07:00ORA-00838: Specified value of MEMORY_TARGET is too small<span style="font-family: Courier New, Courier, monospace;">ORA-00838: Specified value of MEMORY_TARGET, evet bu hatanin sebebi memory_target degerinin parametre dosyasi icindeki degerinin ihtiyacimiz olan degerden kucuk olmasi. Bir cok sebebi olabilir, mesala sga_target degeri yuksek verilmistir ve db yeniden baslatilirken, memory_target degeri kucuk ise verir vs.</span><br />
<div>
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div>
<span style="font-family: Courier New, Courier, monospace;">cozum asagidaki adimlari yapabiliriz;</span></div>
<div>
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">SQL> startup</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1172M</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; min-height: 14px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">SQL> create pfile='/home/oracle/pfile.ora' from spfile;</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; min-height: 14px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;"><br /></span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">File created.</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; min-height: 14px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;">spfile`den pfile olusturup, icindeki memory_target degerini yeniden veriyoruz.</span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; min-height: 14px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">$ vi </span></b><b style="background-color: transparent;"><span style="font-family: 'Courier New', Courier, monospace;">'/home/oracle/pfile.ora'</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">*.memory_target=</span></b><b style="background-color: transparent;"><span style="font-family: 'Courier New', Courier, monospace;">1300234240</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;">daha sonra, pfile`den spfile olusturup veritabanimizi aciyoruz.</span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
</div>
<b style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-family: 'Courier New', Courier, monospace;">SQL> create spfile from pfile=</span></b><b style="color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-family: 'Courier New', Courier, monospace;">'/home/oracle/pfile.ora'</span></b><b style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-family: 'Courier New', Courier, monospace;">;</span></b><br />
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; min-height: 14px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;"><br /></span></b></div>
<b style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-family: 'Courier New', Courier, monospace;">File created.</span></b><br />
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; min-height: 14px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">SQL> startup</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">ORACLE instance started.</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; min-height: 14px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;"><br /></span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">Total System Global Area 534462464 bytes</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">Fixed Size 2212736 bytes</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">Variable Size 524291200 bytes</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">Database Buffers 4194304 bytes</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">Redo Buffers 3764224 bytes</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">Database mounted.</span></b></div>
<div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<b><span style="font-family: 'Courier New', Courier, monospace;">Database opened.</span></b></div>
</div>
asadsahttp://www.blogger.com/profile/09338982952451816045noreply@blogger.com5