oracle how non-normal start to do?

2010-04-15  来源:本站原创  分类:Database  人气:161 

1. To sysdba logged in the database, sqlplus sys / gtm as sysdba;
2. Properly close the database shutdown normal;
3. Start the instance of the startup nomount;
4. Modify the start alter database open;

相关文章
  • Oracle completely uninstall 2010-02-07

    1. Stop all Oracle services 2. Run Oracle Universal INstaller uninstall Oracle 3. In operation through the regedit command to modify the registry, delete the Oracle-related information 1) Oracle software has a key - value HKEY_LOCAL_MACHINE \ SOFTWAR

  • oracle startup and shutdown 2010-03-17

    1. Start the oracle server. startup [nomount | mount | open] [force] [pfile = filename] Parameters: nomount: only start the instance mount: start the instance, and load the database open: start instance, mount and open the database. force: example of

  • Google DNS block Oracle 2010-04-14

    All along, I always use Google's DNS: 8.8.8.8 Comparison with cool, but has been unable to visit www.oracle.com I thought Oracle was lost harmony. So can not access, but today you can actually find a colleague to access Oracle without Agents thin Vie

  • Notes on installing Oracle 10g Ubuntu9.10 2011-05-12

    Ubuntu is a recent fire, but Ubuntu is a very stable system. When the company asked me to install Oracle 10g on Ubuntu, I suddenly blindsided. Internet search a lot of information, are mixed. On the one hand, ubuntu's version of the update faster, th

  • under windows 2003, oracle failed login. turned out to be a domain user problems 2010-10-21

    IT departments who came to me that there was a windows 2003 under oracle get up. I used to look, start all the oracle services are normal. But sqlplus "/ as sysdba" is unable to enter the oracle of the free course, or that do not have permission

  • Oracle connection pool error Cannot create PoolableConnectionFactory (Io exception: The Network Adapter c 2011-01-25

    Turn: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection) Recent ORACLE database for the project, create a connection pool when there Cannot create PoolableConnectionFactory (Io exception: Th

  • Oracle listener configuration and access to full resolution mode (original) 2011-02-27

    Oracle network configuration three configuration files listener.ora, sqlnet.ora, tnsnames.ora, are placed in $ ORACLE_HOME \ network \ admin directory. 1. Sqlnet.ora----- effect similar to linux or other unix's nsswitch.conf file through this file to

  • oracle network configuration 2011-04-12

    oracle network configuration three configuration files listener.ora, sqlnet.ora, tnsnames.ora, are placed in $ ORACLE_HOME \ network \ admin directory. 1. Sqlnet.ora----- effect similar to linux or other unix's nsswitch.conf file through this file to

  • Start the Oracle method 2011-07-07

    Start the Oracle way under normal circumstances, Oracle Service does not start automatically as the system starts, the operating system to be started manually after restarting Oracle, as follows: telnet root su - oracle $ Lsnrctl start $ Sqlplus / no

  • Read this feel there are many things to learn .. (zz) 2010-07-03

    Recently busy to learn J2EE, looking at struts / hibernate / spring / ajax so much stuff, do not know where to start, then search the Internet search, think that this is not bad, they turn up. The first phase (java based phase) 1.java syntax 2. OO 3.

  • About Oracle10.2.0 start the process leading to disruption of two monitor problem 2010-09-01

    Environment: AIX6.1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi Tomat 5.0.28 Problem description: Service is running about a week later, Oracle can not connect, the website, business system interrupt service. tomcat no problem, b

  • On the automatic activation of the two monitoring processes Oracle10.2.0 cause service outages 2010-09-01

    Environment: AIX6.1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi Tomat 5.0.28 Problem description: Service is running about a week later, Oracle can not connect, the website, business system interrupt service. tomcat no problem, b

  • Ubuntu10.4 related settings (ssh oracle10g installation) 2011-03-12

    Ubuntu10.4 related to the installation settings and oracle10g: Ubuntu installed on the server start SSH Server sudo apt-get install openssh-server The test is successful: ssh localhost Installing SSH-server: sudo apt-get update or sudo apt-get instal

  • Three configuration files listener.ora. Sqlnet.ora. Tnsnames.ora 2011-07-25

    1. Sqlnet.ora----- effect similar to linux or other unix's nsswitch.conf file through this file to determine how to find a connection in the connection string there. For example, we enter a client sqlplus sys / oracle @ orcl If my sqlnet.ora looks li

  • normal.sysdba.sysoper understand the difference between landing oracle (reproduced) 2011-06-25

    the difference between sys and system users [system] login as normal user can only use em. [Sys] user has "SYSDBA" or "SYSOPER" privileges, log em can only use these two identities, can not be normal. "SYSOPER" permissions, t

  • Oracle dba user can log in with, but not normal login permissions! 2011-06-15

    Today, the project encountered a problem, I create a new user, then assign him connect, dba, resource permissions, then the user Ob10 in the normal privileges can log in, then I pl / sql in The lack of prompt access to normal user name or password is

  • (R) Oracle's online redefinition (the normal table to partition table ora9i above) 2011-07-28

    1, create table SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, TIME DATE); 2, insert the data SQL> INSERT INTO T SELECT ROWNUM, CREATED FROM DBA_OBJECTS; SQL> COMMIT; 3, online table redefinition of self-validation, to see whether the table can be r

  • Java problems in Chinese mysql, oracle, servlet, jsp 2009-10-06

    [url] http://blog.csdn.net/arielxp/archive/2004/06/23/23874.aspx [/ url] Java problems in Chinese mysql, oracle, servlet, jsp Copyright: CSDN is Blog hosting service provider. In this paper, such as copyright issues involved, CSDN not bear the releva

  • About Oracle SOA 11g in the application of experience DatabaseAdapter 2010-03-29

    In the oracle soa 10g is built into the official ORACLE server, so no additional configuration to use databaseAdapter Can be a normal database connections, ORACLE, after the acquisition of BEA in SOA 11g integrates weblogic, replacing his original Th

  • Oracle RAC basic daily maintenance commands 2010-03-29

    The status of all instances and services in $ Srvctl status database-d orcl Instance orcl1 is running on node linux1 Instance orcl2 is running on node linux2 A single instance of the state of $ Srvctl status instance-d orcl-i orcl2 Instance orcl2 is