Want to create a local database in oracle, convenient to build tables, mainly is for own use, excuse me how to do,

See some post said when installation there, but I input the user name system, the sa password after login, prompt without listening no listener,

Then check in the "service", is not found under the name of the oracle listener, but I open the net manager, there is a listener,

Get dizzy, first of all, my goal can log in the local server (personal use), don't know if the listener is the reason why I cannot log in, or what other reason,

To solve, thanks!

CodePudding user response:

I also just learn oracle, input "netca" on the command line, it can be configured to monitor, you can try to create a new monitor, and then open in the service

CodePudding user response:

Can "netca" new local database (private) listening, so, to establish the local database (private) to monitor and to establish a connection to other people what's different about monitoring,

After finish, with tnsnames. Ora are configured on the machine with PL/SQL,

CodePudding user response:

Is not in right now by the side of the machine, after first

CodePudding user response:

First listen to the remote link or links database tools to use, if the database server in the up sqlplus can directly is to use the
Way up sqlplus/as sysdba links database does not need to start listening
In such way link need to configure the oracle database environment variable

If use tools links need to be configured to monitor, start to monitor, and the oracle client
If there is still a problem, can add group: 144243235

CodePudding user response:

Thank you for your reply! No configuration to monitor success before, I try again later, as you say the second approach, WeChat group to have excuse me?

CodePudding user response:

I have installed on the Oracle and to listen to, and can be found in service, as follows:

But state for manual, when I start the monitoring error:


In addition, I still can't see the PL/SQL login interface before I MyFirstOracle self-built database, namely

But tnsnames. Ora has been set, is as follows:

Excuse me, how should solve,

CodePudding user response:

In fact, I'm the only function is to achieve, the self-built database MyFirstOracle before, in the PL/SQL login screen display, and be able to login, the login interface is as follows:

Excuse me, how should realize, thank you very much!

CodePudding user response:

1 to install the software and create database
2 configuration monitor
3 to configure the network service name
These three points, step-by-step,

CodePudding user response:

Steps have been completed before 1, 2, I use the network service configurator in step 3, but at the end of the connection test, can prompt:


Whether due to not start listening, so I try to start the service in the listening, or an error, as follows:


The next step how to get

CodePudding user response:

Listen, please start is what reason, please master action!

CodePudding user response:

Establish good listening, please why can't start, after an error screen look at upstairs.

CodePudding user response:

How hard is it? Install oracle server, configuration,,
You see this play, according to http://www.cnblogs.com/hongten/p/hongten_oracle_plsql.html