Eclipse failed to connect to Oracle Database: ORA-12505, error code:
Org. springframework. jdbc. CannotGetJdbcConnectionException: cocould not get JDBC connection; nested exception is java. SQL. SQLException: Listener refused the connection with the following error:
ORA-12505, TNS: listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
128.64.96.33: 1522: CLPM0701
Java. SQL. SQLExc
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 that can be started.
The shared_servers parameter controls the number of shared server processes started in the instance. The max_shared_servers parameter specifies the maximum number of processes that can be started on the Shared Server. The default value is 1/8 of the processers parameter value.
$ Grep-A 5 A
Http://wanwentao.blog.51cto.com/2406488/456195
Oracle 11 Client installation and PLSQL and toad Chinese garbled characters
1. Download from Oracle officialThe "Instant Client package" software provides a better solution for greening the Oracle client.
For: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
Downloadable packages include:
Download package:
Instantclient-basic-win32-11.2.0.1.0.zip (Latest Version)
2. decompress the package to the installation dir
file, because pmon needs to read relevant information from tnsnames. ora when dynamically registering a listener.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = DaveDai) (PORT = 1522 ))
)
Run the following command with sys:
SQL> alter system set local_listener = listener;
SQL> alter system register;
Or:
SQL> alter system set LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP) (HOST = DaveDai) (PORT = 152
I recently studied Oracle 10g. Let's start with the installation. During the installation, the default port 1521 has beenProgramAfter oracle is installed, the port is changed to 1522.
So I changed the port to 1521 again. At that time, I could restart it, and the port also changed from 1522 to 1521. However, not long ago, the Nagios Monitoring Alarm showed that port 1521 was disabled ~~~~ (>_An error is re
Cmd: How to import and export oracle remote and local databases. cmd: How to import and export oracle
Cmd Import and Export oracle Database
Open the cmd window and enter the following command
Supplement: I deleted my oracle database a few days ago and found that the import and export commands of exp and imp are unavailable. It seems that if you have not installed the oracle database locally, these two commands should be unavailable. I am not sure about the problem. If I find it, it will be upda
correct, the remote rsync server's account password file must have a permission of 600.
Error 6:password file must not is other-accessible
Workaround: 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.
/rsync_db.pwd
Error 5: @ERROR: Auth failed on module Data_backup rsync error:error starting Client-server Protocol (code 5) at MAIN.C (1506) [receiver=3.0.7]
Resolve: Password error, enter the correct password can be. If both the username and password are correct, the remote rsync server's account password file must have a permission of 600.
Error 6:password file must not is other-accessible
Workaround: This is because the Rsyncd.pwd rsyncd.sec permissions are not correct and should be s
SCN in the control file SCN for data file header SCN in a data block SCN in the log file header Transaction SCN In-memory SCN The SCN in a control file 1.1 Database SCN Database SCN represents the SCN for the most recent full-volume checkpoint operation Sql> select checkpoint_change# from V$database; checkpoint_change#------------------1744125 Dump control File Syntax Alter session SET Events ' immediate trace name Controlf level n '; 1 File header information 2 level 1+ Database information + c
.oracle.domain) (port=1522)))(Description= (address= (protocol=tcp) (Host=ocm1.oracle.domain) (port=1600)))Services Summary ...Service "POD" has 1 instance (s).Instance "POD", status ready, have 1 handler (s) for the This service ...Service "Pod1″has 1 instance (s).Instance "POD", status UNKNOWN, have 1 handler (s) for the This service ...Service "PODS" has 1 instance (s).Instance "POD", status ready, have 2 handler (s) for the This service ...Service
RHEL7 after installation, the SSH service is turned on by default for remote configuration, but the default port 22 is not safe, the default port is generally not recommended, then modify the SSH default port. Modifications on the sshd_config inside are similar to those in the 7.0, but be aware of the changes to the SELinux RHEL7.0.To modify a step:1. Check if SSH package is installed # Rpm-qa|grep SSH2. Check if the service is open # Systemctl status Sshd.service3. Check the process running sta
file. Note that this is the Tnsnames.ora file because Pmon reads the information from the Tnsnames.ora when it is dynamically registering for listening.
LISTENER =
(DESCRIPTION = (Address
= (PROTOCOL = TCP) (HOST = Davedai) (PORT = 1522))
Then run with the SYS user:
Sql> alter system set Local_listener=listener;
Sql> alter system register;
Or:
Sql> alter system set local_listener= ' (address = (PROTOCOL = TCP) (
listens, otherwise Pmon cannot dynamically register listener, if needs to not the default listens for registration, You need to configure the Local_listener parameter!
Adds the listening information to the Tnsnames.ora file because Pmon reads the relevant information from the Tnsnames.ora when it is dynamically registering for listening.
LISTENER =
(DESCRIPTION =
(address = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1522))
)
Then modify the Lo
and password are correct, the permissions for the remote rsync server's account password file must be 600.
Error 6:password file must not being other-accessible
Workaround: This is because the permissions of the Rsyncd.pwd rsyncd.sec are not correct and should be set to 600. For example: chmod rsyncd.pwd, the owner of the password file should be changed to the user running the program under Windows.
ERROR 7: @ERROR: Invalid UID nobody. Rsync Error:error starting Client-server Protocol (code
Tags: des style blog color io os ar for SPC:\windows\system32>emctl start dbconsoleoc4j Configuration issue. D:\app\product\11.1. 0\db_1/oc4j/java EE/ not found.View monitoring status, environment variablesC:\windows\system32>Echo%Oracle_home%D:\app\product\11.1.0\db_1c:\windows\system32>Echo%Oracle_sid%Orclc:\windows\system32>Lsnrctl Statuslsnrctl for --bitWindows:version11.1.0.7.0 -Production on the-OCT- the -: the: theCopyright (c)1991, -, Oracle. Allrights reserved. Connecting to(DESCRIPT
Tags: PNG SQL development IMG Color name plsql DDR list iceOne: Resource download get path:Two: Configuration method1: The prerequisite is to install the Plsql development tools.The specific installation steps are slightly2: Configure the simplified version of the Client tool.Specific format: You can modify the writing using the following reference.orcl_1521 = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.242.146) (PO RT = 1521))) (Connect_data = (service_name = ORCL
The software obtains: The foreign http://www.php.net, the domestic http://www.111cn.net, the http://phpuser.com and so on obtains the compression package to decompress after the C:PHP4 directory.Copy Php4ts.dll,msvcrt.dll to C:windowssystemRename php.ini-dist to php.ini copy to C:windowsEditing this file is simple, just change a few options.Extension_dir = C:PHP4Extension =php_ldap.dllExtension =php_zlib.dllExtension =php_calendar.dllExtension =php_exif.dllExtension =php_ftp.dllExtension =php_ms
:
Windows 95/98 stand-alone platform: PWS (Personal Web Server) 4.0, Windows NT
4.0/5.0 Server platform: IIS (Internet Information Server) Service Pack 3 and above version)
NT Workstation 4.0 Workstation platform: PWS (Personal Web Server) NT
Workstation version and the latest version of IE browser.
Second, for the production of ASP software
Windows FrontPage 98/2000, Dreamweaver 3.0, if you don't have the
than CGI, Because CGI is a thread used for every request. This greatly consumes the resources of the server.
If you don't want to write the program yourself, you can run it in IIS!?! You can do it now! With VB5 (now VB6, of course), you'll be able to create dynamic linked libraries (DLL files) that can run directly on IIS (if an ASP file is requested).
Requirements for systems and software
You need a 32-bit operating system to run the ASP. Of course you also have to install IIS or
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.