Install 805 on stand-alone machine, OracleTNSListener80 cannot start
question:
I installed ORACLE805 under win2000, and I have a network card, but I don’t have any connection to the network.
answer:
1.805 must be connected to the network, set up Microsoft loopback or use 816. Just set the Listener's listening address to 127.0.0.1 and try it.
2. Delete the configuration (PROTOCOL=ipc and snmp). I installed 804 on win98.
The configuration is as follows:
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.1.4)
(Port = 1521)
)
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
#Abouted (ADDRESS =
# (PROTOCOL = SPX)
# (Service = y_lsnr)
# )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = y)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
It runs normally.
ORA-12516 TNS: Listener cannot find available handles for matching information stack error
First open this file, (located in //OraHome1/network/admin/) and confirm that (INSTANCE_NAME=) and the instance name (execution item) in the file match
ORA-12154 TNS cannot resolve service name
Use Oracle's network configuration assistant "net configuration assistant" to delete all network configurations (mainly the configuration of the listener program and the configuration of the local network service name), and then reconfigure. You can use the following command to check whether your database server has started (it appears as startup in "Services" in the *** system, but your database does not necessarily start. Enter at the MS-Dos prompt:
C:\svrmgrl
SVRMGR:>connect to internal
Password: <Enter your password, if you don't know, try ORACLE>
If the connection is successful, execute help to view the command.
SVRMGR>startup
If your database is prompted to be started, execute "stop" to stop the database, and then execute "startup" to start.
Unable to start the instance service
Check whether the OracleServiceTest service is started if it is started, and if it is not started, it will start. If the path cannot be found at startup, check the registry HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleServiceTest key and set ImagePath>D:\Oracle\Ora92\BIN\ test (your installation directory, the parameters are your service name) Both of the above may be caused by running the registry software, such as Optimizer. My personal solution is to skip HKEY_LOCAL_MACHINE when scanning the registry.
On the Windows platform, after installing Oracle, the following services are generated
OracleMTSRecoveryService
OracleOraHome92Agent
OracleOraHome92HTTPServer
OracleOraHome92TNSListener
OracleServiceTest—The above is configured to automatically start by default
OracleOraHome92ClientCache
OracleOraHome92PagingServer
OracleOraHome92SNMPPeerEncapsulator
OracleOraHome92SNMPPeerMasterAgent
Set up automatic start of database
This can be achieved by modifying the registry:
hkey_local_machine->software->microsoft->windows->currentversion->run->add a key value Oraclestart->its value is:c:\Oracle\ora81\bin\ -startup -sid Database alias -usepwd Oracle -starttype inst
'OracleOracleAgent' cannot be started when starting the ORACLE service
Problem: The error prompts are as follows: "The OracleOracleAgent service cannot be started on the local computer. Error: 3221356559"
reason:
The Intelligent Agent stores all jobs and event requests in a series of queue files in the network/agent directory. Upon startup, the Agent compares the actual hostname of the server to the hostname stored in the queue files. If the hostname of the server changes, the Agent will not recognize the queue files and will consider them corrupt. Then, the Agent will not start.
answer:
1. Remove the and all "q" files (*.q) from the $Oracle_Home\network\agent directory
2. Re-start the Intelligent Agent.
Skill:
This fix should be done with the understanding that any jobs or events registered against that Agent will be lost. Any active jobs or registered events against this agent should be removed from OEM console before deleting the agent's *.q files.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist error
question:
After just installing Oracle 8.1.7 (the installation process is very normal), run the following operations and everything is normal.
C:\>sqlplus system/manager
SQL*Plus: Release 8.1.7.0.0 - Production on Thursday November 13 20:01:20 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connect to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL>
However, as long as you restart the computer and then run the same operation, the following problems will occur:
C:\>sqlplus system/manager
SQL*Plus: Release 8.1.7.0.0 - Production on Thursday November 13 19:28:25 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR：
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
At this time, check the Oracle process and the memory consumed is less than 10m.
But as long as Database Configuration Assistant--> is executed, after changing the database settings,
Do the above again and you will be able to run normally:
At this time, the Oracle process occupies nearly 100m of memory, which should be relatively normal.
But once you restart, it will still appear
ERROR：
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
This error can only be used after changing the database settings with Database Configuration Assistant, and the problem remains after restarting. It made me puzzled.
answer:
The database instance does not start with the computer.
1. Is there any non-PUBLIC rollback segment in the database startup parameters? If so, block it first, and then reopen it after creating the rollback segment. There should be no problem. It was successful at ORACLE 7 at that time. At that time, I created the original database configuration parameter (*.ORA) file and the above problem occurred.
2. It is recommended to start the service manually at this time and observe that if there is a prompt that the path is missing, you can refer to the above to set the relevant path.
ORA-12500: TNS: The listener cannot start the dedicated server process
status
start
/nolog
/ as sysdba
nomount
database open
Gradually decompose and find the problem.
It is possible that the file is corrupted and encountered similar problems, just reconfigure it.
Previous page123456Next pageRead the full text