1. Confirm versionOwn operating system version (32-bit or 64-bit), Oracle Instant Client (Oracle clients version) and PLSQL versionMy own version is: Oracle Client version 64-bit, Plsql 64-bit.2. Install the Oracle
FALSENLS_NCHAR_CHARACTERSET AL16UTF16NLS_RDBMS_VERSION 10.2.0.4.020 rows selected.Confirm that the character set selected when the database was created is a UTF-8. Execute SQL: select userenv ('language ') from dual; get oracle Server character set XSQL> select userenv ('language') from dual;USERENV ('language ')----------------------------------------------------SIMPLIFIED CHINESE_CHINA.UTF82. Check the settings of NLS_LANG on the
write in front:Oracle is typical of C/S structure, the server provides instances of Oracle services, mainly for database management, object management and storage, dataStorage, query, database resources monitoring, listening and other services. The client is just a tool that interacts with the server, such as Sqlplus, in SqlplusExecutes SQL statements to the server, the server performs the operations in SQL
The client cannot connect to oracle normally, and the listening status is "Not All Endpoints Registered" solution 1. symptom Description: The application response is Not normal.
[grid@sdcmpdb1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-JUL-2013 16:39:49Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTIO
In Linux, the total number of Oracle clients is less than 40 MB, which is very convenient and quick to install.
1. First, check the directory structure after downloading:
Copy it to linux.
2. Use the root user in the command line window to operate in the rpm directory:
Rpm-ivh... rpm
Rpm-ivh... rpm
Rpm-ivh... rpm
Rpm-ivh... rpm
(Install the four RPMs separately. Install the basic one first, and install the other three in any order)
3. Modify the tans
Enable PHP OCI8 extension on LinuxTo add an Oracle connection to Linux, You need to recompile PHP.1. Download and install Apache
Cd apache_1.3.31
./Configure -- prefix =/usr/local/apache \
-- Enable-module = so \
-- Enable-shared = max \
-- Enable-module = most
Make
Make install
-- Enable-module = so module is used to provide the apachehe core module supported by DSO.
-- Enable-shared = all the standard modules except so of max are compiled in
Oracle 11 Client installation file:
Download the following files from www.oracle.com:
Oracle-instantclient-sqlplus-11.1.0.1-1.i386.rpm
Oracle-instantclient-basic-11.1.0.1-1.i386.rpm
1> install the oracle 11 client in Linux
#
1. Download the Oracle Clienta) : http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, click Connect to enter the following page appears. Select the first instant Client for Microsoft Windows (32-bit) to download it, please do not download 64bit, I tried, can not implement the connection.b) directly extracted to your installed dir
Client|oracle
Install Oracle Client on Solaris
To install Oracle client on Solaris 5.8, please follow this steps:
1. Create a user account on Solaris, just like:oracle9i.
2. Log on Solaris with the account.
3. Download T
PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. In 64-bit Windows
PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. In 64-bit Windows
1. Problems
PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. On 64-bit Windows, in most cases, the 64-bit Oracle client
Oracle can remotely connect to pl SQL remotely without installing a client.
Oracle can be remotely connected using PLSQL without installing a client Every time I ask people whether PLSQL can connect to the server remotely, they say they want to install the client.
connecting to Oracle often requires the installation of hundreds of megabytes of Oracle clients, which can be cumbersome. This first describes how to connect to an Oracle database with Plsql by using a thin client that does not require installation. In fact, these operations are very simple, written here, it is a knowl
Introduction to oracle Pro * C
Install the Oracle client
Install sqlpus
Install Pro * C
Oracle's Pro * C has been very popular. Although it is not highly respected, it is still used in mature projects, so it makes sense to build your own pro * C compiling environment. If you search for the Pro * C compiling environment in Windows, you may still fin
The full uninstall mode for Oracle 11g servers and clients has changed with the previous versions:1. Preparations before uninstallation: Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.Ii. Batch unload: Run the deinstall. bat batch file of H: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ deinstall to uninstall the file. The full code is as follows:(When the
The full uninstall mode for Oracle 11g servers and clients has changed with the previous versions:
1. Preparations before uninstallation: Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.
Ii. Batch unload: Run the deinstall. bat batch file of H: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ deinstall to uninstall the file. The full code is as follows:(When the
You can use the HOSTNAME method when the network structure is relatively simple and ORACLE servers are relatively small. However, this method has several restrictions: 1. the TCPIP protocol must be used. 2,
You can use the HOSTNAME method when the network structure is relatively simple and ORACLE servers are relatively small. However, this method has several restrictions: 1. the TCP/IP protocol must be used
Remote connection to Oracle is troublesome. It usually takes the oracle client to be installed. You can use instantclient to easily connect to a remote Oracle database.
1. Create a Directory D: \ Oracle_Cleint to store related files. Create a Directory D: \ Oracle_Cleint \ NETWORK \ ADMIN to store tnsnames files.2. D
Label:1, first download PL/SQL, installation, cracking; Here to provide a self-made plsql11 version of the Green Chinese cracked version: Http://down.51cto.com/data/2075386 http://download.csdn.net/detail/abc2536465230/8939917 The two are the same. 2, download the Oracle INSTANCT client base version of the file; Website Link: http://www.oracle.com/technetwork/database/features/instant-
Oracle RAC Load Balancing enables client-initiated connections to be efficiently allocated to instances with smaller listener loads. There are two ways to achieve client load balancing, one is by configuring the client's load_balance, one by configuring the server-side Remote_listener parameters. Both approaches have advantages and disadvantages, and they are not
Welcome to the Oracle community forum, and interact with 2 million technical staff to enter a previous project without installation. I have made a program to configure the list of files backed up by the ora file, obtain the Directory 2004-07-1513: 17DIR released by the F: ORA81 client from the server. 2004-07-1513: 17DIR .. 2004-07-1513: 17 DIRBI
Welcome to the Oracle
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.