Oracle 11 Client installation and PLSQL and TOAD Chinese garbled solutions 1. Download the "Instant Client Package" software from Oracle, which provides a better solution for Oracle Client greening. Is: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html Downloadable packages: Download package: instantclient-basic-win32-11.2.0.1.0.zip (Latest Version) 2. decompress the package to the installation directory, for example, D: \ Program Files \, and create a two-tier
, the Shared Server is irrelevant to the database, but only to the instance. By dynamically registering an instance, listeners are automatically configured for the shared server.
The shared server requires two required parameters: dispatchers and shared_servers.
The dispatchers parameter controls the number of scheduling processes started in the instance and the behavior of these processes (protocol type, etc.). The max_dispatchers parameter specifies the maximum number of scheduling processes t
recommend scanning around 50 IP addresses for php timeout
'FTP','22'=>'SSH','23'=>'Telnet','25'=>'SMTP','79'=>'Finger','80'=>'HTTP','81'=>'HTTP/Proxy','110'=>'POP3','135'=>'MS Netbios','139'=>'MS Netbios','143'=>'IMAP','162'=>'SNMP','389'=>'LDAP','443'=>'HTTPS','445'=>'MS SMB','873'=>'rsync','1080'=>'Proxy/HTTP Server','1433'=>'MS SQL Server','2433'=>'MS SQL Server Hidden','1521'=>'Oracle DB Server','1522'=>'Oracle DB Server','3128'=>'Squid Cache
, under D: \ Program Files \, create a folder named D: \ Program Files \ instantclient_11_2 \ under D: \ Program Files \ instantclient_11_2 \ and create a folder named tnsnames in admin. ora file,
The input format is as follows:
OWEN_192.168.2.35 = 192.168.2.35: 1522/owen
Here, 1522 is the listening port of oracle. If you are not sure what the listening port of your oracle is, you 'd better use
Let's take a
error:connection Reset by Peer (104) Rsync Error:error in Rsync protocol Data stream (code) at IO.C (759) [sender=3.0.6]Cause: Source server-side permission is set read to only read-only permission.Workaround: Read Only = False4, Error:auth failed on module Teeerror:auth failed on module tee rsync error:error starting client-server protocol (COD E 5) at MAIN.C (1522) [receiver=3.0.6]Cause: The server side of the module (tee) needs to verify the user
) )(Sid_desc =(global_dbname = Tai)(oracle_home =/u01/app/oracle/product/11.2.0/dbhome_1)(sid_name = orcl3939) ) )Here'sthe value of the Global_dbname (Jing,tai) is the service name provided to the client, which is the value of the client service_name:the service "Jing" consists of 1 instances. The instance "orcl3939", State UNKNOWN, contains 1 handlers for this service ...the service "Tai" consists of 1 instances. The instance "orcl3939", State UNKNOWN, contains 1 handlers for this service ..
netca to configure listeners and tnsnames. ora.[Oracle @ linux1 ~] $ Export DISPLAY = 192.168.7.20.: 0.0[Oracle @ linux1 ~] $ Netca
-- Author: Robinson Cheng-- Blog:
--> The following is the result of netca configuration, including listener. ora and tnsnames. ora.[Oracle @ linux1 ~] $ More $ ORACLE_HOME/network/admin/listener. ora# Listener. ora Network Configuration File:/u01/app/oracle/db_1/network/admin/listener. ora# Generated by Oracle configuration tools.
ADR_BASE_LISTENER_CNBO =/u01/app/
. Total System Global Area 2505338880 bytes Fixed Size 2255832 bytes Variable Size 620758056 bytes Database Buffers 1862270976 bytes Redo Buffers 20054016 bytes Database mounted. SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Solution:To solve this problem, the simplest solution is to open the database and perform the recover operation. After the operation is complet
When installing oracle on Linux, I accidentally installed the listener twice. The port number of the listener is changed to 1522 instead of the default 1521. The client has not been connected for a long time, finally, we found that the port number of listener is incorrect. To change the listener port number, follow these steps:
1. Stop listener and run the LSNRCTL Stop command.
2. After the listener is stopped, go to your $ ORACLE_HOME/Network/a
open_modefrom v $ database;
Open_mode
--------------------
Read Only with apply
Test:
-- Master database:
SQL> SElect max (sequence #) from V $ archived_log;
Max (sequence #)
--------------
23
SQL> alter system switch logfile;System altered.SQL> SElect max (sequence #) from V $ archived_log;Max (sequence #)--------------24
-- Query the status of DG:
SQL> select max (sequence #) from V $ archived_log;Max (sequence #)--------------24
SQL> Col error for A10
SQL> Col dest_name for A20
SQL> select
database is set to the shared mode, but the service configured by the parameter dispatchers = '(Protocol = TCP) (Service = orcl)' is different from the SERVICE_NAME specified in the local TNS, here, service = orcl indicates that when you connect to the database through the orcl service, dispatch to a shared server process.
If you configure a corresponding TNS, you can connect to the database in shared mode.
Orcls =(Description =(Address_list =(Address = (Protocol = TCP) (host = PC-6753184) (Por
(DBUTIL.JAVA:20)At CHAP6. Statementdemo.main (statementdemo.java:15)
Solution One
Then the firewall opened 3 ports, 8080, 8009, 8005, the problem is done
Solution II
Oracle's thin connection is divided into two types, one is the SID, the other is service name, and the difference is how the server configures the SID or service name, and after you configure the database, you can
The code is as follows
Copy Code
D:oracleproduct10.2.0db_1networkadmin
Direc
-accessibleWorkaround: This is because the Rsyncd.pwd rsyncd.sec permissions are not correct and should be set to 600. For example: chmod rsyncd.pwd, Windows should change the owner of the password file to the user who is running the program. ERROR 7: @ERROR: Invalid UID nobody. Rsync Error:error starting Client-server Protocol (code 5) at MAIN.C (1506) [receiver=3.0.7]Workaround: Add the following two lines to the rsyncd.conf fileUID = 0GID = 0 Question 8: @ERROR: Chroot failedRsync Error:error
. View the status of the current listenerC:/Documents and Settings/skate_db>lsnrctl statusLsnrctl for 32-bit windows:version 10.2.0.1.0-production on 1 September-July-2008 12:11:19Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))The STATUS of LISTENER------------------------Alias LISTENERVersion Tnslsnr for 32-bit windows:version 10.2.0.1.0-produCtionStart date 1 September-July-2008 11:47:59Uptime 0 days 0 hours 23 minutes
Preparation: Install the ASP Server (IIS or PWS) + ACCESS (which comes with Windows ). To avoid any problems, we recommend that you follow the steps described in the course. Now, the preparation is complete. Next we will introduce in detail the steps: What should a message board have? Including: Visitor Name and visitor Homepage)
Preparation: Install the ASP Server (IIS or PWS) + ACCESS (which comes with Wi
The online bookstore is free to download. Address: www. jiebaoit. comonlinebook1. this online bookstore is a system developed based on ASP. To use this software properly, you must ensure that your computer meets the following requirements: (1) operating environment: WINDOWSNTWIN2000WINXPWITHIIS4.0 or later WIN9X + PWS (2) Database: Access2000, Acce
Free online bookstore download, address: www.jiebaoit.com/onlinebook 1. this online bookstore is a syst
uses the SQL database, it will not only get some important information, but also increase the Administrator (2005 of the hedgehog ).
The following is an introduction to the source code in "ant cinema 3.0" to log out of a user (wantlogin. asp:
If request ("userid1") Set rst = server. createobject ("adodb. recordset ")
SQL = "select money, online from users where userid =" request ("userid1") "and password =" md5 (request ("pws "))""
Rst. open SQL,
Here is the vector layer loading method, because the layer itself is already produced by the Mxd class project file, so directly using the Mxd loading modeIf(Axmapcontrol1.checkmxfile (Shpfile))//determine if an mxd file{IArray pArry; PArry=axmapcontrol1.readmxmaps (Shpfile, Type.Missing); IMap PMap; for(inti =0; i ) {PMap= Parry.get_element (i) asIMap; if(Pmap.name = ="Layers") {Axmapcontrol1.mousepointer=Esricontrolsmousepointer.esripointerhourglass; Axmapcontrol1.loadmxfile (S
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.