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
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
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:
If soctt.sql is not ava ...
Posted on Sat, 09 Nov 2019 13:26:45 -0800 by inerte
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
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
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
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
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 184.108.40.206.0 Production on Mon Apr 17 11:09:59 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 6 ...
Posted on Thu, 14 Feb 2019 14:33:18 -0800 by Eclectic
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
Installation of oracle Database
Detection and Completion of RPM Packets Required
You can use ...
Posted on Tue, 18 Dec 2018 23:45:04 -0800 by habib009pk