After ORACLE is installed in LINUX, you cannot log on to iSQL * Plus as a DBA -- Linux general technology-Linux technology and application information. For more information, see the following. After ORACLE is installed in LINUX, you cannot log on to
After sybase 12.5.4 is installed on RedHat as 4 and Initialization is complete, run isql-Usa-P to report the error:
The context allocation routine failed when it tried to load localization files !!One or more following problems may caused the failure
Your sybase home directory is/opt/sybase-12.5. Check the environment variable SYBASE if it is not the one you want!Using locale name "zh_CN.UTF-8" defined in environment variable LANGLocale name "zh_CN.
You cannot use Db-library (such as ISQL) or ODBC 3.7 or earlier to ntext data
Warning:mssql_query () [Function.mssql-query]: message: You cannot ntext data or use Unicode collations with db-library (such as ISQL) or ODBC 3.7 or earlier The Unicode data is sent to the client. (severity) in D:phpnowhtdocss includedb_mssql.class.php on line 55
The code is as follows
Copy Code
Warn
provide interfaces for client connection. In the console window, enter the following command:
1. Start the listener.
Note: Not in SQL, but in bsh.
XX-laptop :~ $ Lsnrctl
The following listener information appears:
LSNRCTL for Linux: Version 10.2.0.1.0-Production on 09-AUG-2010 15:37:47
Copyright (c) 1991,200 5, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Lists the startup and configuration information
Isql*plus Introduction
Isql*plus is a new feature offered from Oracle 9i and is a sql*plus Web form (Oracle 11g is not supported). is based on a three-tier structure. Its client, middle, and server can be located on the same machine or on a different machine. Isqlplus does not need to be installed separately, through Isqlplus, users can use Sql*plus for data manipulation and database management without the
ISQL * Plus pageISQL * Plus is a product independent of Enterprise Manager. the iSQL * Plus user interface runs in a web browser connected to the Internet or your intranet. iSQL * Plus enables you to use a web browser to connect to an Oracle database and perform the same actions as you wocould through the command line version of SQL * Plus (known as SQL * Plus in
Content: 1,You are using a Windows Account to log on to the ms SQL Server on your PC. Please use iSQL-eAssume that ntuser1 of the Windows Account needs to log on to the ms SQL Server.1. log in to Windows2000 Professional with the NT account ntuser1, not the ms SQL Server.2. iSQL-S server-eIi. SQL Server account:
1. Set authentication to SQL Server and windows.
2. iSQL
@ Echo offEcho the following commands will set up the database for doccomposer.
Set/P pdbname = Please enter database name to be created: (Note: I do not know how to pass this parameter into createdb. SQL and doccomposerdatabase. in the SQL script, this parameter is invalid, and the parameter in the script is dead .)Set/P phost = enter the host name (MACHINE) for database:Set/P ppass = enter the password for "sa" User:
Echo if the database does not exist, it will be created, otherwise, the d
%/productname/j2ee/isqlplus/application-deployments/isqlplus/config ($ ORACLE_HOME for linux or unix)
However, the password in the configuration file is encrypted, so we cannot manually modify the file, but configure it through Java AuthoriZatioN. JAZN is a JASS (Java Authentication and Authorization Service) tool provided by oracle. jdk is required or the built-in jdk of oracle can be used, under % ORACLE_HOME/jdk.
You need to configure java_home an
After the Oracle 10g Database is installed, the web page is installed by default to manage the Oracle access path, including:
Em: http: // localhost: 1158/em
Isql * plus: http: // localhost: 5560/isqlplus and http: // localhost: 5560/isqlplus/dba
Two isqlplus websites are available, because common users and dba users log in.
To log on to isqlplus as a DBA, you must configure the Solaris User first. You can use either of the following authentication me
Ms SQL has a simple, convenient and efficient management interface, what is the use of iSQL? What is an iSQL tool? ISQL is a database tool for interactive execution of transact-SQL statements and scripts.
Microsoft Osql is a similar tool. For example, do some advanced configuration, or execute database operations on the client or remotely.
Work
ISQL *plus Page
Isql*plus is a product independent of Enterprise Manager. The Isql*plus user interface runs in a Web browser connected to the Internet or your intranet. Isql*plus enables a Web browser to connect to a Oracle database and perform the same actions as for you would thro Ugh the command line version of Sql*
For example, to do some advanced configuration, as well as in the client or remote database operations, such as work, isql is very convenient. Like invading a host with SQL services, what can you do when you invade SQL Server? The best tool is the isql.
Not only is Microsoft's SQL support isql, but Sybase's enterprise version of the database also supports Sybase
For example, ISQL is very convenient when you perform advanced configurations, such as running database operations on a client or remotely. For example, what can I do if I intrude into a host with SQL services? ISQL is the best tool.Not only does Microsoft SQL support ISQL, but also supports Sybase Enterprise databases. Sybase's Unix and
Generally, you can log on to the ISQLPLUS website http: // ip: Port/isqlplus. after entering the website, you can directly log on to the Database User Logon page and use the common users in the database to log on. The DBA user logs on to the isqlpus website http: // ip: Port/isqlplus/DBA. after entering the website, a login box is displayed, you must first enter the iSQL * Plus DBA user and password. Note that this is not a database user, but the us
Phpmssql cannot use DB-Library (for example, ISQL) or ODBC3.7 or earlier versions. DB-Library (for example, ISQL) or ODBC3.7 or an earlier version sends ntext data or Unicode data that only uses Unicode sorting rules to the client.
Php mssql cannot use DB-Library (such as ISQL) or ODBC 3.7 or earlier versions cannot use DB-Library (such as
Label:Connect the Sybase ASE database using isqlThe Sybase ASE Client tool has a more useful command-line tool, isql. With isql, you can perform almost any administrative maintenance work on the ASE database server. Use the isql tool to connect to the RUSKYPC database server below. The client uses character set cp936 to log on. Use the login user name SA. c:\user
The isql*plus structure is as follows: The configuration process is as follows:
1 Configuration httpd
$ cd $ORACLE_HOME/Apache/Apache/conf $ vi httpd.conf 1.1 设定Server name或者Server IP地址和端口,使用非root用户启动HTTPD进程,其端口必须大于1024, 如: Listen=hpserv01:7777 1.2 设定DocumentRoot, 如DocumentRoot="/home/htdocs" 1.3 如果你也使用web server作为document content server,那么需要配置: IndexOptions NameWidth=* IndexOptions FoldersFirst AddIcon /icons/text.gif .txt .log 1.4 检查oracle_apa
Use sqlcmd, osql, and iSQL backup and restoration of sqlserver
-- Sqlcmd, new sql2005 Tool1. Backup"C:/program files/Microsoft SQL Server/90/tools/binn/sqlcmd. EXE "-S. /sqlexpress-U sa-P 000000-D master-Q "backup database test to disk = 'C:/AA/AAA. bak '"
The database 'test' and the file 'test' (located on file 2) processed page 176.The database is 'test', and the file 'test _ log' (located on file 2) processes one page.The backup database successful
In order to facilitate development at home, I specially designed an old database to bring it back for testing. To maximize performance and save disk space, when installing SQL Server 2000 + SP4, we chose "minimal installation ".
After the installation is complete, all the graphical tools are not installed because they are minimized, including the Enterprise Manager and query analyzer.
In order to build the environment, I had to sacrifice the killer. Use the command line tool
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.