oracle

• Oracle Sample Connection String
• oracle setting

Oracle Sample Connection String

```
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = port))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
```

oracle setting

 

ORA-12518, TNS:listener could not hand off client connection

Services required to run oracle in windows

OracleOraDB19Home1TNSListener
OracleServiceorcl

If one of the services is down, create it manually :
Open command prompt
cd C:\Users\blue_\Downloads\oracle19c\bin
oradim -list
oradim -new -sid orcl -startmode auto -pfile C:\Users\blue_\Downloads\oracle19c\database\init.ora
sqlplus / as sysdba
Startup
alter system register (optional);

Check listener status
lsnrctl status
lsnrctl start
lsnrctl stop