connect access to oracle 11g

1. Error-ORA-12514: TNS: ListenerProgramThe Service requested in the connection descriptor cannot be recognized currently If your server somehow reports this error, It was always normal before , Then try the following method ( Remember to back up the file you want to modify, because the error may be different ): Open "Listener. ora", Copy the following red font to your file Sid_list_listener =(Sid_list =(Sid_desc =(Sid_name = plsextproc)(ORACLE_HOME = D: \

Tags: C #Phenomenon: In C # programs, you need to access the Oracle database in a provider=oraoledb.oracle.1 manner. But program execution times exception: "ORAOLEDB.ORACLE.1" Provider is not registered on the local computerSolve:Server Oracle is 11g, although Oracle Data Pr

For the first time, I was able to perform Oracle distributed transaction processing, and I was beaten by a storm. After two and a half days in a row, I finally completed the transaction. During this period, I encountered various problems, and I was tired of Google, at first, I was still confident that the last new error message was a bit desperate. Then I put my energy into an article so that future generations could not take a detour. During this per

Http://blog.sina.com.cn/s/blog_7c855cf70100shrv.html Oracle 11g and EM cannot be started. It may be because the IP address has changed. So I used the emca command to reconfigure Oracle em. The specific process is as follows:I: \ Documents ents and Settings \ geshaoqing> emca-config dbcontrol DB-repos recreateEmca started at 11:16:40Em configuration assistant 10.2

1. Oracle 11g R2 Installation Manual (graphics tutorial) for Windows Before installation, you need to confirm the following points: Your memory is not a problem (this is important, if your machine often blue screen then don't pretend, or you cry) Your system is activated. The computer is already installed. NETFramework 4.0, or the first step will have a pop-up box to tell you "Oui.exe has stopped workin

: Database version is 11g Operation user must have SYSDBA permission Database parameter timed_statistics must be true IO must be allowed asynchronously, but with the file system, you can set the Filesystemio_options parameter to SetAll Ensure that the data file allows asynchronous IO, which can be confirmed by the following SQL statement: COL NAME FORMAT A50 SELECT name,asynch_iofrom v$datafile f,v$iostat_file I WHERE

After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle services, you can speed up your computer. So what should we do? After Oracle

is created on the virtual column, but it is actually a function-based index), and the virtual column partition supports all partition policies and can be partitioned using scopes, lists, and hashes. 5. Divisional Advisors14. read-only table15.RAC one Node and RAC patchingThe RAC one node indicates that the Oracle RAC database is running only on an active Oracle instance and, like an

Friends who use Oracle 11G may have struggled with this problem. The data exported by the exp command may be inexplicably missing some tables, during the analysis, we will find that these tables are empty tables with no records inserted. The cause is that oracle 11g introduces a new feature. When the new table is not i

Tags: blog http ar sp for file Art logOperating system Environment: WINDOWS8.1Tools: Oracle 11g-r2 SQL DeveloperNetwork resources: http://sourceforge.net/project/showfiles.php?group_id=33291package_id=25350release_id=534076Login above address select Jtds-1.2.2-dist.zip to download, drawings:When the download is complete, open the unpacking package and find the Jtds-1.2.2.jarOpen

defined, copy the file name Tnsnames.ora, and add your own database alias configuration in the file, examples are as follows:Fsfsdb =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.70.128) (PORT = 1521))(Connect_data =(SERVER = dedicated)(service_name = fsfsdb)))Mainly modifies the first = previous alias, host is the IP address, and Service_Name is the instance name of the database server. Iv. installation and use of Plsql.If there are no surprises, you can now

Docker Image: wnameless/oracle-xe-11gcommand to start mirroring:Docker run-d-v/data/oracle_data:/data/oracle_data-p 11522:22-p 11521:1521-e oracle_allow_remote=true--name oracle-1 1g wnameless/oracle-xe-11gTo enter the mirroring command:Docker exec-it Oracle-11g/bin/bash1. E

PS: The following are the most common basic management commands for Oracle 11g, including creating users, table spaces, permission assignments, and so on. The following commands I have verified the operation, and added my summary and instructions.1. Start the Oracle database:Switch from root to Oracle user access:su -

. The service allows the database to act as a resource manager for transactions in a Microsoft Transaction Server MTS, com/com+ object, and distributed environment. (must not be started)5. Oracleoradb11g_home1clragent:oracle part of the database. Net Extension Service. (must not be started)6. Oracleoradb11g_home1tnslistener: Listener service, service is required only when the database requires remote access. (not required to start, detailed below).7.

LibrarySQL>SELECT* FROM V$NLS_PARAMETERSWHEREIN (‘NLS_CHARACTERSET‘‘NLS_NCHAR_CHARACTERSET‘);PARAMETER VALUE--------------------------------------------------------------------------------------------------------------------------------NLS_CHARACTERSET AL32UTF8NLS_NCHAR_CHARACTERSET AL16UTF16SQL>See Export Import Library Instance 1 Instance 2 has a dif

Oracle 11g database security reinforcement considerations, oracle11g In database security configuration, security reinforcement is required. To ensure database security, however, sometimes, after improper operations or database business account password modification, the configuration of database connection for the program is encapsulated in jar, if the configuration information of the connected database in

= "American_america" in the. Bash_profile in the/home/oracle and/root user directories. UTF8 "statement to close the current SSH window. Drop tablespace ts_data including contents and datafiles; Create tablespace ts_data logging datafile ' D:\tablespace\TS_DATA.dbf ' size 50m autoextend on next 50m maxsize 20480 m extent management local; Drop user User1 cascade; Create user user1 identified by 123456 default Tablespace ts_data; Grant

information, this feature can package information related to an event. And you can also send packaged information to the Oracle support team. 6, based on the characteristics of the patch (Feature Based patching) This feature makes it easy to distinguish between the features in a patch package that you are using and that you have to play. Enterprise Manager (EM) enables you to subscribe to a feature-based patch service, so Enterprise Manager can aut

Oracle 11g R2 installation manual (Graphic tutorial) For Windows 7 flagship EditionBy GLC 2010/5/12 XiDian University http://hi.baidu.com/glc4001. Download Oracle 11g R2 for Windows, as shown belowOfficial Website:Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zipHttp://download.oracle.com

Label:How to start OracleOne of the services in Windows system Services is called: "Oracleservice[sid]" SID is your instance name when you install Oracle XE, and if you do not change the default is "XE", Oracleservicexe and Oraclexetnslistener automatically start by default, find the "Oracleservicexe" this service, start it OK.Navicat for Oracle connection settings Log in using Sqlplus (password set yourse