SAP BASIS,HANA AND ORACLE DBA BLOGS

How to configure multiple Oracle listeners It happened to me few times during the stress tests that Oracle listener became a bottleneck and not be able to handle the required workload. It was resolved by creating  multiple  listeners which appeared to be a quick solution.  Here is a short step-by-step procedure to configure multiple Oracle listeners  on Solaris for standalone Oracle 9i and 10g environment. 1)  First of all, add additional NIC and cables. They can be on separate subnetwork or the same. In the later, make sure to set static route if needed.    2) Assume that we are going to configure two listeners,   LISTENER and LISTENER2 Modify listener.ora and tnsnames.ora as following: Here is a sample of   listener.ora  LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.3)(PORT = 1521))     ) ...

Oracle Database - Why you have still a lot of redo and archive ? The Index side effect 1 - About You use the direct path insert and set the logging mode as NOLOGGING but you have still a lot of redo log generated. Why ? The answer is that you have an index on the table, and the index cannot just be appended to, they just be merged into. Since you need to merge data into them, you need redo in order to recover from instance failure. If your system crashed in the middle of the index operations, you would end up with a corrupt index structure. Hence, redo is generated for the index operations. 2 - Articles Related Oracle Database - How can we load a large number of rows into an indexed existing table ? Oracle Database - Redo Log (Log Files) Oracle Database - Redo Size statistics 3 - Indexes are expensive complex data structure Oracle Database - Indexes are complex data structure, so maintaining them can be expensive. gerardnico@orcl> SELECT log_mode FROM v$database; ...

RECOVERY MODEL ON SQL-SERVER Overview One of the first things that needs to be set in order to create the correct backups is to set the proper recovery model for each database.  The recovery model basically tells SQL Server what data to keep in the transaction log file and for how long.  Based on the recovery model that is selected, this will also determine what types of backups you can perform and also what types of database restores can be performed. Explanation The three types of recovery models that you can choose from are: Full Simple Bulk-Logged Each database can have only one recovery model, but each of your databases can use a different recovery model, so depending on the processing and the backup needs you can select the appropriate recovery model per database.  The only exception to this is the TempDB database which has to use the "Simple" recovery model. Also, the database recovery model can be changed at any time, but this will impact your b...

I make backup script for database in which 12c is installed in it as when i wrote script i show me EXPDP – ORA-39006,ORA-39213 Metadata processing is not available for which i do following things : While Taking full database export using “EXPDP” i was getting below mentioned error : ############################################### bash-3.2$ expdp directory=datapump dumpfile=expdp_hrs92dmo.dmp logfile=expdp_hrs92dmo.log full=y Export: Release 11.2.0.2.0 – Production on Thu Feb 27 10:48:09 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username : sys@hrs92dmo as sysdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available ############################################### I tried it...

hello guys i am facing issue as i have 2 database in 12C machine server and i need to change character set which is shutdown database by shutdown or by shut immediate. But when i write startup or startup restrict it will provide me error  *ora-00119 local_listener and oracle local_listener ora-00132* Now for this resolution i do the following step 0 down vote C :\ Users \ Hp > sqlplus SYSTEM as SYSDBA SQL * Plus : Release 11.2.0.1.0 Production on Wed Aug 3 12 : 28 : 32 2016 Copyright ( c ) 1982 , 2010 , Oracle . All rights reserved . Enter password : Connected to an idle instance . SQL > startup ORA-00119 : invalid specification for system parameter LOCAL_LISTENER ORA-00132 : syntax error or unresolved network name 'LISTENER_ORCL' SQL > create pfile from spfile ; File created . ************************** Now open the PFILE ( INIT % ORACLE_SID %. ORA ) from % ORACLE_HOME %\ d...

Install Oracle 12.1.0.1 Error in invoking target ‘links proc gen_pcscfg procob’ of makefile …ins_precomp.mk If you are installing 12.1.0.1 there are some problems. Oracle 12c (12.1.0.2) installs cleanly. During the linking phase, you will see the following error. Error in invoking target 'links proc gen_pcscfg procob' of makefile '/u01/app/oracle/product/12.1.0.2/db_1/precomp/lib/ ins_precomp.mk '. See '/u01/app/oraInventory/logs/installActions2014-04-26_08-07-04PM.log' for details. To fix it, do the following: rm -rf $ORACLE_HOME/lib/stubs/* cp $ORACLE_HOME/rdbms/lib/ env_rdbms.mk $ORACLE_HOME/rdbms/lib/ env_rdbms.mk.orig Perform the following modifications to the “$ORACLE_HOME/rdbms/lib/ env_rdbms.mk ” file. # Line 176 # FROM: LINKTTLIBS=$(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS) # TO : LINKTTLIBS=$(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS) -lons # Line 279-280 # FROM: LINK=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS) $(COMPSOBJS) LINK...

#Resolved ORA-12541: TNS no listener error N no. of articles you will find on the internet about  “ORA-12541 TNS no listener error”  but still finding an effective solution. Don’t worry this solution helped me a lot and I hope it will help you too. I got the same issue while working on Oracle 12c database then I decided to share my experience and steps to resolve this issue. solution : guys just check your ip please 1)firstly check that ip and hostname are ping correctly. 2)reload lsnrctl file also by lsnrctl reload and lsnrctl status. 3)now make sure instance is connected and running by command select name,open_mode from v$database; 4)now check tnsnames by tnsping (dbname) if it show OK then it works. if still issue continue please make new files by NETCA dont use "SQLNET.AUTHENTICATION_SERVICES = (NONE)" this is for authentication purpose only as it ask for password when connect with sql. thanks Anand gupta DONT FORGET TO COMMENT !!