Elvinshikhalizada.com Website Review

Monitor the Logfile The Listener’s logfile may contain TNS-01169, TNS-01189, TNS-01190, or TNS-12508 errors, which may signify attacks or inappropriate activity. Using a simple shell script or management tools, monitor the logfile and generate an alert whenever these 2016 in October Oracle released the Oracle Database Security As*essment Tool (DBSAT) to an*lyzes database configurations and security policies to improve the security in your environment.   Benefits Quickly identify security configuration errors in the database environment Launch Security best practices Increase the security level of your Oracle Databases Reduce the attack and exposure Hugepages and Large Pages If you run an Oracle Database on a Linux Server with more than 16 GB physical memory and your System Global Area (SGA) is greater than 8 GB, you should configure HugePages. Oracle promises more performance by doing this. A HugePages There is no easy way than “Active Duplication” on case oracle database clone. During “Active Duplication” you don’t need to copy some files from source DB to a destination. For example: Pfile, Create PWD file, Control files and etc. Migration SOURCE DATABASE   NOTE: First you have to check the character sets on each DB. Because with different character sets you can’t transport the tablespace from one DB to another. If character sets are different you have to change character set one of this DB and do it Yesterday my friend asks me: When creating a function, I get this error: ORA-00000: normal, successful completion Then I want to restart database with command “shu immediate” and “startup” I got this error again I wanted to restart LSNRCTL Listener didn’t During the operation transportable tablespaces with DATAPUMP your source database “character set” must be same with destination database. Otherwise you will encounter an error like below: “ORA-39123: Data Pump transportable tablespace job aborted” “ORA-29345: cannot plug a tablespace into a database using an incompatible character set” Because the database character sets are