Solve the ORA-12505 problem of Oracle 11g

   Today, when using SQL Developer, it can't connect, and an ORA-12505 error is reported, but SQLPLUS can connect. Check the service name. If it is OracleServiceORCL, the SID should be orcl, but it still cannot be connected with the SID. The solution is as follows: 1. Open the directory of the database instance ...

Posted on Thu, 02 Apr 2020 17:32:44 -0700 by shezz

The logical backup tool of Oracle Database - expdp data pump

Oracle database can export and import data through the data pump expdp tool. Before introducing the use of the tool, let's first say that when the newly created table after Oracle11g does not insert data, it will not allocate segment, that is to say, it will not allocate space, and when using expdp to e ...

Posted on Tue, 25 Feb 2020 20:57:56 -0800 by zxiny_chin

There is no scott account in PLsql/Oracle database, how to create and unlock it

Of course, first of all, install Oracle 11g Then there should be sqlplus, which should be matched with Oracle11g Enter the main topic, if oracle/plsql does not have a scott account, how to create First find soctt.sql in the Oracle installation directory What I am doing is: E:\app\91959\product\11.2.0\dbhome_1\admin If soctt.sql is not ava ...

Posted on Sat, 09 Nov 2019 13:26:45 -0800 by inerte

Oracle database backup and restore Notes

There are three ways of Oracle backup and restore. They are export/import, hot backup and cold backup. Export/import is a logical backup, while hot and cold backups are physical backups. [References( https://blog.csdn.net/happylee6688/article/details/13620937]) Only the way the export/import backups and restores are recorded here. In the actual ...

Posted on Sat, 12 Oct 2019 02:48:38 -0700 by warmwind

Interpretation of Oracle Connection Configuration

After installing ORACLE database software, dbca needs to configure listener to connect to database after installing database. Here are some concepts that are difficult to understand and record some of the conclusions of the analysis. Start with the connection end. 1. How to connect database oracle's connection string consists of several parts. ...

Posted on Mon, 16 Sep 2019 01:17:52 -0700 by rslnerd

Initial level Oracle 12C database migration to Oracle 18C and some basic data query methods

The good news is that the assessment project has been completed independently, but it has exceeded the scheduled date. I don't know what the final evaluation will be. My heart is still a little cold! However, in the future, I will not simply take the needs of the company as my own needs to develop, but will follow the trend to learn useful know ...

Posted on Mon, 29 Jul 2019 04:50:28 -0700 by gilbertwang

ORA-01017 Errors and Some Typical Cases

Summary Basic Ideas for Resolving ORA-01017 Errors Documents and information that need to be viewed in general Case 1 Error 11g Case Sensitive due to password enhancement to ORA-01017 Case 2: ORA-01017 caused by case 2 password file password file Case 3: ORA-01017 error 121122 Password Version Exclusively due to password enhancement Case 4 ...

Posted on Tue, 25 Jun 2019 14:55:00 -0700 by sandeepjayan

ORA-00600 [kcratr_nab_less_than_odr] [4194] Error Resolution

Business Scenario: The company's cable was broken, and the sudden power outage caused by the downtime.  [oracle@slave1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 17 11:09:59 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 6 ...

Posted on Thu, 14 Feb 2019 14:33:18 -0800 by Eclectic

2017-11-21 DBA diary, oracle asm ha configuration full record

Case Description In order to achieve high availability of ORACLE DATABASE, but there is not enough budget to purchase ORACLE RAC components, we have to use HA architecture. In the past, we usually used HA software based on operating system layer + ORACLE + file system (based on operating system layer, such as ext4,jfs2 to store data). This ...

Posted on Fri, 11 Jan 2019 16:33:11 -0800 by tycragg

Preparations for installation of Oracle 11gR2 under suse linux 11sp1 and basic settings for completion of installation

Installation of oracle Database Detection and Completion of RPM Packets Required binutils-2.19,gcc-4.3,gcc-c++-4.3,glibc-2.9,glibc-devel-2.9,ksh-93t,libstdc++33-3.3.3,libstdc++43-4.3.3_20081022,libstdc++43-devel-4.3.3_20081022,libaio-0.3.104,libaio-devel-0.3.104,libgcc43-4.3.3_20081022,libstdc++-devel-4.3,make-3.81,sysstat-8.1.5 You can use ...

Posted on Tue, 18 Dec 2018 23:45:04 -0800 by habib009pk