Method for accessing the sdo_geometry field in Oracle Spatial (in Windows)
Reference URL:
Http://iihero.iteye.com/blog/995152
Blog type: OracleOraclewindowssql. netjdbc1. With OCI or occi, you can refer to the C ++ implementation in the oraclehome \ MD \ demo \ examples directory after installing oracle,This method is the most efficient, but the implementation i
Ora-27100:shared Memory realm already exists error resolution
Database ora-27100:shared memory realm already exists error resolution
Environment:
Operating system platform Windows Service 2003 R2 x86
Database version Oracle Enterprise 9.2.0.1 for Windows x86
Today, a customer database is not open, reported ora-27100:shared memory realm already exists error.
Windows Oracle ODBC installation and configuration
Environment: Windows 7, 32-bit OS1. Download the driver package
The official Oracle website can be downloaded.Base package: instantclient-basic-win32-10.2.0.4.zipOdbc package: instantclient-odbc-win32-10.2.0.4.zip
The ver
Implementation objective: To avoid data loss or errors, a scheduled backup of database data
How to Implement: Oracle Export +windows Task complete
Learning methods: The Prophet, then know the reason why
Implementation process:
1. Create file Backup.bat (custom filename. bat)
@echo off
REM ###########################################################
REM # Windows
" network listener, which can is useful if you are Up Third-party proxy servers.
On Windows NT 4.0 Service Pack3 or earlier, enabling this option precludes bringing the network listener up or down in a C ASE where a database connection spawned by the network listener is active. Therefore, may
Need to shut down all of the databases serviced by a network, listener you can before down and bring a restart list Ener. This results to the way shared socket
It is very easy for PHP to connect to oracle8 in Linux/Unix, but it is not easy in windows. after a long time of exploration, I found a reliable method and did not dare to enjoy it exclusively,We will announce it to everyone.Development Environment used by the author:Windows 98 Second EditionPhp4.04pl1Apache 1.3.14 windowsOracle 8.05 ClientPHP is successfully installed in CGI Mode. Test with the following code
$ Conn = OCILogon ("cinmsiii", "cinmsii
Oracle|window| Error | resolution
Invited to install a oracle9i database on Windows today
I didn't want to run into some problems.
1. Install Oracle9201 Software
2. After installing Oracle9205 Patchset
3. DBCA CREATE DATABASE, encountered ORA-12638 error during creation, failed to retrieve voucher, failed to create database
4. Because I saved the creation script, I decided to execute it with a script t
@echo off Echo ================================================ Echo automatic backup script for Oracle database in Windows echo 1. Use the current date to name the backup file. Echo 2. Automatically delete backups up to 30 days ago. echo ================================================:: Remove the current time in "YYYYMMDD" format. Set Backupdate=%date:~0,4%%date:~5,2%%date:~8,2%set Curtime=%time:~0,2%rem
Automatic backup script for Oracle databases in Windows
@ Echo off echo ============================================ ================= echo in Windows environment, the Oracle database's automatic backup script echo 1. use the current date to name the backup file. Echo 2. automatically delete the backup 30 days ago. Ech
processing statement is actually very simple, that is, to make seven DMP files into a 7-length queue, and then delete the queue header each time the database is backed up, that is, the last oracle7.dmp file to be backed up. At this time, oralce6.dmp becomes the queue Header element, named oralce6.dmp oracle7.dmp, and so on. Rename oracle. dmp to oracle2.dmp, and then use the exp command to export the datab
Oracle|window How do I manually uninstall Oracle completely under Windows 2000?
System environment: 1, operating system: Windows Server, machine memory 256M
2, Database: Oracle920for NT Enterprise Edition
3, Installation path: D:\ORACLE
Uninstall Step:
1. Start-> Setup-> Con
@ Echo off
Rem ####################################### ####################Rem # Windows Server 2003 Oracle Database automatic backup batch processing scriptRem ####################################### ####################
Rem obtains the current system time. The value may vary depending on the operating system.Set curdate = % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8, 2%Set curtime = % time :~ 0, 2%
If the
4. Create oracle username tablespaces, tables, insert data, and user management tables in windows and Linux
Log on to the super administrator and run the following command:
Create databases, tablespaces, users, and insert data in Windows
-- 01 create a tablespace-- Note that the tablespace path is adjusted according to the actual instal
the Chkconfig function. That is, add '/sbin/' before chkconfig.7) Restart Linuxserverlocal Xbrowser remote session creation1) Open Xbrowser, select XDMCP, and create a new XDMCP session on the right side:2) in the new session:Session: Name, self-input. to defaultMethod: Use the default XDMCP QueryHost: IP for LinuxPort number: 177, is also the above operation XDMCP PortLocal address: Default Auto SelectAddress Type: OWN initiativeWhen you are finishe
two files will make an error, and dragging them to the CMD command will perform normally. This is because the filename of the batch file cannot be the same as the command word, the above IMP and exp are the names of the commands, so they cannot be used to make the file name of the bat file.3. Using Windows Task SchedulerIn Control Panel, open the Scheduled Tasks program, and then click Configure as Scheduled Tasks.Note: If a
as applications and business services.(6) Set the account password:Here are the default choices:(7) Add an example scenario:For the convenience of learning, the sample scheme is selected, which includes the tablespace of the example.(8) Select initialization parameters:
The key here is the setting of the character set, strongly recommended: The character set is best and the client is consistent! Otherwise it is easy to appear garbled.
(
Label:Original: http://blog.csdn.net/kimsoft/article/details/8751267 Operating system: Windows 7 64-bit flagship requirements, install PL/SQL developer for development First, download the official Oracle Lite Green Edition Http://www.oracle.com/technetwork/topics/winsoft-085727.html Special note To download the 32-bit, because PL/SQL developer currently has only
1. Automatically generate Oracle backup files based on date@echo offEcho is backing up the Oracle database, please wait a moment ...Exp userid= ' username/password @sid ' file=d:\bak\res_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=d:\bak\res_%date:~0,4%%date:~ 5,2%%date:~8,2%.log Owner=resThe echo task is complete!2. Automatically generate Oracle backup files based
Pre-preparation work:Back up all the old Oracle files, delete the old directories, and then reinstall Oracle, the directory is the same as the old directory (if not, there are more places to modify).Install Oracle only, do not create DATABASE, if you have already created a database,Remove the ==>oracle-oradb10g_home1==
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.