朋友帮忙:新安装的9i,登陆oracle management server总是提示"无法连接...

freeboy2 2004-10-20 04:47:13

朋友帮忙:新安装的9i,登陆oracle management server总是提示"无法连接到Management Server db.请验证您已输入OMS的正确主机名和状态."
可是我输入的没有错,是不是服务没有打开,安装完9I,是不是还要打开服务才能用

...全文

123 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

scorpio2 2004-12-02

打赏
举报

armyyd 2004-10-21

打赏
举报

managerserver要自己启动服务，并且要先配好档案文件。

guess1975 2004-10-20

打赏
举报

不用打开
ORACLE自己打开
NET 配置没有？
如果配置了你可以测试一下是否通过（用SYSTEM/MANAGER）

Oracle9i Database Error Messages Release 2 (9.2) Contents Title and Copyright Information Send Us Your Comments Preface Audience Organization Related Documentation Conventions Documentation Accessibility Part I Introduction 1 Using Messages Locating Message Documentation Oracle Database Server Product Specific Operating System-Specific Accuracy of Messages Message Format Recognizing Variable Text in Messages Message Stacks Contacting Oracle Support Services Oracle Exception Messages Trace Files The Alert File Part II Oracle Database Server Messages 2 ORA-00000 to ORA-00899 3 ORA-00900 to ORA-01499 4 ORA-01500 to ORA-02099 5 ORA-02100 to ORA-04099 6 ORA-04100 to ORA-07499 7 ORA-07500 to ORA-09857 8 ORA-09858 to ORA-12299 9 ORA-12300 to ORA-12399 10 ORA-12400 to ORA-12699 11 ORA-12700 to ORA-19399 12 ORA-19400 to ORA-24279 13 ORA-24280 to ORA-29249 14 ORA-29250 to ORA-32799 15 ORA-32800 to ORA-32999 16 ORA-33000 to ORA-65535 Part III Oracle Database Server Utilities Messages 17 Export Messages (EXP) 18 Import Messages (IMP) 19 SQL*Loader Messages (SQL*Loader) 20 External Tables Messages (KUP) 21 DBVERIFY Messages (DBV) 22 DBNEWID Messages (NID) 23 Parameter Messages (LCD) 24 Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) 25 Recovery Manager Messages (RMAN) Part IV Core Library Messages 26 Parameter Messages (LRM) 27 BFILE-Related Messages (LFI) Part V PL/SQL Messages 28 PL/SQL and FIPS Messages (PLS) Part VI Oracle OLAP Catalog Metadata Messages 29 Oracle OLAP Catalog Metadata Messages (AMD) Part VII Network Messages 30 Oracle Net Messages (TNS) 31 Oracle Names Client Messages (NNC) 32 Oracle Names Server Messages (NNO) 33 Oracle Names Control Utility Messages (NNL) 34 Oracle Names Server Network Presentation Layer Messages (NPL) 35 External Naming Messages (NNF) 36 Simple Network Management Protocol Messages (NMP) 37 Remote Operation Messages (NCR) 38 Network Security Messages (NZE) Part VIII Precompiler Messages 39 SQL*Module Messages (MOD) 40 Object Type Translator Type File Messages (O2F) 41 Object Type Translator Initialization Messages (O2I) 42 Object Type Translator Unparser Messages (O2U) 43 Pro*COBOL Messages (PCB) 44 PCF FIPS Messages (PCF) 45 Pro*C/C++ Messages (PCC) 46 SQL Runtime Messages (SQL) Part IX interMedia Messages 47 interMedia Audio Messages (AUD) 48 interMedia Image Messages (IMG) 49 interMedia Video Messages (VID) Part X Oracle Text Messages 50 Oracle Text Messages (DRG) Part XI XML Messages 51 XML Parser Messages (LPX) 52 XML Schema Processor Messages (LSX) Part XII Oracle Trace Messages 53 Oracle Trace Collection Services Messages (EPC) Index

authors: Marlene Theriault William Heney Publisher: O'Reilly First Edition October 1998 （目录） Security in an oracle System Chapter 1 Oracle and Security What’s It All About? The Oracle Security Model Procedures, Policies, and Plans If I Had a Hammer... Chapter 2 Oracle System Files What’s in the Files? The Instance and the Database: Starting an Oracle Database Types of Database Files Chapter 3 Oracle Database Objects The User Interface: User Versus Schema Objects Tables Table Triggers Views Stored Programs Synonyms Privileges Roles Profiles Chapter 4 The Oracle Data Dictionary Creating and Maintaining the Data Dictionary The Data Dictionary Views About SQL.BSQ Views Used for Security The Composition of the Views Chapter 5 Oracle Default Roles and User Accounts About the Defaults The CONNECT Role The RESOURCE Role The DBA Role The SYSDBA and SYSOPER Roles Using the Default Roles Default User Accounts Segmenting Authority in the Database Chapter 6 Profiles, Passwords, and Synonyms Profiles Passwords Synonyms Implementing Security Chapter 7 Developing a Database Security Plan About the Security Policy and Security Plan Types of Accounts Standards for Accounts Standards for Usernames Standards for Passwords Standards for Roles Standards for Views Standards for the Oracle Security Server Standards for Employees Sample Security Plan Index Sample Security Plan Checklist Chapter 8 Installing and Starting Oracle Segmenting Application Processing Installing Oracle Securely Connecting to the Database Without a Password Installing and Configuring SQL*Net Setting Up Initialization Parameters for Security Chapter 9 Developing a Simple Security Application The Application Overview Preparing the Role-Object Matrix Views Roles Grants Application Control of Access Chapter 10 Developing an Audit Plan Why Audit? Where to Audit How Auditing Works Auditing and Performance Default Auditing Types of Auditing Purging Audit Information Chapter 11 Developing a Sample Audit Application About the Audit Trail Application About Performance and Storage Using the Audit Data in Reports SQL Scripts to Generate Scripts Chapter 12 Backing Up and Recovering the Database What Are the Backup Options? What’s New for Oracle8? What Are the Recovery Options? Chapter 13 Using the Oracle Enterprise Manager What Is the OEM? The DBA Toolkit and Security OEM and the Job Scheduler OEM and the Event Management System Chapter 14 Maintaining User Accounts Application Design Requirements Running the Application Documenting the User State A Sample Script Enhanced Oracle Security Chapter 15 Using the Oracle Security Server About Cryptography Ways to Authenticate Users What’s in the OSS? Configuring and Using the OSS Chapter 16 Using the Internet and the Web Web Basics Evaluating Web Assets and Risks Protecting a Web Site Getting Users Involved Chapter 17 Using Extra-Cost Options Trusted Oracle Advanced Networking Option Oracle Application Server Appendix References Oracle Books Security Books Oracle Electronic References Security Electronic References （英文版）

在Oracle 9i中可以方便的把数据导出为文件，或者从文件导入。通过Oracle的管理服务器（Oracle Management Server，OMS）可以方便的实现，整个操作过程中有很多地方需要解释说明，但是完整的指导资料不多。本文将为大家介绍如何利用Oracle管理服务器将数据导入导出的方法。

目录 1 前言 7 1.1 编写目的 7 1.2 预期读者 8 2 数据库部署模式及选择建议 8 2.1 数据库部署模式 8 2.2 单机模式 8 2.3 HA热备模式 9 2.4 RAC模式 10 2.5 DATAGUARD模式 11 2.6 RAC+DATAGUARD模式 11 2.7 部署模式的选择建议 12 2.8 RAC部署模式应用建议 12 2.9 操作系统参数建议 13 2.9.1 AIX 13 2.9.2 HP 15 3 数据库设计考虑的因素 15 3.1 数据库类型特点分析 15 3.1.1 OLTP（联机事务处理） 15 3.1.2 OLAP（联机分析处理） 15 3.1.3 BATCH（批处理系统） 16 3.1.4 DSS（决策支持系统） 16 3.1.5 Hybrid（混合类型系统） 16 3.2 数据库规模 17 4 数据库部署前提建议 17 4.1 根据数据中心发布的推荐版本选择数据库产品 17 4.2 磁盘阵列布局原则 17 4.3 内存分配原则 19 5 数据库物理结构设计 19 5.1 软件安装路径及环境变量 19 5.2 数据库实例的命名规则 20 5.3 表空间设计 20 5.3.1 业务数据量的估算 20 5.3.2 表空间的使用规则 21 5.3.2.1 表空间的类型 21 5.3.2.2 表空间及其文件的命名规则 23 5.3.3 表空间的参数设置原则 25 5.3.3.1 数据表空间设置 25 5.3.3.2 临时表空间的存储参数（Oracle9i/10g） 26 5.3.3.3 Undo/temp表空间的估算 26 5.4 其他文件设计 26 5.4.1 参数文件 27 5.4.1.1 参数文件命名规则 27 5.4.2 控制文件 27 5.4.2.1 控制文件命名规则 28 5.4.3 重做日志文件 28 5.4.3.1 日志文件命名规则 29 5.4.4 Vote Disk 文件(RAC) 29 5.4.4.1 Vote Disk文件命名规则 30 5.4.5 OCR Disk文件(RAC) 30 5.4.5.1 OCR文件命名规则 30 5.5 初始化安装逻辑卷总计 30 6 数据库配置 31 6.1 数据库字符集配置 31 6.2 10g数据库参数设置 32 6.2.1 必须修改的初始化参数 32 6.2.1.1 DB_CACHE_SIZE 32 6.2.1.2 SHARED_POOL_SIZE 33 6.2.1.3 LARGE_POOL_SIZE 34 6.2.1.4 SGA_MAX_SIZE 34 6.2.1.5 DB_BLOCK_SIZE 34 6.2.1.6 SP_FILE 35 6.2.1.7 PGA_AGGREGATE_TARGET 35 6.2.1.8 PROCESSES 36 6.2.1.9 OPEN_CURSORS 36 6.2.1.10 MAX_DUMP_FILE_SIZE 36 6.2.1.11 PARALLEL_MAX_SERVER 36 6.2.1.12 PARALLEL_EXECUTION_MESSAGE_SIZE 37 6.2.1.13 FAST_START_MTTR_TARGET 37 6.2.1.14 INSTANCE_GROUPS（RAC） 37 6.2.1.15 PARALLEL_INSTANCE_GROUP（RAC） 38 6.2.1.16 与DRM有关的隐藏参数（RAC） 38 6.2.1.17 SESSION_CACHED_CURSORS 39 6.2.1.18 BACKUP_TAPE_IO_SLAVES 39 6.2.1.19 LOG_ARCHIVE_DEST_1 39 6.2.2 不得修改的初始化参数 40 6.2.2.1 COMPATIBLE 40 6.2.2.2 CURSOR_SHARING 40 6.2.2.3 SGA_TARGET 40 6.2.3 建议不修改的初始化参数 41 6.2.3.1 UNDO_RETENTION 41 6.2.3.2 SESSIONS 41 6.2.3.3 TRANSACTIONS 42 6.2.3.4 DB_KEEP_CACHE_SIZE 42 6.2.3.5 LOCK_SGA 43 6.2.3.6 DB_FILES 43 6.2.3.7 DB_FILE_MULTIBLOCK_READ_COUNT 43 6.2.3.8 LOG_BUFFER 44 6.2.4 与并行操作有关的参数 44 6.2.5 Data Guard有关的参数 45 6.2.5.1 DB_UNIQUE_NAME 45 6.2.5.2 LOG_ARCHIVE_CONFIG 45 6.2.5.3 LOG_ARCHIVE_DEST_1 45 6.2.5.4 LOG_ARCHIVE_DEST_2 46 6.2.5.5 LOG_ARCHIVE_DEST_STATE_1 46 6.2.5.6 LOG_ARCHIVE_DEST_STATE_2 46 6.2.5.7 REMOTE_LOGIN_PASSWORDFILE 46 6.2.5.8 LOG_ARCHIVE_MAX_PROCESSES 46 6.2.5.9 FAL_SERVER 47 6.2.5.10 FAL_CLIENT 47 6.2.5.11 STANDBY_FILE_MANAGEMENT 47 6.2.5.12 LOG_FILE_NAME_CONVERT 47 6.2.5.13 DB_FILE_NAME_CONVERT 48 6.3 9i数据库参数的区别 48 6.3.1 需要单独设置的参数 48 6.3.1.1 CLUSTER_INTERCONNECTS 48 6.3.2 和10g设置要求不同的参数 49 6.3.2.1 LOG_BUFFER 49 6.3.2.2 DB_FILE_MULTIBLOCK_READ_COUNT 49 6.3.2.3 UNDO_RETENTION 49 6.3.3 9i中不存在的参数 49 6.4 数据库连接服务 50 6.4.1 专用服务器连接 50 6.4.2 共享服务器连接 50 6.4.3 连接服务建议 51 6.4.3.1 专用服务器连接 51 6.5 数据库安全建议 51 6.5.1 采用满足需求的最小安装 51 6.5.2 安装时的安全 52 6.5.2.1 删除或修改默认的用户名和密码 52 6.5.2.2 必须使用dbca创建数据库 53 6.5.3 用户及权限管理 53 6.6 ORACLE NETWORK 配置 53 6.6.1 监听器的使用配置原则 53 6.6.2 TNSNAMES的使用配置原则 54 6.6.3 RAC环境下TNSNAMES的配置 54 6.6.3.1 各节点启用负载均衡 54 6.6.3.2 各节点不启用负载均衡 55 6.7 其他设置 56 6.7.1 Sqlplus连接设置 56 6.7.2 AWR报告默认文件名设置 56 7 不推荐使用的10g新功能 57 7.1 ASM 57 7.2 FLASH BACK数据库 57 8 附件 57 8.1 Oracle参数说明 57 8.2 合规性检查 58

作者：Steven Feuerstein, Bill Pribyl 出版日期：October 1, 2009 出版社：O'Reilly 页数：1226 ISBN：ISBN-10: 0596514468 ISBN-13: 978-0596514464 文件格式：PDF 文件大小：15.06 MB Review If you’re doing database application development in the Oracle environment, you’re going to have to know PL/SQL, the company’s extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you’ll need to know the language well. That’s where the third edition of Oracle PL/SQL Programming comes into play. It’s an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer’s toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There’s also more information about server internals–the way PL/SQL programs are run–than before, better enabling readers to optimize their code for fast and safe execution. Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle’s different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It’s a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. –David Wall Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There’s also coverage of calls to external Java and C programs. –This text refers to the Paperback edition. Product Description This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle’s powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. This indispensable reference for both novices and experienced Oracle programmers will help you: Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects Build modular PL/SQL applications using procedures, functions, triggers, and packages

基础和管理

17,377

社区成员

95,128

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章