# oracle

# 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