Oracle 11g Debian settings Note

Installing Oracle in Linux is really troublesome. First, you need to download a database. Because Testing's Debian is used, and most of the packages used for installation are old stable, which is generally not found in the port and must be searched manually on the Debian website, some packages also have dependent packages, so they all need to go down. The Reference Manual is a pdf document that is widely circulated on the Internet.

The only difference with document installation is that I chose to directly configure a database instance during installation, and the interface is different. Pdf also provides all dependent packages, although not the versions declared by oracle (those are too old, gcc3.3, libstdc ++ 5, and so on ), however, it is indeed available, but I don't know where a database has a problem. I jumped an error during the installation process, but it seems that no problem has been found yet.

Then there is a problem with the database settings. It's silly to set it in Windows. You have to reset it yourself here.

1. Fill in $ ORACLE_HOME $ ORACLE_BASE $ ORACLE_SID in. profile, which must be consistent with the parameters during installation.

2. However, when I log on to MySQL with sqlplus and scott for the first time, an error is reported.
A ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
I checked it online, it should be that the database instance was not started, so I am dbstart $ ORACLE_HOME,
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
I had to first sqlplus/as sysdba and then start up.

3. Set listener. ora. I am not sure why I didn't set it at the beginning.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 ))
)
)
This is obviously not possible. Therefore, a few lines are added.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/var/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl. styx)
(ORACLE_HOME =/var/oracle/product/11.2.0/db_1)
(SID_NAME = orcl. styx)
)
)
Then, change the TCP connection HOST to the IP address of the Database HOST to allow remote access to the database.

4. When I use sqldeveloper to connect to the sys user of the Database Host on the client, the system always prompts that the user name and password are incorrect. After checking the password several times, the system still does not get better. I suddenly saw it on the Internet, the password file must be the same as the database instance name, so you can find $ ORACLE_HOME/dbs/and check the file name. The password file should be orapworcl. orapw is the prefix of the password file, orcl should be an Instance name ...... But my instance is orcl. styx. It is probably a problem here!
$ Cp orapworcl. styx
Then in sqlplus/as sysdba
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 499125840 bytes
Database Buffers 343932928 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
SQL>

Then you can use remote access normally. If you do not modify the password, you can use an account other than sysdba, such as scott, but sysdba will be prompted with a wrong password.

It seems that you have encountered these problems. In addition, you cannot start it yourself. You need to manually start up, And dbstart cannot be used. I don't know what's going on.