Shutdown the databases using oradim then shut down all oracle services in management console.
Apply the patch
Then the documentation says:
For single-instance installations, use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
C:\> sqlplus /NOLOG
SQL> CONNECT SYS/password AS SYSDBA
but I get the "ORA-12514: TNS listener does not currently know of service requested in connect descriptor."
So I can't do the next bit which is "startup upgrade"
So I then tried starting the database using oradim but if I specify -starttype inst I get "ORA-01092: ORACLE instance terminated. Disconnection forced" Using -starttype srvc doesn't seem to make any difference to anything.
The only joy I had was using the web based enterprise manager to mount the database then I can connect in SQLPlus but when I issue: "startup upgrade" it says the database is already started and it must be shutdown so then I issue "shutdown" and then "startup upgrade" and I'm back to "ORA-12514: TNS listener does not currently know of service requested in connect descriptor."
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Subquery in Oracle:
Sub queries are one of advance queries in oracle.
Types of advance queries:
• Sub Queries
• Hierarchical Queries
• Set Operators
Sub queries are know as the query called from another query or another subquery. It can …
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…