"Connection oriented" means that when you want to talk to someone or something over the internet, you have to first make sure you're connected to them. Just like how you have to pick up the phone and dial someone's number to talk to them, your computer has to connect to another computer before they can send messages to each other. This is like making sure the two ends of a pipe are connected before anything can be sent through the pipe.
Once the connection is made, the two computers can start talking to each other. They can send messages back and forth, knowing that they will always get to the right place, because they are connected to each other. Just like how you can talk on the phone without worrying about someone else listening in, because you and the person you're talking to are the only ones connected, the two computers can talk to each other without interference from anyone else.
When you're done talking, you can end the connection, just like hanging up the phone. Once the connection is ended, the computers won't be able to talk to each other anymore, until they connect again. This is like removing the pipe that connected the two ends.
Overall, being "connection oriented" means making sure that you're connected to the person or thing you want to talk to, so that your messages always go to the right place and are private.